DBA Data[Home] [Help]

APPS.OE_CREDIT_EXPOSURE_PVT dependencies on OE_PAYMENTS

Line 5327: , oe_payments p

5323: , 1
5324:
5325: FROM
5326: OE_INIT_CREDIT_SUMM_GTT m
5327: , oe_payments p
5328: WHERE
5329: m.line_line_category_code = 'ORDER'
5330: AND p.header_id (+) = m.line_header_id
5331: AND p.line_id (+) = m.line_line_id

Line 5467: , oe_payments p

5463: , l_request_id
5464:
5465: FROM
5466: OE_INIT_CREDIT_SUMM_GTT m
5467: , oe_payments p
5468: WHERE
5469: m.line_line_category_code = 'RETURN'
5470: AND p.header_id (+) = m.line_header_id
5471: AND p.line_id (+) = m.line_line_id

Line 5603: , oe_payments p

5599: , 1
5600:
5601: FROM
5602: OE_INIT_CREDIT_SUMM_GTT m
5603: , oe_payments p
5604: WHERE
5605: m.line_line_category_code = 'ORDER'
5606: AND p.header_id (+) = m.line_header_id
5607: AND p.line_id (+) = m.line_line_id

Line 5747: , oe_payments p

5743: , l_request_id
5744:
5745: FROM
5746: OE_INIT_CREDIT_SUMM_GTT m
5747: , oe_payments p
5748: WHERE
5749: m.line_line_category_code = 'RETURN'
5750: AND p.header_id (+) = m.line_header_id
5751: AND p.line_id (+) = m.line_line_id

Line 6543: oe_payments p

6539: , 1
6540:
6541: FROM
6542: OE_INIT_CREDIT_SUMM_GTT m,
6543: oe_payments p
6544: WHERE
6545: m.line_line_category_code = 'ORDER'
6546: AND p.header_id (+) = m.line_header_id
6547: AND p.line_id (+) = m.line_line_id

Line 6713: , oe_payments p

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

Line 6898: , oe_payments p

6894: , 1
6895:
6896: FROM
6897: OE_INIT_CREDIT_SUMM_GTT m
6898: , oe_payments p
6899: WHERE
6900: m.line_line_category_code = 'ORDER'
6901: AND p.header_id (+) = m.line_header_id
6902: AND p.line_id (+) = m.line_line_id

Line 7061: , oe_payments p

7057: , l_request_id
7058:
7059: FROM
7060: OE_INIT_CREDIT_SUMM_GTT m
7061: , oe_payments p
7062: WHERE
7063: m.line_line_category_code = 'RETURN'
7064: AND p.header_id (+) = m.line_header_id
7065: AND p.line_id (+) = m.line_line_id