DBA Data[Home] [Help]

APPS.CSTPSCEX dependencies on MTL_SYSTEM_ITEMS

Line 227: from mtl_system_items msi

223: MSV.source_type is not null and
224: MSV.effective_date <= i_effective_date and
225: nvl( MSV.disable_date, i_effective_date + 1 ) > i_effective_date
226: and exists (select 1
227: from mtl_system_items msi
228: where msi.inventory_item_id = i_inventory_item_id
229: and msi.organization_id = nvl(MSV.source_organization_id,msi.organization_id));
230:
231:

Line 427: from mtl_system_items msi,

423: /* Added for bug 4547027 */
424: select decode(nvl(msi.inventory_item_status_code,'NOT'||bp.bom_delete_status_code),
425: nvl(bp.bom_delete_status_code,' '),2,1)
426: into l_active_flag
427: from mtl_system_items msi,
428: bom_parameters bp
429: where msi.inventory_item_id = CSBE.component_item_id
430: and msi.organization_id = CSBE.component_organization_id
431: and bp.organization_id (+) = msi.organization_id;

Line 512: cst_sc_sourcing_rules CSSR, mtl_system_items msi /* Bug 6124274 */

508: i_prog_appl_id, -- PROGRAM_APPLICATION_ID
509: i_prog_id, -- PROGRAM_ID
510: sysdate -- PROGRAM_UPDATE_DATE
511: from
512: cst_sc_sourcing_rules CSSR, mtl_system_items msi /* Bug 6124274 */
513: where
514: CSSR.rollup_id = i_rollup_id and
515: msi.inventory_item_id = cssr.inventory_item_id and
516: msi.organization_id = cssr.organization_id and

Line 778: mtl_system_items MSI,

774: decode(nvl(msi.inventory_item_status_code,'NOT'||bp.bom_delete_status_code),nvl(bp.bom_delete_status_code,' '),2,1) active_flag
775: from
776: cst_sc_bom_structures CSBS,
777: cst_item_costs CIC,
778: mtl_system_items MSI,
779: bom_inventory_components BIC,
780: bom_parameters bp /* Bug 4547027 */
781: where
782: CSBS.rollup_id = i_rollup_id and

Line 814: mtl_system_items MSI,

810: decode(nvl(msi.inventory_item_status_code,'NOT'||bp.bom_delete_status_code),nvl(bp.bom_delete_status_code,' '),2,1) active_flag
811: from
812: cst_sc_bom_structures CSBS,
813: cst_item_costs CIC,
814: mtl_system_items MSI,
815: bom_inventory_components BIC,
816: bom_parameters bp /* Bug 4547027 */
817: where
818: CSBS.rollup_id = i_rollup_id and