[Home] [Help]
5772: from oe_order_lines_all l
5773: , oe_order_headers_all h
5774: , hz_cust_site_uses_all su
5775: , hz_cust_acct_sites_all s
5776: , hz_cust_accounts ca
5777: , hz_cust_site_uses_all su_l
5778: , hz_cust_acct_sites_all s_l
5779: , hz_cust_accounts ca_l
5780: where h.header_id = l.header_id
5775: , hz_cust_acct_sites_all s
5776: , hz_cust_accounts ca
5777: , hz_cust_site_uses_all su_l
5778: , hz_cust_acct_sites_all s_l
5779: , hz_cust_accounts ca_l
5780: where h.header_id = l.header_id
5781: AND h.booked_flag = 'Y'
5782: AND h.open_flag = 'Y'
5783: AND l.open_flag = 'Y'
5857: from oe_order_lines_all l
5858: , oe_order_headers_all h
5859: , hz_cust_site_uses_all su
5860: , hz_cust_acct_sites_all s
5861: , hz_cust_accounts ca
5862: , hz_cust_site_uses_all su_l
5863: , hz_cust_acct_sites_all s_l
5864: , hz_cust_accounts ca_l
5865: , ra_interface_lines_all rl
5860: , hz_cust_acct_sites_all s
5861: , hz_cust_accounts ca
5862: , hz_cust_site_uses_all su_l
5863: , hz_cust_acct_sites_all s_l
5864: , hz_cust_accounts ca_l
5865: , ra_interface_lines_all rl
5866: where h.header_id = l.header_id
5867: AND h.booked_flag = 'Y'
5868: AND rl.orig_system_bill_customer_id = ca.cust_account_id
7211: oe_price_adjustments p
7212: , oe_order_headers_all h
7213: , hz_cust_site_uses_all su
7214: , hz_cust_acct_sites_all s
7215: , hz_cust_accounts ca
7216: WHERE
7217: p.line_id IS NULL
7218: AND p.header_id = h.header_id
7219: AND h.order_category_code IN ('ORDER','MIXED')
7270: oe_price_adjustments p
7271: , oe_order_headers_all h
7272: , hz_cust_site_uses_all su
7273: , hz_cust_acct_sites_all s
7274: , hz_cust_accounts ca
7275: , ra_interface_lines_all rl
7276: WHERE
7277: p.line_id IS NULL
7278: AND p.header_id = h.header_id
7366: oe_price_adjustments p
7367: , oe_order_headers_all h
7368: , hz_cust_site_uses_all su
7369: , hz_cust_acct_sites_all s
7370: , hz_cust_accounts ca
7371: WHERE
7372: p.line_id IS NULL
7373: AND p.header_id = h.header_id
7374: AND h.order_category_code IN ('ORDER','MIXED')
7427: oe_price_adjustments p
7428: , oe_order_headers_all h
7429: , hz_cust_site_uses_all su
7430: , hz_cust_acct_sites_all s
7431: , hz_cust_accounts ca
7432: , ra_interface_lines_all rl
7433: WHERE
7434: p.line_id IS NULL
7435: AND p.header_id = h.header_id
7539: oe_price_adjustments p
7540: , oe_order_headers_all h
7541: , hz_cust_site_uses_all su
7542: , hz_cust_acct_sites_all s
7543: , hz_cust_accounts ca
7544: WHERE
7545: p.line_id IS NULL
7546: AND p.header_id = h.header_id
7547: AND h.order_category_code ='RETURN'
7597: oe_price_adjustments p
7598: , oe_order_headers_all h
7599: , hz_cust_site_uses_all su
7600: , hz_cust_acct_sites_all s
7601: , hz_cust_accounts ca
7602: , ra_interface_lines_all rl
7603: WHERE
7604: p.line_id IS NULL
7605: AND p.header_id = h.header_id
7690: oe_price_adjustments p
7691: , oe_order_headers_all h
7692: , hz_cust_site_uses_all su
7693: , hz_cust_acct_sites_all s
7694: , hz_cust_accounts ca
7695: WHERE
7696: p.line_id IS NULL
7697: AND p.header_id = h.header_id
7698: AND h.order_category_code ='RETURN'
7750: oe_price_adjustments p
7751: , oe_order_headers_all h
7752: , hz_cust_site_uses_all su
7753: , hz_cust_acct_sites_all s
7754: , hz_cust_accounts ca
7755: , ra_interface_lines_all rl
7756: WHERE
7757: p.line_id IS NULL
7758: AND p.header_id = h.header_id
8042: , oe_order_headers_all h
8043: , oe_payments p
8044: , hz_cust_site_uses_all su
8045: , hz_cust_acct_sites_all s
8046: , hz_cust_accounts ca
8047: WHERE
8048: h.header_id = l.header_id
8049:
8050: AND h.booked_flag = 'Y'
9282: oe_price_adjustments p
9283: , oe_order_headers_all h
9284: , hz_cust_site_uses_all su
9285: , hz_cust_acct_sites_all s
9286: , hz_cust_accounts ca
9287: WHERE
9288: p.line_id IS NULL
9289: AND p.header_id = h.header_id
9290: AND h.order_category_code IN ('ORDER','MIXED')
9377: oe_price_adjustments p
9378: , oe_order_headers_all h
9379: , hz_cust_site_uses_all su
9380: , hz_cust_acct_sites_all s
9381: , hz_cust_accounts ca
9382: WHERE
9383: p.line_id IS NULL
9384: AND p.header_id = h.header_id
9385: AND h.order_category_code IN ('ORDER','MIXED')
9485: oe_price_adjustments p
9486: , oe_order_headers_all h
9487: , hz_cust_site_uses_all su
9488: , hz_cust_acct_sites_all s
9489: , hz_cust_accounts ca
9490: WHERE
9491: p.line_id IS NULL
9492: AND p.header_id = h.header_id
9493: AND h.order_category_code = 'RETURN'
9579: oe_price_adjustments p
9580: , oe_order_headers_all h
9581: , hz_cust_site_uses_all su
9582: , hz_cust_acct_sites_all s
9583: , hz_cust_accounts ca
9584: WHERE
9585: p.line_id IS NULL
9586: AND p.header_id = h.header_id
9587: AND h.order_category_code = 'RETURN'
9684: , 1
9685:
9686: FROM
9687: ar_payment_schedules_all sch ,
9688: hz_cust_accounts ca
9689: , hz_cust_site_uses_all su
9690: WHERE
9691: NVL( receipt_confirmed_flag, 'Y' ) = 'Y'
9692: AND gl_date_closed = to_date( '31-12-4712', 'DD-MM-YYYY')
9764:
9765: FROM
9766: ar_cash_receipts_all cr
9767: , ar_cash_receipt_history_all crh
9768: , hz_cust_accounts ca
9769: , hz_cust_site_uses_all su
9770: WHERE
9771: cr.cash_receipt_id = crh.cash_receipt_id
9772: AND crh.current_record_flag = 'Y'
9859: , 1
9860:
9861: FROM
9862: ar_payment_schedules_all sch ,
9863: hz_cust_accounts ca
9864: , hz_cust_site_uses_all su
9865: WHERE
9866: NVL( receipt_confirmed_flag, 'Y' ) = 'Y'
9867: AND gl_date_closed = to_date( '31-12-4712', 'DD-MM-YYYY')
9938:
9939: FROM
9940: ar_cash_receipts_all cr
9941: , ar_cash_receipt_history_all crh
9942: , hz_cust_accounts ca
9943: , hz_cust_site_uses_all su
9944: WHERE
9945: cr.cash_receipt_id = crh.cash_receipt_id
9946: AND crh.current_record_flag = 'Y'
10036: , 1
10037:
10038: FROM
10039: ar_payment_schedules_all sch ,
10040: hz_cust_accounts ca
10041: WHERE
10042: NVL( receipt_confirmed_flag, 'Y' ) = 'Y'
10043: AND gl_date_closed = to_date( '31-12-4712', 'DD-MM-YYYY')
10044: AND ca.cust_account_id = sch.customer_id