eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSM_LBJ_INTERFACE_PVT dependencies on BOM_BILL_OF_MATERIALS

Line 8697: FROM bom_bill_of_materials bom

8693: IF v_wlji_alt_bom(v_idx) is NULL THEN
8694: begin
8695: SELECT bom.common_bill_sequence_id
8696: INTO l_common_bom_seq_id
8697: FROM bom_bill_of_materials bom
8698: WHERE bom.alternate_bom_designator is NULL
8699: AND BOM.assembly_item_id = v_wlji_item_id(v_idx)
8700: AND bom.organization_id = v_wlji_org_id(v_idx);
8701: exception

Line 8710: FROM bom_bill_of_materials bom,

8706: l_stmt_num := 345.1;
8707: begin
8708: SELECT bom.common_bill_sequence_id
8709: INTO l_common_bom_seq_id
8710: FROM bom_bill_of_materials bom,
8711: bom_alternate_designators bad
8712: WHERE ((bom.alternate_bom_designator is null and
8713: bad.alternate_designator_code is null and
8714: bad.organization_id = -1) OR

Line 9296: from bom_bill_of_materials bom

9292: IF v_wlji_alt_bom(v_idx) is NULL THEN
9293: begin
9294: select bom.common_bill_sequence_id
9295: into l_common_bom_seq_id
9296: from bom_bill_of_materials bom
9297: where bom.alternate_bom_designator is null
9298: and bom.assembly_item_id = v_wlji_item_id(v_idx)
9299: and bom.organization_id = v_wlji_org_id(v_idx);
9300: exception

Line 9308: from bom_bill_of_materials bom,

9304: ELSE
9305: begin
9306: select bom.common_bill_sequence_id
9307: into l_common_bom_seq_id
9308: from bom_bill_of_materials bom,
9309: bom_alternate_designators bad
9310: where ((bom.alternate_bom_designator is null and
9311: bad.alternate_designator_code is null and
9312: bad.organization_id = -1) or

Line 10633: FROM bom_bill_of_materials bom,

10629: INTO l_is_src_lot_sub,
10630: l_primary_comp_item_id,
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

Line 10645: FROM bom_bill_of_materials bom3,

10641: AND bic.implementation_date is not null
10642: AND bic.effectivity_date <= sysdate and nvl(bic.disable_date,sysdate +1) > sysdate
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

Line 10657: ( SELECT 1 FROM bom_bill_of_materials bom2,

10653: AND bic3.implementation_date is not null
10654: AND bic3.effectivity_date <= sysdate
10655: AND nvl(bic3.disable_date,sysdate +1) > sysdate)
10656: AND NOT EXISTS
10657: ( SELECT 1 FROM bom_bill_of_materials bom2,
10658: bom_inventory_components bic2
10659: WHERE bic2.component_item_id = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
10660: AND bom2.organization_id =v_wlji_org_id(v_idx)
10661: AND bic2.bill_sequence_id = bom2.common_bill_sequence_id