DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 10533: bom_substitute_components bsc

10529: l_sub_comp_bill_qpa,
10530: l_sub_comp_qpa
10531: FROM bom_bill_of_materials bom,
10532: bom_inventory_components bic,
10533: bom_substitute_components bsc
10534: WHERE bsc.SUBSTITUTE_COMPONENT_ID = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
10535: AND bic.COMPONENT_SEQUENCE_ID = bsc.COMPONENT_SEQUENCE_ID
10536: AND bom.organization_id =v_wlji_org_id(v_idx)
10537: AND bic.bill_sequence_id = bom.common_bill_sequence_id

Line 10545: bom_substitute_components bsc3

10541: AND (bic.operation_seq_num = l_start_op_seq_num OR bic.operation_seq_num = 1)
10542: AND bic.item_num = (SELECT min(item_num)
10543: FROM bom_bill_of_materials bom3,
10544: bom_inventory_components bic3,
10545: bom_substitute_components bsc3
10546: WHERE bsc3.SUBSTITUTE_COMPONENT_ID = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
10547: AND bic3.COMPONENT_SEQUENCE_ID = bsc3.COMPONENT_SEQUENCE_ID
10548: AND bom3.organization_id =v_wlji_org_id(v_idx)
10549: AND bic3.bill_sequence_id = bom3.common_bill_sequence_id