APPS.CSTPSCCR dependencies on MTL_SYSTEM_ITEMS

Line 360: MTL_SYSTEM_ITEMS msi

356: DECODE(p_conc_flag, 1,
357: l_rollup_date, NULL)
358: FROM
359: CST_SC_LOW_LEVEL_CODES csllc,
360: MTL_SYSTEM_ITEMS msi
361: WHERE
362: msi.ORGANIZATION_ID = csllc.organization_id
363: AND csllc.ROLLUP_ID = p_rollup_id
364: AND msi.INVENTORY_ITEM_ID = csllc.INVENTORY_ITEM_ID

Line 385: FROM mtl_system_items MSI

381: UPDATE cst_item_costs CIC
382: SET CIC.lot_size =
383: (SELECT decode(p_lot_size_option, 2, nvl(p_lot_size_setting, CIC.lot_size),
384: 3, nvl(p_lot_size_setting*MSI.std_lot_size, CIC.lot_size))
385: FROM mtl_system_items MSI
386: WHERE MSI.inventory_item_id = CIC.inventory_item_id
387: AND MSI.organization_id = CIC.organization_id)
388: WHERE CIC.cost_type_id = p_dest_cost_type_id
389: AND CIC.based_on_rollup_flag = 1

Line 1891: mtl_system_items msi,

1887: CST_ITEM_COSTS cia_assy,
1888: CST_ITEM_COST_DETAILS cicd,
1889: CST_ITEM_COSTS cia_comp,
1890: BOM_PARAMETERS bp,
1891: mtl_system_items msi,
1892: BOM_OPERATION_RESOURCES bomres
1893:
1894: WHERE cia_assy.ORGANIZATION_ID = l_org_id_tbl(i)
1895: AND cia_assy.COST_TYPE_ID = l_dest_cost_type_id