[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:
983: DECODE(conc_flag, 1,
984: l_rollup_date, NULL)
985: FROM
986: CST_SC_LOW_LEVEL_CODES csllc,
987: MTL_PARAMETERS mp,
988: CST_ITEM_COSTS cia,
989: BOM_OPERATIONAL_ROUTINGS bor,
990: BOM_OPERATION_SEQUENCES bos,
991: BOM_OPERATION_RESOURCES bomres,
1163: -100,
1164: DECODE(conc_flag, 1, l_rollup_date, NULL)
1165: FROM
1166: CST_SC_LOW_LEVEL_CODES csllc,
1167: MTL_PARAMETERS mp,
1168: CST_ITEM_COSTS cia,
1169: BOM_OPERATIONAL_ROUTINGS bor,
1170: BOM_OPERATION_SEQUENCES bos,
1171: BOM_OPERATION_RESOURCES bomres,
1351: CST_ITEM_COSTS cia,
1352: CST_ITEM_COST_DETAILS cicd,
1353: CST_RESOURCE_OVERHEADS cro,
1354: CST_DEPARTMENT_OVERHEADS cdo,
1355: MTL_PARAMETERS mp
1356: WHERE csllc.ROLLUP_ID = l_rollup_id
1357: AND cia.INVENTORY_ITEM_ID = csllc.INVENTORY_ITEM_ID
1358: AND cia.ORGANIZATION_ID = csllc.organization_id
1359: AND cia.COST_TYPE_ID = l_dest_cost_type_id
1485: CST_ITEM_COSTS cia,
1486: BOM_OPERATIONAL_ROUTINGS bor,
1487: BOM_OPERATION_SEQUENCES bos,
1488: CST_DEPARTMENT_OVERHEADS cdo,
1489: MTL_PARAMETERS mp
1490: WHERE csllc.ROLLUP_ID = l_rollup_id
1491: AND cia.BASED_ON_ROLLUP_FLAG (+) = 1 /* YES */
1492: AND cia.INVENTORY_ASSET_FLAG (+) = 1
1493: AND cia.INVENTORY_ITEM_ID (+) = csllc.INVENTORY_ITEM_ID
2106: l_wsm_enabled := 'N';
2107:
2108: select UPPER(wsm_enabled_flag)
2109: into l_wsm_enabled
2110: from mtl_parameters
2111: where organization_id = csllc_level_org.organization_id;
2112:
2113: if (l_wsm_enabled = 'Y') then
2114:
2741: SET (ITEM_COST,
2742: BUY_COST_FLAG) =
2743: (SELECT NVL(SUM(CICD.ITEM_COST),0),
2744: 'Y'
2745: FROM CST_ITEM_COST_DETAILS CICD, MTL_PARAMETERS MP
2746: WHERE CICD.inventory_item_id = l_item_id
2747: AND CICD.organization_id = l_org_id
2748: AND MP.organization_id = l_org_id
2749: AND (