APPS.OE_CREDIT_EXPOSURE_PVT dependencies on OE_PAYMENTS

Line 5988: , oe_payments p

5984: , 1
5985:
5986: FROM
5987: OE_INIT_CREDIT_SUMM_GTT m
5988: , oe_payments p
5989: WHERE
5990: m.line_line_category_code = 'ORDER'
5991: AND p.header_id (+) = m.line_header_id
5992: AND p.line_id (+) = m.line_line_id

Line 6134: , oe_payments p

6130: , l_request_id
6131:
6132: FROM
6133: OE_INIT_CREDIT_SUMM_GTT m
6134: , oe_payments p
6135: WHERE
6136: m.line_line_category_code = 'RETURN'
6137: AND p.header_id (+) = m.line_header_id
6138: AND p.line_id (+) = m.line_line_id

Line 6274: , oe_payments p

6270: , 1
6271:
6272: FROM
6273: OE_INIT_CREDIT_SUMM_GTT m
6274: , oe_payments p
6275: WHERE
6276: m.line_line_category_code = 'ORDER'
6277: AND p.header_id (+) = m.line_header_id
6278: AND p.line_id (+) = m.line_line_id

Line 6422: , oe_payments p

6418: , l_request_id
6419:
6420: FROM
6421: OE_INIT_CREDIT_SUMM_GTT m
6422: , oe_payments p
6423: WHERE
6424: m.line_line_category_code = 'RETURN'
6425: AND p.header_id (+) = m.line_header_id
6426: AND p.line_id (+) = m.line_line_id

Line 7867: oe_payments p

7863: , 1
7864:
7865: FROM
7866: OE_INIT_CREDIT_SUMM_GTT m,
7867: oe_payments p
7868: WHERE
7869: m.line_line_category_code = 'ORDER'
7870: AND p.header_id (+) = m.line_header_id
7871: AND p.line_id (+) = m.line_line_id

Line 8043: , oe_payments p

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

Line 8234: , oe_payments p

8230: , 1
8231:
8232: FROM
8233: OE_INIT_CREDIT_SUMM_GTT m
8234: , oe_payments p
8235: WHERE
8236: m.line_line_category_code = 'ORDER'
8237: AND p.header_id (+) = m.line_header_id
8238: AND p.line_id (+) = m.line_line_id

Line 8402: , oe_payments p

8398: , l_request_id
8399:
8400: FROM
8401: OE_INIT_CREDIT_SUMM_GTT m
8402: , oe_payments p
8403: WHERE
8404: m.line_line_category_code = 'RETURN'
8405: AND p.header_id (+) = m.line_header_id
8406: AND p.line_id (+) = m.line_line_id