APPS.CSTPMRGL dependencies on CST_MARGIN_BUILD

Line 115: from CST_MARGIN_BUILD

111: -- DBMS_OUTPUT.PUT_LINE('.*******************************************');
112:
113: select MAX(last_update_date), NVL(MAX(0),1), NVL(MAX(build_id),0)
114: into l_last_load_date, l_first_build, l_build_id
115: from CST_MARGIN_BUILD
116: where legal_entity_id = l_le_id;
117:
118: -- DBMS_OUTPUT.PUT_LINE('l_last_load_date = ' || to_char(l_last_load_date));
119: -- DBMS_OUTPUT.PUT_LINE('l_first_build = ' || to_char(l_first_build));

Line 174: | Insert into CST_MARGIN_BUILD, if required

170: raise;
171: END;
172:
173: /*---------------------------------------------------------------+
174: | Insert into CST_MARGIN_BUILD, if required
175: +---------------------------------------------------------------*/
176:
177: BEGIN
178:

Line 180: SELECT cst_margin_build_s.nextval

176:
177: BEGIN
178:
179: if l_first_build = 1 THEN
180: SELECT cst_margin_build_s.nextval
181: INTO l_build_id
182: FROM sys.dual;
183:
184: l_build_name := to_char(l_build_id);

Line 202: INSERT INTO CST_MARGIN_BUILD (

198: -- DBMS_OUTPUT.PUT_LINE('.*******************************************');
199:
200: if l_first_build = 1 THEN
201:
202: INSERT INTO CST_MARGIN_BUILD (
203: build_id,
204: build_name,
205: build_description,
206: legal_entity_id,

Line 246: UPDATE cst_margin_build

242: l_program_id,
243: SYSDATE ) ;
244: else
245:
246: UPDATE cst_margin_build
247: SET FROM_DATE = l_from_date,
248: TO_DATE = l_to_date,
249: LAST_UPDATE_DATE = SYSDATE
250: WHERE legal_entity_id = l_le_id;

Line 367: cst_margin_build cr,

363: 0),
364: rctlgd.acctd_amount,
365: rctlgd.code_combination_id
366: FROM
367: cst_margin_build cr,
368: ra_cust_trx_line_gl_dist_all rctlgd,
369: ra_customer_trx_lines_all rctl,
370: ra_customer_trx_all rct,
371: oe_order_lines_all sl_child,

Line 508: cst_margin_build cr,

504: 0),
505: rctlgd.acctd_amount,
506: rctlgd.code_combination_id
507: FROM
508: cst_margin_build cr,
509: ra_cust_trx_line_gl_dist_all rctlgd,
510: ra_customer_trx_lines_all rctl,
511: oe_order_headers_all sh,
512: oe_order_lines_all sl_parent,

Line 659: cst_margin_build cr,

655: , 0),
656: rctlgd.acctd_amount,
657: rctlgd.code_combination_id
658: FROM
659: cst_margin_build cr,
660: ra_cust_trx_line_gl_dist_all rctlgd,
661: ra_customer_trx_lines_all rctl,
662: ra_customer_trx_all rct,
663: oe_order_headers_all rma,

Line 1057: FROM cst_margin_build cr,

1053: )
1054: END,
1055: mta.base_transaction_value,
1056: mta.reference_account
1057: FROM cst_margin_build cr,
1058: cst_acct_info_v ood,
1059: mtl_material_transactions mmt,
1060: mtl_transaction_accounts mta,
1061: oe_order_lines_all sl_child,

Line 1170: cst_margin_build cr,

1166: rcl.quantity_invoiced,
1167: NVL(aid.amount, 0),
1168: aid.dist_code_combination_id
1169: FROM
1170: cst_margin_build cr,
1171: ap_invoice_distributions_all aid,
1172: ap_invoices_all ai,
1173: oe_order_headers_all sh,
1174: oe_order_lines_all sl_parent,

Line 1289: cst_margin_build cr,

1285: mmt.primary_quantity,-1,mmt.primary_quantity,0),
1286: mta.base_transaction_value,
1287: mta.reference_account -- added for ER 3007482
1288: FROM
1289: cst_margin_build cr,
1290: oe_order_headers_all rma,
1291: oe_order_lines_all rma_line,
1292: mtl_material_transactions mmt,
1293: cst_organization_definitions cod,