APPS.OE_CREDIT_EXPOSURE_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 5774: , hz_cust_site_uses_all su

5770: ca_l.party_id line_party_id,
5771: -999 interface_line_attribute6 --TaxER
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

Line 5777: , hz_cust_site_uses_all su_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
5781: AND h.booked_flag = 'Y'

Line 5859: , hz_cust_site_uses_all su

5855: ca_l.party_id line_party_id,
5856: DECODE(OE_CREDIT_EXPOSURE_PVT.Is_Equal(rl.interface_line_attribute6,l.line_id),'Y',-999,to_number(rl.interface_line_attribute6)) interface_line_attribute6 --TaxER
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

Line 5862: , hz_cust_site_uses_all su_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
5866: where h.header_id = l.header_id

Line 7213: , hz_cust_site_uses_all su

7209:
7210: FROM
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

Line 7272: , hz_cust_site_uses_all su

7268:
7269: FROM
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

Line 7368: , hz_cust_site_uses_all su

7364:
7365: FROM
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

Line 7429: , hz_cust_site_uses_all su

7425:
7426: FROM
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

Line 7541: , hz_cust_site_uses_all su

7537:
7538: FROM
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

Line 7599: , hz_cust_site_uses_all su

7595:
7596: FROM
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

Line 7692: , hz_cust_site_uses_all su

7688:
7689: FROM
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

Line 7752: , hz_cust_site_uses_all su

7748:
7749: FROM
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

Line 8044: , hz_cust_site_uses_all su

8040: FROM
8041: oe_order_lines_all l
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

Line 9284: , hz_cust_site_uses_all su

9280:
9281: FROM
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

Line 9379: , hz_cust_site_uses_all su

9375:
9376: FROM
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

Line 9487: , hz_cust_site_uses_all su

9483:
9484: FROM
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

Line 9581: , hz_cust_site_uses_all su

9577:
9578: FROM
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

Line 9689: , hz_cust_site_uses_all su

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')
9693: AND ca.cust_account_id = sch.customer_id

Line 9769: , hz_cust_site_uses_all su

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'
9773: AND NVL( cr.confirmed_flag, 'Y' ) = 'Y'

Line 9864: , hz_cust_site_uses_all su

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')
9868: AND ca.cust_account_id = sch.customer_id

Line 9943: , hz_cust_site_uses_all su

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'
9947: AND NVL( cr.confirmed_flag, 'Y' ) = 'Y'