APPS.OE_CREDIT_EXPOSURE_PVT dependencies on OE_PRICE_ADJUSTMENTS

Line 5385: LOCK TABLE oe_price_adjustments IN EXCLUSIVE MODE;

5381: END IF;
5382:
5383: LOCK TABLE oe_order_lines_all IN EXCLUSIVE MODE;
5384: LOCK TABLE oe_order_headers_all IN EXCLUSIVE MODE;
5385: LOCK TABLE oe_price_adjustments IN EXCLUSIVE MODE;
5386: LOCK TABLE ar_payment_schedules_all IN EXCLUSIVE MODE;
5387: LOCK TABLE ar_cash_receipts_all IN EXCLUSIVE MODE;
5388: LOCK TABLE ar_cash_receipt_history_all IN EXCLUSIVE MODE;
5389:

Line 6565: oe_price_adjustments p

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
6569: AND p.header_id = m.order_header_id

Line 6638: oe_price_adjustments p,

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
6642: AND p.header_id = m.line_header_id

Line 6639: oe_price_adjustments p1 --TaxER

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
6642: AND p.header_id = m.line_header_id
6643: AND p.header_id = m.order_header_id

Line 6728: oe_price_adjustments p,

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

Line 6799: oe_price_adjustments p,

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
6803: AND p.header_id = m.line_header_id

Line 6800: oe_price_adjustments p1 --TaxER

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
6803: AND p.header_id = m.line_header_id
6804: AND p.header_id = m.order_header_id

Line 6889: FROM oe_price_adjustments p,

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

Line 6962: FROM oe_price_adjustments p,

6958: , SYSDATE
6959: , l_request_id
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

Line 6963: oe_price_adjustments p1, --TaxER

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

Line 7053: FROM oe_price_adjustments p,

7049: , l_program_id
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

Line 7121: FROM oe_price_adjustments p,

7117: , l_program_id
7118: , SYSDATE
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

Line 7122: oe_price_adjustments p1, --TaxER

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

Line 7211: oe_price_adjustments p

7207: , l_request_id
7208: , 1
7209:
7210: FROM
7211: oe_price_adjustments p
7212: , oe_order_headers_all h
7213: , hz_cust_site_uses_all su
7214: , hz_cust_acct_sites_all s
7215: , hz_cust_accounts ca

Line 7270: oe_price_adjustments p

7266: , l_request_id
7267: , 1
7268:
7269: FROM
7270: oe_price_adjustments p
7271: , oe_order_headers_all h
7272: , hz_cust_site_uses_all su
7273: , hz_cust_acct_sites_all s
7274: , hz_cust_accounts ca

Line 7366: oe_price_adjustments p

7362: , l_request_id
7363: , 1
7364:
7365: FROM
7366: oe_price_adjustments p
7367: , oe_order_headers_all h
7368: , hz_cust_site_uses_all su
7369: , hz_cust_acct_sites_all s
7370: , hz_cust_accounts ca

Line 7427: oe_price_adjustments p

7423: , l_request_id
7424: , 1
7425:
7426: FROM
7427: oe_price_adjustments p
7428: , oe_order_headers_all h
7429: , hz_cust_site_uses_all su
7430: , hz_cust_acct_sites_all s
7431: , hz_cust_accounts ca

Line 7539: oe_price_adjustments p

7535: , SYSDATE
7536: , l_request_id
7537:
7538: FROM
7539: oe_price_adjustments p
7540: , oe_order_headers_all h
7541: , hz_cust_site_uses_all su
7542: , hz_cust_acct_sites_all s
7543: , hz_cust_accounts ca

Line 7597: oe_price_adjustments p

7593: , SYSDATE
7594: , l_request_id
7595:
7596: FROM
7597: oe_price_adjustments p
7598: , oe_order_headers_all h
7599: , hz_cust_site_uses_all su
7600: , hz_cust_acct_sites_all s
7601: , hz_cust_accounts ca

Line 7690: oe_price_adjustments p

7686: , SYSDATE
7687: , l_request_id
7688:
7689: FROM
7690: oe_price_adjustments p
7691: , oe_order_headers_all h
7692: , hz_cust_site_uses_all su
7693: , hz_cust_acct_sites_all s
7694: , hz_cust_accounts ca

Line 7750: oe_price_adjustments p

7746: , SYSDATE
7747: , l_request_id
7748:
7749: FROM
7750: oe_price_adjustments p
7751: , oe_order_headers_all h
7752: , hz_cust_site_uses_all su
7753: , hz_cust_acct_sites_all s
7754: , hz_cust_accounts ca

Line 8564: oe_price_adjustments p,

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

Line 8647: oe_price_adjustments p,

8643: , l_request_id
8644: , 1
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

Line 8648: oe_price_adjustments p1, --TaxER

8644: , 1
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

Line 8748: oe_price_adjustments p,

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

Line 8826: oe_price_adjustments p,

8822: , SYSDATE
8823: , l_request_id
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

Line 8827: oe_price_adjustments p1, --TaxER

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

Line 8926: FROM oe_price_adjustments p,

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

Line 9009: FROM oe_price_adjustments p,

9005: , SYSDATE
9006: , l_request_id
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

Line 9010: oe_price_adjustments p1, --TaxER

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

Line 9111: FROM oe_price_adjustments p,

9107: , l_program_id
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

Line 9188: FROM oe_price_adjustments p,

9184: , l_program_id
9185: , SYSDATE
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

Line 9189: oe_price_adjustments p1, --TaxER

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

Line 9282: oe_price_adjustments p

9278: , l_request_id
9279: , 1
9280:
9281: FROM
9282: oe_price_adjustments p
9283: , oe_order_headers_all h
9284: , hz_cust_site_uses_all su
9285: , hz_cust_acct_sites_all s
9286: , hz_cust_accounts ca

Line 9377: oe_price_adjustments p

9373: , l_request_id
9374: , 1
9375:
9376: FROM
9377: oe_price_adjustments p
9378: , oe_order_headers_all h
9379: , hz_cust_site_uses_all su
9380: , hz_cust_acct_sites_all s
9381: , hz_cust_accounts ca

Line 9485: oe_price_adjustments p

9481: , SYSDATE
9482: , l_request_id
9483:
9484: FROM
9485: oe_price_adjustments p
9486: , oe_order_headers_all h
9487: , hz_cust_site_uses_all su
9488: , hz_cust_acct_sites_all s
9489: , hz_cust_accounts ca

Line 9579: oe_price_adjustments p

9575: , SYSDATE
9576: , l_request_id
9577:
9578: FROM
9579: oe_price_adjustments p
9580: , oe_order_headers_all h
9581: , hz_cust_site_uses_all su
9582: , hz_cust_acct_sites_all s
9583: , hz_cust_accounts ca