APPS.OE_CREDIT_EXPOSURE_PVT dependencies on OE_PRICE_ADJUSTMENTS

Line 5025: LOCK TABLE oe_price_adjustments IN EXCLUSIVE MODE;

5021: END IF;
5022:
5023: LOCK TABLE oe_order_lines_all IN EXCLUSIVE MODE;
5024: LOCK TABLE oe_order_headers_all IN EXCLUSIVE MODE;
5025: LOCK TABLE oe_price_adjustments IN EXCLUSIVE MODE;
5026: LOCK TABLE ar_payment_schedules_all IN EXCLUSIVE MODE;
5027: LOCK TABLE ar_cash_receipts_all IN EXCLUSIVE MODE;
5028: LOCK TABLE ar_cash_receipt_history_all IN EXCLUSIVE MODE;
5029:

Line 5884: oe_price_adjustments p

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

Line 5964: oe_price_adjustments p,

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

Line 6046: FROM oe_price_adjustments p,

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

Line 6128: FROM oe_price_adjustments p,

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

Line 6207: oe_price_adjustments p

6203: , l_request_id
6204: , 1
6205:
6206: FROM
6207: oe_price_adjustments p
6208: , oe_order_headers_all h
6209: , hz_cust_site_uses_all su
6210: , hz_cust_acct_sites_all s
6211: , hz_cust_accounts ca

Line 6266: oe_price_adjustments p

6262: , l_request_id
6263: , 1
6264:
6265: FROM
6266: oe_price_adjustments p
6267: , oe_order_headers_all h
6268: , hz_cust_site_uses_all su
6269: , hz_cust_acct_sites_all s
6270: , hz_cust_accounts ca

Line 6372: oe_price_adjustments p

6368: , SYSDATE
6369: , l_request_id
6370:
6371: FROM
6372: oe_price_adjustments p
6373: , oe_order_headers_all h
6374: , hz_cust_site_uses_all su
6375: , hz_cust_acct_sites_all s
6376: , hz_cust_accounts ca

Line 6430: oe_price_adjustments p

6426: , SYSDATE
6427: , l_request_id
6428:
6429: FROM
6430: oe_price_adjustments p
6431: , oe_order_headers_all h
6432: , hz_cust_site_uses_all su
6433: , hz_cust_acct_sites_all s
6434: , hz_cust_accounts ca

Line 7215: oe_price_adjustments p,

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

Line 7305: oe_price_adjustments p,

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

Line 7394: FROM oe_price_adjustments p,

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

Line 7484: FROM oe_price_adjustments p,

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

Line 7568: oe_price_adjustments p

7564: , l_request_id
7565: , 1
7566:
7567: FROM
7568: oe_price_adjustments p
7569: , oe_order_headers_all h
7570: , hz_cust_site_uses_all su
7571: , hz_cust_acct_sites_all s
7572: , hz_cust_accounts ca

Line 7669: oe_price_adjustments p

7665: , SYSDATE
7666: , l_request_id
7667:
7668: FROM
7669: oe_price_adjustments p
7670: , oe_order_headers_all h
7671: , hz_cust_site_uses_all su
7672: , hz_cust_acct_sites_all s
7673: , hz_cust_accounts ca