APPS.BOM_BULKLOAD_PVT_PKG dependencies on MTL_SYSTEM_ITEMS_VL

Line 738: WHERE bsb.Assembly_Item_id IN (SELECT Inventory_item_id FROM mtl_system_items_vl WHERE concatenated_segments = bmi.Item_number)

734: AND
735: BMI.Alternate_Bom_Designator IS NOT NULL
736: AND NOT EXISTS
737: (SELECT NULL FROM Bom_structures_b bsb
738: WHERE bsb.Assembly_Item_id IN (SELECT Inventory_item_id FROM mtl_system_items_vl WHERE concatenated_segments = bmi.Item_number)
739: AND bsb.Organization_id = (SELECT ORGANIZATION_ID FROM mtl_parameters WHERE ORGANIZATION_code = bmi.ORGANIZATION_code)
740: AND bsb.Alternate_Bom_Designator IS NULL
741: );
742:

Line 946: l_dyn_sql := l_dyn_sql || ' FROM mtl_system_items_vl mvll ';

942: l_dyn_sql := 'UPDATE EGO_BULKLOAD_INTF EBI';
943: l_dyn_sql := l_dyn_sql || ' SET INSTANCE_PK1_VALUE = ';
944: l_dyn_sql := l_dyn_sql || ' ( ';
945: l_dyn_sql := l_dyn_sql || ' SELECT inventory_item_id ';
946: l_dyn_sql := l_dyn_sql || ' FROM mtl_system_items_vl mvll ';
947: l_dyn_sql := l_dyn_sql || ' WHERE mvll.concatenated_segments = EBI.'|| l_item_col_name;
948: l_dyn_sql := l_dyn_sql || ' AND mvll.organization_id = EBI.INSTANCE_PK2_VALUE';
949: l_dyn_sql := l_dyn_sql || ' ) ';
950: l_dyn_sql := l_dyn_sql || 'WHERE RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

Line 965: l_dyn_sql := l_dyn_sql || ' FROM mtl_system_items_vl mvll ';

961: l_dyn_sql := 'UPDATE EGO_BULKLOAD_INTF EBI';
962: l_dyn_sql := l_dyn_sql || ' SET ' || G_ASSEMBLY_ITEM_ID || ' = ';
963: l_dyn_sql := l_dyn_sql || ' ( ';
964: l_dyn_sql := l_dyn_sql || ' SELECT inventory_item_id ';
965: l_dyn_sql := l_dyn_sql || ' FROM mtl_system_items_vl mvll ';
966: l_dyn_sql := l_dyn_sql || ' WHERE mvll.concatenated_segments = EBI.'|| l_parent_column;
967: l_dyn_sql := l_dyn_sql || ' AND mvll.organization_id = EBI.INSTANCE_PK2_VALUE';
968: l_dyn_sql := l_dyn_sql || ' ) ';
969: l_dyn_sql := l_dyn_sql || 'WHERE RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

Line 984: l_dyn_sql := l_dyn_sql || ' FROM bom_structures_b bsb, mtl_system_items_vl mvll ';

980: l_dyn_sql := 'UPDATE EGO_BULKLOAD_INTF EBI';
981: l_dyn_sql := l_dyn_sql || ' SET INSTANCE_PK4_VALUE = ';
982: l_dyn_sql := l_dyn_sql || ' ( ';
983: l_dyn_sql := l_dyn_sql || ' SELECT bill_sequence_id ';
984: l_dyn_sql := l_dyn_sql || ' FROM bom_structures_b bsb, mtl_system_items_vl mvll ';
985: l_dyn_sql := l_dyn_sql || ' WHERE mvll.concatenated_segments = EBI.'|| l_parent_column;
986: l_dyn_sql := l_dyn_sql || ' AND mvll.organization_id = EBI.INSTANCE_PK2_VALUE';
987: l_dyn_sql := l_dyn_sql || ' AND bsb.assembly_item_id = mvll.inventory_item_id';
988: l_dyn_sql := l_dyn_sql || ' AND bsb.organization_id = mvll.organization_id';