APPS.OE_CREDIT_EXPOSURE_PVT dependencies on HZ_CUST_ACCOUNTS

Line 5166: , hz_cust_accounts ca

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
5170: where h.header_id = l.header_id

Line 5169: , hz_cust_accounts ca_l

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'
5173: AND l.open_flag = 'Y'

Line 5224: , hz_cust_accounts ca

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
5228: , ra_interface_lines_all rl

Line 5227: , hz_cust_accounts ca_l

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'
5231: AND rl.orig_system_bill_customer_id = ca.cust_account_id

Line 6211: , hz_cust_accounts ca

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
6215: AND h.order_category_code IN ('ORDER','MIXED')

Line 6270: , hz_cust_accounts ca

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

Line 6376: , hz_cust_accounts ca

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
6380: AND h.order_category_code ='RETURN'

Line 6434: , hz_cust_accounts ca

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

Line 6716: , hz_cust_accounts ca

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

Line 7572: , hz_cust_accounts ca

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
7576: AND h.order_category_code IN ('ORDER','MIXED')

Line 7673: , hz_cust_accounts ca

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
7677: AND h.order_category_code = 'RETURN'

Line 7772: hz_cust_accounts ca

7768: , 1
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')

Line 7849: , hz_cust_accounts ca

7845:
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'

Line 7941: hz_cust_accounts ca

7937: , 1
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')

Line 8018: , hz_cust_accounts ca

8014:
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'

Line 8112: hz_cust_accounts ca

8108: , 1
8109:
8110: FROM
8111: ar_payment_schedules_all sch ,
8112: hz_cust_accounts ca
8113: WHERE
8114: NVL( receipt_confirmed_flag, 'Y' ) = 'Y'
8115: AND gl_date_closed = to_date( '31-12-4712', 'DD-MM-YYYY')
8116: AND ca.cust_account_id = sch.customer_id