APPS.BOM_SUBSTITUTE_COMPONENT_API dependencies on BOM_INVENTORY_COMPONENTS

Line 440: FROM bom_inventory_components

436: stmt_num := 11;
437: BEGIN
438: SELECT component_sequence_id
439: INTO c1rec.CSI
440: FROM bom_inventory_components
441: WHERE bill_sequence_id = c1rec.BSI
442: AND component_item_id = c1rec.CII
443: AND operation_seq_num = c1rec.OSN
444: AND effectivity_date = to_date(c1rec.ED,'YYYY/MM/DD HH24:MI:SS');

Line 504: from bom_inventory_components

500: IF (c2rec.SIQ is null) THEN
501: BEGIN
502: select component_quantity
503: into c2rec.SIQ
504: from bom_inventory_components
505: where component_sequence_id = c2rec.CSI;
506: EXCEPTION
507: when NO_DATA_FOUND then
508: ret_code := INVPUOPI.mtl_log_interface_err(

Line 843: FROM bom_inventory_components bic,

839: bbom.bill_sequence_id BSI, bbom.organization_id OI,
840: bbom.assembly_item_id AII, bbom.assembly_type AST,
841: bic.component_item_id CII,
842: bsci.change_notice CN
843: FROM bom_inventory_components bic,
844: bom_bill_of_materials bbom,
845: bom_sub_comps_interface bsci
846: WHERE bsci.process_flag = 2
847: AND bsci.transaction_type in (G_Insert, G_Update)

Line 890: bom_inventory_components bic

886: X_attribute14, X_attribute15, X_request_id,
887: X_program_application_id, X_program_id,
888: X_program_update_date
889: FROM bom_substitute_components bsc,
890: bom_inventory_components bic
891: WHERE bsc.component_sequence_id = c2rec.CSI
892: AND bsc.substitute_component_id = c2rec.SCI
893: AND bsc.component_sequence_id = bic.component_sequence_id
894: AND bic.implementation_date is not null;

Line 1045: FROM bom_inventory_components bic,

1041: bbom.assembly_type, bic.component_item_id,
1042: bic.bom_item_type, mtl.bom_item_type
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