DBA Data[Home] [Help]

APPS.BOM_SUBSTITUTE_COMPONENT_API dependencies on MTL_SYSTEM_ITEMS

Line 184: SET transaction_id = mtl_system_items_interface_s.nextval,

180: */
181: stmt_num := 2;
182: LOOP
183: UPDATE bom_sub_comps_interface
184: SET transaction_id = mtl_system_items_interface_s.nextval,
185: transaction_type = upper(transaction_type)
186: WHERE transaction_id is null
187: AND process_flag = 1
188: AND (UPPER(interface_entity_type) = 'BILL'

Line 599: SELECT mtl_system_items_interface_s.nextval

595: stmt_num := 20;
596:
597: FOR c3rec in c3 LOOP
598: commit_cnt := commit_cnt + 1;
599: SELECT mtl_system_items_interface_s.nextval
600: INTO dummy_txn
601: FROM sys.dual;
602:
603: stmt_num := 21;

Line 1047: mtl_system_items mtl

1043: INTO assy_id_dummy, org_id_dummy, assy_type_dummy,
1044: comp_id_dummy, comp_type, dummy
1045: FROM bom_inventory_components bic,
1046: bom_bill_of_materials bbom,
1047: mtl_system_items mtl
1048: WHERE bic.component_sequence_id = c1rec.CSI
1049: AND bic.implementation_date is not null
1050: AND bbom.bill_sequence_id = bic.bill_sequence_id
1051: AND mtl.inventory_item_id = bbom.assembly_item_id

Line 1163: FROM mtl_system_items

1159: IF (c3rec.TT = G_Insert
1160: OR (c3rec.TT = G_Update AND c3rec.NSCI is not null)) THEN
1161: SELECT 1
1162: INTO dummy
1163: FROM mtl_system_items
1164: WHERE organization_id = c3rec.OI
1165: AND inventory_item_id = decode(c3rec.TT, G_Insert, c3rec.SCI,
1166: G_Update, c3rec.NSCI)
1167: AND bom_enabled_flag = 'Y'

Line 1212: FROM mtl_system_items msi

1208: WHERE bbom.common_bill_sequence_id = c3rec.BSI
1209: AND bbom.organization_id <> bbom.common_organization_id
1210: AND not exists
1211: (SELECT null
1212: FROM mtl_system_items msi
1213: WHERE msi.organization_id = bbom.organization_id
1214: AND msi.inventory_item_id = decode(c3rec.TT, G_Insert,
1215: c3rec.SCI, G_Update, c3rec.NSCI)
1216: AND msi.bom_enabled_flag = 'Y'