APPS.OE_CREDIT_EXPOSURE_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 5165: , hz_cust_acct_sites_all s

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
5169: , hz_cust_accounts ca_l

Line 5168: , hz_cust_acct_sites_all s_l

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'
5172: AND h.open_flag = 'Y'

Line 5223: , hz_cust_acct_sites_all s

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
5227: , hz_cust_accounts ca_l

Line 5226: , hz_cust_acct_sites_all s_l

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
5230: AND h.booked_flag = 'Y'

Line 6210: , hz_cust_acct_sites_all s

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
6214: AND p.header_id = h.header_id

Line 6269: , hz_cust_acct_sites_all s

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
6273: p.line_id IS NULL

Line 6375: , hz_cust_acct_sites_all s

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
6379: AND p.header_id = h.header_id

Line 6433: , hz_cust_acct_sites_all s

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
6437: p.line_id IS NULL

Line 6715: , hz_cust_acct_sites_all s

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
6719:

Line 7571: , hz_cust_acct_sites_all s

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
7575: AND p.header_id = h.header_id

Line 7672: , hz_cust_acct_sites_all s

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
7676: AND p.header_id = h.header_id