[Home] [Help]
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:
424: /* Added for bug 4547027 */
425: select decode(nvl(msi.inventory_item_status_code,'NOT'||bp.bom_delete_status_code),
426: nvl(bp.bom_delete_status_code,' '),2,1)
427: into l_active_flag
428: from mtl_system_items msi,
429: bom_parameters bp
430: where msi.inventory_item_id = CSBE.component_item_id
431: and msi.organization_id = CSBE.component_organization_id
432: and bp.organization_id (+) = msi.organization_id;
509: i_prog_appl_id, -- PROGRAM_APPLICATION_ID
510: i_prog_id, -- PROGRAM_ID
511: sysdate -- PROGRAM_UPDATE_DATE
512: from
513: cst_sc_sourcing_rules CSSR, mtl_system_items msi /* Bug 6124274 */
514: where
515: CSSR.rollup_id = i_rollup_id and
516: msi.inventory_item_id = cssr.inventory_item_id and
517: msi.organization_id = cssr.organization_id and
776: decode(CIC.lot_size, 0, 1, NULL, 1, CIC.lot_size) lot_size
777: from
778: cst_sc_bom_structures CSBS,
779: cst_item_costs CIC,
780: mtl_system_items MSI,
781: bom_inventory_components BIC,
782: bom_parameters bp /* Bug 4547027 */
783: where
784: CSBS.rollup_id = i_rollup_id and
812: decode(CIC.lot_size, 0, 1, NULL, 1, CIC.lot_size) lot_size
813: from
814: cst_sc_bom_structures CSBS,
815: cst_item_costs CIC,
816: mtl_system_items MSI,
817: bom_inventory_components BIC,
818: bom_parameters bp /* Bug 4547027 */
819: where
820: CSBS.rollup_id = i_rollup_id and
1278: MP1.organization_code assembly_organization,
1279: COMP.concatenated_segments component_item,
1280: MP2.organization_code component_organization
1281: from cst_sc_bom_explosion CSBE,
1282: mtl_system_items_kfv ASSM,
1283: mtl_parameters MP1,
1284: mtl_system_items_kfv COMP,
1285: mtl_parameters MP2
1286: where CSBE.rollup_id = i_rollup_id
1280: MP2.organization_code component_organization
1281: from cst_sc_bom_explosion CSBE,
1282: mtl_system_items_kfv ASSM,
1283: mtl_parameters MP1,
1284: mtl_system_items_kfv COMP,
1285: mtl_parameters MP2
1286: where CSBE.rollup_id = i_rollup_id
1287: and CSBE.deleted_flag = 'N'
1288: and ASSM.inventory_item_id = CSBE.assembly_item_id