APPS.OE_CREDIT_EXPOSURE_PVT dependencies on OE_INIT_CREDIT_SUMM_GTT

Line 5110: INSERT INTO OE_INIT_CREDIT_SUMM_GTT

5106: oe_debug_pub.add( 'Create Past Due Invoice Balance : '||l_past_due_bal);
5107: oe_debug_pub.add( 'Create Orders on Hold Balance : '||l_order_hold_bal);
5108: oe_debug_pub.add( 'Create Freight Charges Balance : '||l_freight_bal);
5109:
5110: INSERT INTO OE_INIT_CREDIT_SUMM_GTT
5111: (line_ordered_quantity ,
5112: line_unit_selling_price,
5113: order_invoice_to_org_id,
5114: rl_amount,

Line 5326: OE_INIT_CREDIT_SUMM_GTT m

5322: , l_request_id
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

Line 5395: OE_INIT_CREDIT_SUMM_GTT m

5391: , l_request_id
5392: , 1
5393:
5394: FROM
5395: OE_INIT_CREDIT_SUMM_GTT m
5396: WHERE
5397: m.line_line_category_code = 'ORDER'
5398: GROUP BY
5399: m.order_invoice_to_org_id

Line 5466: OE_INIT_CREDIT_SUMM_GTT m

5462: , SYSDATE
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

Line 5530: OE_INIT_CREDIT_SUMM_GTT m

5526: , SYSDATE
5527: , l_request_id
5528:
5529: FROM
5530: OE_INIT_CREDIT_SUMM_GTT m
5531: WHERE
5532: m.line_line_category_code = 'RETURN'
5533: GROUP BY
5534: m.order_invoice_to_org_id

Line 5602: OE_INIT_CREDIT_SUMM_GTT m

5598: , l_request_id
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

Line 5671: OE_INIT_CREDIT_SUMM_GTT m

5667: , l_request_id
5668: , 1
5669:
5670: FROM
5671: OE_INIT_CREDIT_SUMM_GTT m
5672: WHERE
5673: m.line_line_category_code = 'ORDER'
5674: GROUP BY
5675: m.line_invoice_to_org_id

Line 5746: OE_INIT_CREDIT_SUMM_GTT m

5742: , SYSDATE
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

Line 5810: OE_INIT_CREDIT_SUMM_GTT m

5806: , SYSDATE
5807: , l_request_id
5808:
5809: FROM
5810: OE_INIT_CREDIT_SUMM_GTT m
5811: WHERE
5812: m.line_line_category_code = 'RETURN'
5813: GROUP BY
5814: m.line_invoice_to_org_id

Line 5883: OE_INIT_CREDIT_SUMM_GTT m,

5879: , l_request_id
5880: , 1
5881:
5882: FROM
5883: OE_INIT_CREDIT_SUMM_GTT m,
5884: oe_price_adjustments p
5885: WHERE
5886: p.line_id = m.line_line_id
5887: AND p.header_id = m.line_header_id

Line 5965: OE_INIT_CREDIT_SUMM_GTT m

5961: , l_request_id
5962:
5963: FROM
5964: oe_price_adjustments p,
5965: OE_INIT_CREDIT_SUMM_GTT m
5966: WHERE
5967: p.line_id = m.line_line_id
5968: AND p.header_id = m.line_header_id
5969: AND p.header_id = m.order_header_id

Line 6047: OE_INIT_CREDIT_SUMM_GTT m

6043: , l_request_id
6044: , 1
6045:
6046: FROM oe_price_adjustments p,
6047: OE_INIT_CREDIT_SUMM_GTT m
6048: WHERE
6049: p.line_id = m.line_line_id
6050: AND p.header_id = m.line_header_id
6051: AND p.header_id = m.order_header_id

Line 6129: OE_INIT_CREDIT_SUMM_GTT m

6125: , SYSDATE
6126: , l_request_id
6127:
6128: FROM oe_price_adjustments p,
6129: OE_INIT_CREDIT_SUMM_GTT m
6130: WHERE
6131: p.line_id = m.line_line_id
6132: AND p.header_id = m.line_header_id
6133: AND p.header_id = m.order_header_id

Line 6542: OE_INIT_CREDIT_SUMM_GTT m,

6538: , l_request_id
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

Line 6624: OE_INIT_CREDIT_SUMM_GTT m

6620: , l_request_id
6621: , 1
6622:
6623: FROM
6624: OE_INIT_CREDIT_SUMM_GTT m
6625: WHERE
6626: m.line_line_category_code = 'ORDER'
6627: AND EXISTS
6628: ( SELECT 1

Line 6815: OE_INIT_CREDIT_SUMM_GTT m

6811: , SYSDATE
6812: , l_request_id
6813:
6814: FROM
6815: OE_INIT_CREDIT_SUMM_GTT m
6816: WHERE
6817: m.line_line_category_code = 'RETURN'
6818: AND EXISTS
6819: ( SELECT 1

Line 6897: OE_INIT_CREDIT_SUMM_GTT m

6893: , l_request_id
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

Line 6976: OE_INIT_CREDIT_SUMM_GTT m

6972: , l_request_id
6973: , 1
6974:
6975: FROM
6976: OE_INIT_CREDIT_SUMM_GTT m
6977: WHERE
6978: m.line_line_category_code = 'ORDER'
6979: AND EXISTS
6980: ( SELECT 1

Line 7060: OE_INIT_CREDIT_SUMM_GTT m

7056: , SYSDATE
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

Line 7134: OE_INIT_CREDIT_SUMM_GTT m

7130: , SYSDATE
7131: , l_request_id
7132:
7133: FROM
7134: OE_INIT_CREDIT_SUMM_GTT m
7135: WHERE
7136: m.line_line_category_code = 'RETURN'
7137: AND EXISTS
7138: ( SELECT 1

Line 7216: OE_INIT_CREDIT_SUMM_GTT m

7212: , 1
7213:
7214: FROM
7215: oe_price_adjustments p,
7216: OE_INIT_CREDIT_SUMM_GTT m
7217: WHERE
7218: p.line_id = m.line_line_id
7219: AND p.header_id = m.line_header_id
7220: AND p.header_id = m.order_header_id

Line 7306: OE_INIT_CREDIT_SUMM_GTT m

7302: , l_request_id
7303:
7304: FROM
7305: oe_price_adjustments p,
7306: OE_INIT_CREDIT_SUMM_GTT m
7307: WHERE
7308: p.line_id = m.line_line_id
7309: AND p.header_id = m.line_header_id
7310: AND p.header_id = m.order_header_id

Line 7395: OE_INIT_CREDIT_SUMM_GTT m

7391: , l_request_id
7392: , 1
7393:
7394: FROM oe_price_adjustments p,
7395: OE_INIT_CREDIT_SUMM_GTT m
7396: WHERE
7397: p.line_id = m.line_line_id
7398: AND p.header_id = m.line_header_id
7399: AND p.header_id = m.order_header_id

Line 7485: OE_INIT_CREDIT_SUMM_GTT m

7481: , SYSDATE
7482: , l_request_id
7483:
7484: FROM oe_price_adjustments p,
7485: OE_INIT_CREDIT_SUMM_GTT m
7486: WHERE
7487: p.line_id = m.line_line_id
7488: AND p.header_id = m.line_header_id
7489: AND p.header_id = m.order_header_id