APPS.BOM_BULKLOAD_PVT_PKG dependencies on MTL_SYSTEM_ITEMS_VL

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

720: AND
721: BMI.Alternate_Bom_Designator IS NOT NULL
722: AND NOT EXISTS
723: (SELECT NULL FROM Bom_structures_b bsb
724: WHERE bsb.Assembly_Item_id IN (SELECT Inventory_item_id FROM mtl_system_items_vl WHERE concatenated_segments = bmi.Item_number)
725: AND bsb.Organization_id = (SELECT ORGANIZATION_ID FROM mtl_parameters WHERE ORGANIZATION_code = bmi.ORGANIZATION_code)
726: AND bsb.Alternate_Bom_Designator IS NULL
727: );
728:

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

913: l_dyn_sql := 'UPDATE EGO_BULKLOAD_INTF EBI';
914: l_dyn_sql := l_dyn_sql || ' SET INSTANCE_PK1_VALUE = ';
915: l_dyn_sql := l_dyn_sql || ' ( ';
916: l_dyn_sql := l_dyn_sql || ' SELECT inventory_item_id ';
917: l_dyn_sql := l_dyn_sql || ' FROM mtl_system_items_vl mvll ';
918: l_dyn_sql := l_dyn_sql || ' WHERE mvll.concatenated_segments = EBI.'|| l_item_col_name;
919: l_dyn_sql := l_dyn_sql || ' AND mvll.organization_id = EBI.INSTANCE_PK2_VALUE';
920: l_dyn_sql := l_dyn_sql || ' ) ';
921: l_dyn_sql := l_dyn_sql || 'WHERE RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

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

932: l_dyn_sql := 'UPDATE EGO_BULKLOAD_INTF EBI';
933: l_dyn_sql := l_dyn_sql || ' SET ' || G_ASSEMBLY_ITEM_ID || ' = ';
934: l_dyn_sql := l_dyn_sql || ' ( ';
935: l_dyn_sql := l_dyn_sql || ' SELECT inventory_item_id ';
936: l_dyn_sql := l_dyn_sql || ' FROM mtl_system_items_vl mvll ';
937: l_dyn_sql := l_dyn_sql || ' WHERE mvll.concatenated_segments = EBI.'|| l_parent_column;
938: l_dyn_sql := l_dyn_sql || ' AND mvll.organization_id = EBI.INSTANCE_PK2_VALUE';
939: l_dyn_sql := l_dyn_sql || ' ) ';
940: l_dyn_sql := l_dyn_sql || 'WHERE RESULTFMT_USAGE_ID = :RESULTFMT_USAGE_ID';

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

951: l_dyn_sql := 'UPDATE EGO_BULKLOAD_INTF EBI';
952: l_dyn_sql := l_dyn_sql || ' SET INSTANCE_PK4_VALUE = ';
953: l_dyn_sql := l_dyn_sql || ' ( ';
954: l_dyn_sql := l_dyn_sql || ' SELECT bill_sequence_id ';
955: l_dyn_sql := l_dyn_sql || ' FROM bom_structures_b bsb, mtl_system_items_vl mvll ';
956: l_dyn_sql := l_dyn_sql || ' WHERE mvll.concatenated_segments = EBI.'|| l_parent_column;
957: l_dyn_sql := l_dyn_sql || ' AND mvll.organization_id = EBI.INSTANCE_PK2_VALUE';
958: l_dyn_sql := l_dyn_sql || ' AND bsb.assembly_item_id = mvll.inventory_item_id';
959: l_dyn_sql := l_dyn_sql || ' AND bsb.organization_id = mvll.organization_id';