DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 10635: bom_substitute_components bsc

10631: l_sub_comp_bill_qpa,
10632: l_sub_comp_qpa
10633: FROM bom_bill_of_materials bom,
10634: bom_inventory_components bic,
10635: bom_substitute_components bsc
10636: WHERE bsc.SUBSTITUTE_COMPONENT_ID = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
10637: AND bic.COMPONENT_SEQUENCE_ID = bsc.COMPONENT_SEQUENCE_ID
10638: AND bom.organization_id =v_wlji_org_id(v_idx)
10639: AND bic.bill_sequence_id = bom.common_bill_sequence_id

Line 10647: bom_substitute_components bsc3

10643: AND (bic.operation_seq_num = l_start_op_seq_num OR bic.operation_seq_num = 1)
10644: AND bic.item_num = (SELECT min(item_num)
10645: FROM bom_bill_of_materials bom3,
10646: bom_inventory_components bic3,
10647: bom_substitute_components bsc3
10648: WHERE bsc3.SUBSTITUTE_COMPONENT_ID = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
10649: AND bic3.COMPONENT_SEQUENCE_ID = bsc3.COMPONENT_SEQUENCE_ID
10650: AND bom3.organization_id =v_wlji_org_id(v_idx)
10651: AND bic3.bill_sequence_id = bom3.common_bill_sequence_id