[Home] [Help]
167: l_rollup_date, NULL)
168: FROM
169: CST_SC_LOW_LEVEL_CODES csllc,
170: CST_ITEM_COSTS cia,
171: MTL_PARAMETERS mp
172: WHERE cia.ORGANIZATION_ID = csllc.organization_id
173: AND csllc.ROLLUP_ID = p_rollup_id
174: AND cia.INVENTORY_ITEM_ID = csllc.INVENTORY_ITEM_ID
175: AND cia.BASED_ON_ROLLUP_FLAG = 1 -- YES
277: FROM
278: CST_SC_LOW_LEVEL_CODES csllc,
279: CST_ITEM_COSTS cia,
280: CST_ITEM_COST_DETAILS cicd,
281: MTL_PARAMETERS mp
282: WHERE csllc.ROLLUP_ID = p_rollup_id
283: AND cia.ORGANIZATION_ID = csllc.organization_id
284: AND cia.INVENTORY_ITEM_ID = csllc.INVENTORY_ITEM_ID
285: AND cia.COST_TYPE_ID = p_dest_cost_type_id
363: AND csllc.ROLLUP_ID = p_rollup_id
364: AND msi.INVENTORY_ITEM_ID = csllc.INVENTORY_ITEM_ID
365: AND NOT EXISTS
366: (SELECT 'X'
367: FROM CST_ITEM_COSTS cia1, MTL_PARAMETERS mp
368: WHERE cia1.INVENTORY_ITEM_ID = csllc.INVENTORY_ITEM_ID
369: AND cia1.ORGANIZATION_ID = csllc.ORGANIZATION_ID
370: AND mp.ORGANIZATION_ID = csllc.ORGANIZATION_ID
371: AND cia1.COST_TYPE_ID
667: TYPE org_id_tbl_type IS TABLE OF CST_SC_LOW_LEVEL_CODES.organization_id%TYPE INDEX BY BINARY_INTEGER;
668: TYPE roun_tbl_type IS TABLE OF CST_SC_LOW_LEVEL_CODES.round_unit%TYPE INDEX BY BINARY_INTEGER;
669: TYPE prec_tbl_type IS TABLE OF CST_SC_LOW_LEVEL_CODES.precision%TYPE INDEX BY BINARY_INTEGER;
670: TYPE ext_tbl_type IS TABLE OF CST_SC_LOW_LEVEL_CODES.ext_precision%TYPE INDEX BY BINARY_INTEGER;
671: TYPE pcm_tbl_type IS TABLE OF MTL_PARAMETERS.PRIMARY_COST_METHOD%TYPE INDEX BY BINARY_INTEGER;
672:
673: l_inv_item_tbl inv_item_tbl_type;
674: l_org_id_tbl org_id_tbl_type;
675: l_roun_tbl roun_tbl_type;
746: csllc.precision AS precision,
747: csllc.ext_precision AS ext_precision,
748: mp.primary_cost_method AS primary_cost_method
749: FROM cst_sc_low_level_codes csllc,
750: mtl_parameters mp
751: WHERE csllc.rollup_id = l_rollup_id
752: AND csllc.low_level_code = current_level
753: AND mp.organization_id = csllc.organization_id;
754:
984: DECODE(conc_flag, 1,
985: l_rollup_date, NULL)
986: FROM
987: CST_SC_LOW_LEVEL_CODES csllc,
988: MTL_PARAMETERS mp,
989: CST_ITEM_COSTS cia,
990: BOM_OPERATIONAL_ROUTINGS bor,
991: BOM_OPERATION_SEQUENCES bos,
992: BOM_OPERATION_RESOURCES bomres,
1164: -100,
1165: DECODE(conc_flag, 1, l_rollup_date, NULL)
1166: FROM
1167: CST_SC_LOW_LEVEL_CODES csllc,
1168: MTL_PARAMETERS mp,
1169: CST_ITEM_COSTS cia,
1170: BOM_OPERATIONAL_ROUTINGS bor,
1171: BOM_OPERATION_SEQUENCES bos,
1172: BOM_OPERATION_RESOURCES bomres,
1348: CST_ITEM_COSTS cia,
1349: CST_ITEM_COST_DETAILS cicd,
1350: CST_RESOURCE_OVERHEADS cro,
1351: CST_DEPARTMENT_OVERHEADS cdo,
1352: MTL_PARAMETERS mp
1353: WHERE csllc.ROLLUP_ID = l_rollup_id
1354: AND cia.INVENTORY_ITEM_ID = csllc.INVENTORY_ITEM_ID
1355: AND cia.ORGANIZATION_ID = csllc.organization_id
1356: AND cia.COST_TYPE_ID = l_dest_cost_type_id
1482: CST_ITEM_COSTS cia,
1483: BOM_OPERATIONAL_ROUTINGS bor,
1484: BOM_OPERATION_SEQUENCES bos,
1485: CST_DEPARTMENT_OVERHEADS cdo,
1486: MTL_PARAMETERS mp
1487: WHERE csllc.ROLLUP_ID = l_rollup_id
1488: AND cia.BASED_ON_ROLLUP_FLAG (+) = 1 /* YES */
1489: AND cia.INVENTORY_ASSET_FLAG (+) = 1
1490: AND cia.INVENTORY_ITEM_ID (+) = csllc.INVENTORY_ITEM_ID
2105: l_wsm_enabled := 'N';
2106:
2107: select UPPER(wsm_enabled_flag)
2108: into l_wsm_enabled
2109: from mtl_parameters
2110: where organization_id = csllc_level_org.organization_id;
2111:
2112: if (l_wsm_enabled = 'Y') then
2113:
2740: SET (ITEM_COST,
2741: BUY_COST_FLAG) =
2742: (SELECT NVL(SUM(CICD.ITEM_COST),0),
2743: 'Y'
2744: FROM CST_ITEM_COST_DETAILS CICD, MTL_PARAMETERS MP
2745: WHERE CICD.inventory_item_id = l_item_id
2746: AND CICD.organization_id = l_org_id
2747: AND MP.organization_id = l_org_id
2748: AND (