eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CREDIT_EXPOSURE_PVT dependencies on OE_INIT_CREDIT_SUMM_GTT

Line 5717: INSERT INTO OE_INIT_CREDIT_SUMM_GTT

5713: END IF;
5714: --14689044 end
5715:
5716:
5717: INSERT INTO OE_INIT_CREDIT_SUMM_GTT
5718: (line_ordered_quantity ,
5719: line_unit_selling_price,
5720: order_invoice_to_org_id,
5721: rl_amount,

Line 5987: OE_INIT_CREDIT_SUMM_GTT m

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

Line 6059: OE_INIT_CREDIT_SUMM_GTT m

6055: , l_request_id
6056: , 1
6057:
6058: FROM
6059: OE_INIT_CREDIT_SUMM_GTT m
6060: WHERE
6061: m.line_line_category_code = 'ORDER'
6062: AND m.interface_line_attribute6 = -999 --TaxER
6063: GROUP BY

Line 6133: OE_INIT_CREDIT_SUMM_GTT m

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

Line 6200: OE_INIT_CREDIT_SUMM_GTT m

6196: , SYSDATE
6197: , l_request_id
6198:
6199: FROM
6200: OE_INIT_CREDIT_SUMM_GTT m
6201: WHERE
6202: m.line_line_category_code = 'RETURN'
6203: AND m.interface_line_attribute6 = -999 --TaxER
6204: GROUP BY

Line 6273: OE_INIT_CREDIT_SUMM_GTT m

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

Line 6343: OE_INIT_CREDIT_SUMM_GTT m

6339: , l_request_id
6340: , 1
6341:
6342: FROM
6343: OE_INIT_CREDIT_SUMM_GTT m
6344: WHERE
6345: m.line_line_category_code = 'ORDER'
6346: AND m.interface_line_attribute6 = -999 --TaxER
6347: GROUP BY

Line 6421: OE_INIT_CREDIT_SUMM_GTT m

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

Line 6488: OE_INIT_CREDIT_SUMM_GTT m

6484: , SYSDATE
6485: , l_request_id
6486:
6487: FROM
6488: OE_INIT_CREDIT_SUMM_GTT m
6489: WHERE
6490: m.line_line_category_code = 'RETURN'
6491: AND m.interface_line_attribute6 = -999 --TaxER
6492: GROUP BY

Line 6564: OE_INIT_CREDIT_SUMM_GTT m,

6560: , l_request_id
6561: , 1
6562:
6563: FROM
6564: OE_INIT_CREDIT_SUMM_GTT m,
6565: oe_price_adjustments p
6566: WHERE
6567: p.line_id = m.line_line_id
6568: AND p.header_id = m.line_header_id

Line 6637: OE_INIT_CREDIT_SUMM_GTT m,

6633: , l_request_id
6634: , 1
6635:
6636: FROM
6637: OE_INIT_CREDIT_SUMM_GTT m,
6638: oe_price_adjustments p,
6639: oe_price_adjustments p1 --TaxER
6640: WHERE
6641: p.line_id = m.line_line_id

Line 6729: OE_INIT_CREDIT_SUMM_GTT m

6725: , l_request_id
6726:
6727: FROM
6728: oe_price_adjustments p,
6729: OE_INIT_CREDIT_SUMM_GTT m
6730: WHERE
6731: p.line_id = m.line_line_id
6732: AND p.header_id = m.line_header_id
6733: AND p.header_id = m.order_header_id

Line 6798: OE_INIT_CREDIT_SUMM_GTT m,

6794: , SYSDATE
6795: , l_request_id
6796:
6797: FROM
6798: OE_INIT_CREDIT_SUMM_GTT m,
6799: oe_price_adjustments p,
6800: oe_price_adjustments p1 --TaxER
6801: WHERE
6802: p.line_id = m.line_line_id

Line 6890: OE_INIT_CREDIT_SUMM_GTT m

6886: , l_request_id
6887: , 1
6888:
6889: FROM oe_price_adjustments p,
6890: OE_INIT_CREDIT_SUMM_GTT m
6891: WHERE
6892: p.line_id = m.line_line_id
6893: AND p.header_id = m.line_header_id
6894: AND p.header_id = m.order_header_id

Line 6964: OE_INIT_CREDIT_SUMM_GTT m

6960: , 1
6961:
6962: FROM oe_price_adjustments p,
6963: oe_price_adjustments p1, --TaxER
6964: OE_INIT_CREDIT_SUMM_GTT m
6965: WHERE
6966: p.line_id = m.line_line_id
6967: AND p.header_id = m.line_header_id
6968: AND p.header_id = m.order_header_id

Line 7054: OE_INIT_CREDIT_SUMM_GTT m

7050: , SYSDATE
7051: , l_request_id
7052:
7053: FROM oe_price_adjustments p,
7054: OE_INIT_CREDIT_SUMM_GTT m
7055: WHERE
7056: p.line_id = m.line_line_id
7057: AND p.header_id = m.line_header_id
7058: AND p.header_id = m.order_header_id

Line 7123: OE_INIT_CREDIT_SUMM_GTT m

7119: , l_request_id
7120:
7121: FROM oe_price_adjustments p,
7122: oe_price_adjustments p1, --TaxER
7123: OE_INIT_CREDIT_SUMM_GTT m
7124: WHERE
7125: p.line_id = m.line_line_id
7126: AND p.header_id = m.line_header_id
7127: AND p.header_id = m.order_header_id

Line 7866: OE_INIT_CREDIT_SUMM_GTT m,

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

Line 7951: OE_INIT_CREDIT_SUMM_GTT m

7947: , l_request_id
7948: , 1
7949:
7950: FROM
7951: OE_INIT_CREDIT_SUMM_GTT m
7952: WHERE
7953: m.line_line_category_code = 'ORDER'
7954: AND m.interface_line_attribute6 = -999 --TaxER
7955: AND EXISTS

Line 8148: OE_INIT_CREDIT_SUMM_GTT m

8144: , SYSDATE
8145: , l_request_id
8146:
8147: FROM
8148: OE_INIT_CREDIT_SUMM_GTT m
8149: WHERE
8150: m.line_line_category_code = 'RETURN'
8151: AND m.interface_line_attribute6 = -999 --TaxER
8152: AND EXISTS

Line 8233: OE_INIT_CREDIT_SUMM_GTT m

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

Line 8315: OE_INIT_CREDIT_SUMM_GTT m

8311: , l_request_id
8312: , 1
8313:
8314: FROM
8315: OE_INIT_CREDIT_SUMM_GTT m
8316: WHERE
8317: m.line_line_category_code = 'ORDER'
8318: AND m.interface_line_attribute6 = -999 --TaxER
8319: AND EXISTS

Line 8401: OE_INIT_CREDIT_SUMM_GTT m

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

Line 8479: OE_INIT_CREDIT_SUMM_GTT m

8475: , SYSDATE
8476: , l_request_id
8477:
8478: FROM
8479: OE_INIT_CREDIT_SUMM_GTT m
8480: WHERE
8481: m.line_line_category_code = 'RETURN'
8482: AND m.interface_line_attribute6 = -999 --TaxER
8483: AND EXISTS

Line 8565: OE_INIT_CREDIT_SUMM_GTT m

8561: , 1
8562:
8563: FROM
8564: oe_price_adjustments p,
8565: OE_INIT_CREDIT_SUMM_GTT m
8566: WHERE
8567: p.line_id = m.line_line_id
8568: AND p.header_id = m.line_header_id
8569: AND p.header_id = m.order_header_id

Line 8649: OE_INIT_CREDIT_SUMM_GTT m

8645:
8646: FROM
8647: oe_price_adjustments p,
8648: oe_price_adjustments p1, --TaxER
8649: OE_INIT_CREDIT_SUMM_GTT m
8650: WHERE
8651: p.line_id = m.line_line_id
8652: AND p.header_id = m.line_header_id
8653: AND p.header_id = m.order_header_id

Line 8749: OE_INIT_CREDIT_SUMM_GTT m

8745: , l_request_id
8746:
8747: FROM
8748: oe_price_adjustments p,
8749: OE_INIT_CREDIT_SUMM_GTT m
8750: WHERE
8751: p.line_id = m.line_line_id
8752: AND p.header_id = m.line_header_id
8753: AND p.header_id = m.order_header_id

Line 8828: OE_INIT_CREDIT_SUMM_GTT m

8824:
8825: FROM
8826: oe_price_adjustments p,
8827: oe_price_adjustments p1, --TaxER
8828: OE_INIT_CREDIT_SUMM_GTT m
8829: WHERE
8830: p.line_id = m.line_line_id
8831: AND p.header_id = m.line_header_id
8832: AND p.header_id = m.order_header_id

Line 8927: OE_INIT_CREDIT_SUMM_GTT m

8923: , l_request_id
8924: , 1
8925:
8926: FROM oe_price_adjustments p,
8927: OE_INIT_CREDIT_SUMM_GTT m
8928: WHERE
8929: p.line_id = m.line_line_id
8930: AND p.header_id = m.line_header_id
8931: AND p.header_id = m.order_header_id

Line 9011: OE_INIT_CREDIT_SUMM_GTT m

9007: , 1
9008:
9009: FROM oe_price_adjustments p,
9010: oe_price_adjustments p1, --TaxER
9011: OE_INIT_CREDIT_SUMM_GTT m
9012: WHERE
9013: p.line_id = m.line_line_id
9014: AND p.header_id = m.line_header_id
9015: AND p.header_id = m.order_header_id

Line 9112: OE_INIT_CREDIT_SUMM_GTT m

9108: , SYSDATE
9109: , l_request_id
9110:
9111: FROM oe_price_adjustments p,
9112: OE_INIT_CREDIT_SUMM_GTT m
9113: WHERE
9114: p.line_id = m.line_line_id
9115: AND p.header_id = m.line_header_id
9116: AND p.header_id = m.order_header_id

Line 9190: OE_INIT_CREDIT_SUMM_GTT m

9186: , l_request_id
9187:
9188: FROM oe_price_adjustments p,
9189: oe_price_adjustments p1, --TaxER
9190: OE_INIT_CREDIT_SUMM_GTT m
9191: WHERE
9192: p.line_id = m.line_line_id
9193: AND p.header_id = m.line_header_id
9194: AND p.header_id = m.order_header_id