APPS.CSTPOMLD dependencies on CST_BIS_MARGIN_BUILD

Line 99: from CST_BIS_MARGIN_BUILD

95:
96:
97: select MAX(last_update_date), NVL(MAX(0),1), NVL(MAX(build_id),0)
98: into l_last_load_date, l_first_build, l_build_id
99: from CST_BIS_MARGIN_BUILD
100: where legal_entity_id = l_le_id;
101:
102:
103: -- DBMS_OUTPUT.PUT_LINE('l_last_load_date = ' || to_char(l_last_load_date));

Line 161: | Insert into CST_BIS_MARGIN_BUILD, if required

157:
158:
159:
160: /*---------------------------------------------------------------+
161: | Insert into CST_BIS_MARGIN_BUILD, if required
162: +---------------------------------------------------------------*/
163:
164: BEGIN
165:

Line 190: INSERT INTO CST_BIS_MARGIN_BUILD (

186: -- DBMS_OUTPUT.PUT_LINE('.*******************************************');
187:
188: if l_first_build = 1 THEN
189:
190: INSERT INTO CST_BIS_MARGIN_BUILD (
191: build_id,
192: build_name,
193: build_description,
194: legal_entity_id,

Line 237: UPDATE CST_BIS_MARGIN_BUILD

233: sys.dual;
234:
235: else
236:
237: UPDATE CST_BIS_MARGIN_BUILD
238: SET FROM_DATE = l_from_date,
239: TO_DATE = l_to_date,
240: LAST_UPDATE_DATE = SYSDATE
241: WHERE legal_entity_id = l_le_id;

Line 359: CST_BIS_MARGIN_BUILD cr,

355: 0),
356: rctlgd.acctd_amount,
357: rctlgd.code_combination_id
358: FROM
359: CST_BIS_MARGIN_BUILD cr,
360: ra_cust_trx_line_gl_dist_all rctlgd,
361: ra_customer_trx_lines_all rctl,
362: oe_order_headers_all sh,
363: oe_order_lines_all sl_parent,

Line 502: CST_BIS_MARGIN_BUILD cr,

498: 0),
499: rctlgd.acctd_amount,
500: rctlgd.code_combination_id
501: FROM
502: CST_BIS_MARGIN_BUILD cr,
503: ra_cust_trx_line_gl_dist_all rctlgd,
504: ra_customer_trx_lines_all rctl,
505: oe_order_headers_all sh,
506: oe_order_lines_all sl_parent,

Line 645: CST_BIS_MARGIN_BUILD cr,

641: (-1) * rma_line.SHIPPED_QUANTITY * rctlgd.percent / 100,
642: rctlgd.acctd_amount,
643: rctlgd.code_combination_id
644: FROM
645: CST_BIS_MARGIN_BUILD cr,
646: ra_cust_trx_line_gl_dist_all rctlgd,
647: ra_customer_trx_lines_all rctl,
648: oe_order_headers_all rma,
649: oe_order_lines_all rma_line,

Line 777: CST_BIS_MARGIN_BUILD cr,

773: * rctlgd.percent / 100,
774: rctlgd.acctd_amount,
775: rctlgd.code_combination_id
776: FROM
777: CST_BIS_MARGIN_BUILD cr,
778: ra_cust_trx_line_gl_dist_all rctlgd,
779: ra_customer_trx_lines_all rctl,
780: oe_order_headers_all rma,
781: oe_order_lines_all rma_line,

Line 1005: CST_BIS_MARGIN_BUILD cr,

1001: (-1) * rma_line.SHIPPED_QUANTITY * rctlgd.percent / 100,
1002: rctlgd.acctd_amount,
1003: rctlgd.code_combination_id
1004: FROM
1005: CST_BIS_MARGIN_BUILD cr,
1006: ra_cust_trx_line_gl_dist_all rctlgd,
1007: ra_customer_trx_lines_all rctl,
1008: oe_order_headers_all rma,
1009: oe_order_lines_all rma_line,

Line 1313: CST_BIS_MARGIN_BUILD cr,

1309: mtl_material_transactions mmt,
1310: mtl_transaction_accounts mta,
1311: -- new changes for intercompany invoicing
1312: org_organization_definitions ood,
1313: CST_BIS_MARGIN_BUILD cr,
1314: mtl_parameters mp -- INVCONV umoogala 17-oct-2004
1315: WHERE
1316: cr.build_id = l_build_id
1317: and (

Line 1436: CST_BIS_MARGIN_BUILD cr,

1432: rcl.quantity_invoiced,
1433: NVL(aid.amount, 0),
1434: aid.dist_code_combination_id
1435: FROM
1436: CST_BIS_MARGIN_BUILD cr,
1437: ap_invoice_distributions_all aid,
1438: ap_invoices_all ai,
1439: oe_order_headers_all sh,
1440: oe_order_lines_all sl_parent,

Line 1573: CST_BIS_MARGIN_BUILD cr,

1569: (-1)* decode(nvl(mta.cost_element_id,-1),1,
1570: mmt.primary_quantity,-1,mmt.primary_quantity,0),
1571: mta.base_transaction_value
1572: FROM
1573: CST_BIS_MARGIN_BUILD cr,
1574: oe_order_headers_all rma,
1575: oe_order_lines_all rma_line,
1576: mtl_material_transactions mmt,
1577: -- new changes for intercompany invoicing