DBA Data[Home] [Help]

APPS.BOMPVALB dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 942: bom_substitute_components bsc

938: if (org_id <> cmn_org_id) then /* Comp and sub comp in production */
939: select count(*)
940: into cnt
941: from bom_inventory_components bic,
942: bom_substitute_components bsc
943: where bic.bill_sequence_id = cmn_bom_id
944: and bic.component_sequence_id = bsc.component_sequence_id
945: and bsc.substitute_component_id not in
946: (select msi1.inventory_item_id

Line 3396: from bom_substitute_components a, bom_sub_comps_interface b

3392: */
3393: begin
3394: select 1
3395: into dummy
3396: from bom_substitute_components a, bom_sub_comps_interface b
3397: where b.transaction_id = trans_id
3398: and a.component_sequence_id = b.component_sequence_id
3399: and a.SUBSTITUTE_COMPONENT_ID =
3400: b.SUBSTITUTE_COMPONENT_ID