APPS.OE_CREDIT_EXPOSURE_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 5164: , hz_cust_site_uses_all su

5160: s_l.cust_account_id line_cust_account_id,
5161: ca_l.party_id line_party_id
5162: from oe_order_lines_all l
5163: , oe_order_headers_all h
5164: , hz_cust_site_uses_all su
5165: , hz_cust_acct_sites_all s
5166: , hz_cust_accounts ca
5167: , hz_cust_site_uses_all su_l
5168: , hz_cust_acct_sites_all s_l

Line 5167: , hz_cust_site_uses_all su_l

5163: , oe_order_headers_all h
5164: , hz_cust_site_uses_all su
5165: , hz_cust_acct_sites_all s
5166: , hz_cust_accounts ca
5167: , hz_cust_site_uses_all su_l
5168: , hz_cust_acct_sites_all s_l
5169: , hz_cust_accounts ca_l
5170: where h.header_id = l.header_id
5171: AND h.booked_flag = 'Y'

Line 5222: , hz_cust_site_uses_all su

5218: s_l.cust_account_id line_cust_account_id,
5219: ca_l.party_id line_party_id
5220: from oe_order_lines_all l
5221: , oe_order_headers_all h
5222: , hz_cust_site_uses_all su
5223: , hz_cust_acct_sites_all s
5224: , hz_cust_accounts ca
5225: , hz_cust_site_uses_all su_l
5226: , hz_cust_acct_sites_all s_l

Line 5225: , hz_cust_site_uses_all su_l

5221: , oe_order_headers_all h
5222: , hz_cust_site_uses_all su
5223: , hz_cust_acct_sites_all s
5224: , hz_cust_accounts ca
5225: , hz_cust_site_uses_all su_l
5226: , hz_cust_acct_sites_all s_l
5227: , hz_cust_accounts ca_l
5228: , ra_interface_lines_all rl
5229: where h.header_id = l.header_id

Line 6209: , hz_cust_site_uses_all su

6205:
6206: FROM
6207: oe_price_adjustments p
6208: , oe_order_headers_all h
6209: , hz_cust_site_uses_all su
6210: , hz_cust_acct_sites_all s
6211: , hz_cust_accounts ca
6212: WHERE
6213: p.line_id IS NULL

Line 6268: , hz_cust_site_uses_all su

6264:
6265: FROM
6266: oe_price_adjustments p
6267: , oe_order_headers_all h
6268: , hz_cust_site_uses_all su
6269: , hz_cust_acct_sites_all s
6270: , hz_cust_accounts ca
6271: , ra_interface_lines_all rl
6272: WHERE

Line 6374: , hz_cust_site_uses_all su

6370:
6371: FROM
6372: oe_price_adjustments p
6373: , oe_order_headers_all h
6374: , hz_cust_site_uses_all su
6375: , hz_cust_acct_sites_all s
6376: , hz_cust_accounts ca
6377: WHERE
6378: p.line_id IS NULL

Line 6432: , hz_cust_site_uses_all su

6428:
6429: FROM
6430: oe_price_adjustments p
6431: , oe_order_headers_all h
6432: , hz_cust_site_uses_all su
6433: , hz_cust_acct_sites_all s
6434: , hz_cust_accounts ca
6435: , ra_interface_lines_all rl
6436: WHERE

Line 6714: , hz_cust_site_uses_all su

6710: FROM
6711: oe_order_lines_all l
6712: , oe_order_headers_all h
6713: , oe_payments p
6714: , hz_cust_site_uses_all su
6715: , hz_cust_acct_sites_all s
6716: , hz_cust_accounts ca
6717: WHERE
6718: h.header_id = l.header_id

Line 7570: , hz_cust_site_uses_all su

7566:
7567: FROM
7568: oe_price_adjustments p
7569: , oe_order_headers_all h
7570: , hz_cust_site_uses_all su
7571: , hz_cust_acct_sites_all s
7572: , hz_cust_accounts ca
7573: WHERE
7574: p.line_id IS NULL

Line 7671: , hz_cust_site_uses_all su

7667:
7668: FROM
7669: oe_price_adjustments p
7670: , oe_order_headers_all h
7671: , hz_cust_site_uses_all su
7672: , hz_cust_acct_sites_all s
7673: , hz_cust_accounts ca
7674: WHERE
7675: p.line_id IS NULL

Line 7773: , hz_cust_site_uses_all su

7769:
7770: FROM
7771: ar_payment_schedules_all sch ,
7772: hz_cust_accounts ca
7773: , hz_cust_site_uses_all su
7774: WHERE
7775: NVL( receipt_confirmed_flag, 'Y' ) = 'Y'
7776: AND gl_date_closed = to_date( '31-12-4712', 'DD-MM-YYYY')
7777: AND ca.cust_account_id = sch.customer_id

Line 7850: , hz_cust_site_uses_all su

7846: FROM
7847: ar_cash_receipts_all cr
7848: , ar_cash_receipt_history_all crh
7849: , hz_cust_accounts ca
7850: , hz_cust_site_uses_all su
7851: WHERE
7852: cr.cash_receipt_id = crh.cash_receipt_id
7853: AND crh.current_record_flag = 'Y'
7854: AND NVL( cr.confirmed_flag, 'Y' ) = 'Y'

Line 7942: , hz_cust_site_uses_all su

7938:
7939: FROM
7940: ar_payment_schedules_all sch ,
7941: hz_cust_accounts ca
7942: , hz_cust_site_uses_all su
7943: WHERE
7944: NVL( receipt_confirmed_flag, 'Y' ) = 'Y'
7945: AND gl_date_closed = to_date( '31-12-4712', 'DD-MM-YYYY')
7946: AND ca.cust_account_id = sch.customer_id

Line 8019: , hz_cust_site_uses_all su

8015: FROM
8016: ar_cash_receipts_all cr
8017: , ar_cash_receipt_history_all crh
8018: , hz_cust_accounts ca
8019: , hz_cust_site_uses_all su
8020: WHERE
8021: cr.cash_receipt_id = crh.cash_receipt_id
8022: AND crh.current_record_flag = 'Y'
8023: AND NVL( cr.confirmed_flag, 'Y' ) = 'Y'