AR Invoice grouping rule from RA_INTERFACE_LINES_ALL

1SELECT AGREEMENT_ID,
2       COMMENTS,
3       CONS_BILLING_NUMBER,
4       CONVERSION_DATE,
5       CONVERSION_RATE,
6       CONVERSION_TYPE,
7       CREDIT_METHOD_FOR_ACCT_RULE,
8       CREDIT_METHOD_FOR_INSTALLMENTS,
9       CURRENCY_CODE,
10       CUSTOMER_BANK_ACCOUNT_ID,
11       CUST_TRX_TYPE_ID,
12       DOCUMENT_NUMBER,
13       DOCUMENT_NUMBER_SEQUENCE_ID,
14       GL_DATE,
15       HEADER_ATTRIBUTE1,
16       HEADER_ATTRIBUTE2,
17       HEADER_ATTRIBUTE3,
18       HEADER_ATTRIBUTE4,
19       HEADER_ATTRIBUTE5,
20       HEADER_ATTRIBUTE6,
21       HEADER_ATTRIBUTE7,
22       HEADER_ATTRIBUTE8,
23       HEADER_ATTRIBUTE9,
24       HEADER_ATTRIBUTE10,
25       HEADER_ATTRIBUTE11,
26       HEADER_ATTRIBUTE12,
27       HEADER_ATTRIBUTE13,
28       HEADER_ATTRIBUTE14,
29       HEADER_ATTRIBUTE15,
30       HEADER_ATTRIBUTE_CATEGORY,
31       HEADER_GDF_ATTRIBUTE1,
32       HEADER_GDF_ATTRIBUTE2,
33       HEADER_GDF_ATTRIBUTE3,
34       HEADER_GDF_ATTRIBUTE4,
35       HEADER_GDF_ATTRIBUTE5,
36       HEADER_GDF_ATTRIBUTE6,
37       HEADER_GDF_ATTRIBUTE7,
38       HEADER_GDF_ATTRIBUTE8,
39       HEADER_GDF_ATTRIBUTE9,
40       HEADER_GDF_ATTRIBUTE10,
41       HEADER_GDF_ATTRIBUTE11,
42       HEADER_GDF_ATTRIBUTE12,
43       HEADER_GDF_ATTRIBUTE13,
44       HEADER_GDF_ATTRIBUTE14,
45       HEADER_GDF_ATTRIBUTE15,
46       HEADER_GDF_ATTRIBUTE16,
47       HEADER_GDF_ATTRIBUTE17,
48       HEADER_GDF_ATTRIBUTE18,
49       HEADER_GDF_ATTRIBUTE19,
50       HEADER_GDF_ATTRIBUTE20,
51       HEADER_GDF_ATTRIBUTE21,
52       HEADER_GDF_ATTRIBUTE22,
53       HEADER_GDF_ATTRIBUTE23,
54       HEADER_GDF_ATTRIBUTE24,
55       HEADER_GDF_ATTRIBUTE25,
56       HEADER_GDF_ATTRIBUTE26,
57       HEADER_GDF_ATTRIBUTE27,
58       HEADER_GDF_ATTRIBUTE28,
59       HEADER_GDF_ATTRIBUTE29,
60       HEADER_GDF_ATTRIBUTE30,
61       INITIAL_CUSTOMER_TRX_ID,
62       INTERNAL_NOTES,
63       INVOICING_RULE_ID,
64       ORIG_SYSTEM_BILL_ADDRESS_ID,
65       ORIG_SYSTEM_BILL_CONTACT_ID,
66       ORIG_SYSTEM_BILL_CUSTOMER_ID,
67       ORIG_SYSTEM_SHIP_CONTACT_ID,
68       ORIG_SYSTEM_SHIP_CUSTOMER_ID,
69       ORIG_SYSTEM_SOLD_CUSTOMER_ID,
70       ORIG_SYSTEM_BATCH_NAME,
71       PAYMENT_SET_ID,
72       PREVIOUS_CUSTOMER_TRX_ID,
73       PRIMARY_SALESREP_ID,
74       PRINTING_OPTION,
75       PURCHASE_ORDER,
76       PURCHASE_ORDER_DATE,
77       PURCHASE_ORDER_REVISION,
78       REASON_CODE,
79       RECEIPT_METHOD_ID,
80       RELATED_CUSTOMER_TRX_ID,
81       SET_OF_BOOKS_ID,
82       TERM_ID,
83       TERRITORY_ID,
84       TRX_DATE,
85       TRX_NUMBER
86  FROM RA_INTERFACE_LINES_ALL
87 WHERE INTERFACE_LINE_ATTRIBUTE1 = '&sales_order'