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 8599: FROM bom_bill_of_materials bom

8595: IF v_wlji_alt_bom(v_idx) is NULL THEN
8596: begin
8597: SELECT bom.common_bill_sequence_id
8598: INTO l_common_bom_seq_id
8599: FROM bom_bill_of_materials bom
8600: WHERE bom.alternate_bom_designator is NULL
8601: AND BOM.assembly_item_id = v_wlji_item_id(v_idx)
8602: AND bom.organization_id = v_wlji_org_id(v_idx);
8603: exception

Line 8612: FROM bom_bill_of_materials bom,

8608: l_stmt_num := 345.1;
8609: begin
8610: SELECT bom.common_bill_sequence_id
8611: INTO l_common_bom_seq_id
8612: FROM bom_bill_of_materials bom,
8613: bom_alternate_designators bad
8614: WHERE ((bom.alternate_bom_designator is null and
8615: bad.alternate_designator_code is null and
8616: bad.organization_id = -1) OR

Line 9198: from bom_bill_of_materials bom

9194: IF v_wlji_alt_bom(v_idx) is NULL THEN
9195: begin
9196: select bom.common_bill_sequence_id
9197: into l_common_bom_seq_id
9198: from bom_bill_of_materials bom
9199: where bom.alternate_bom_designator is null
9200: and bom.assembly_item_id = v_wlji_item_id(v_idx)
9201: and bom.organization_id = v_wlji_org_id(v_idx);
9202: exception

Line 9210: from bom_bill_of_materials bom,

9206: ELSE
9207: begin
9208: select bom.common_bill_sequence_id
9209: into l_common_bom_seq_id
9210: from bom_bill_of_materials bom,
9211: bom_alternate_designators bad
9212: where ((bom.alternate_bom_designator is null and
9213: bad.alternate_designator_code is null and
9214: bad.organization_id = -1) or

Line 10531: FROM bom_bill_of_materials bom,

10527: INTO l_is_src_lot_sub,
10528: l_primary_comp_item_id,
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

Line 10543: FROM bom_bill_of_materials bom3,

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

Line 10555: ( SELECT 1 FROM bom_bill_of_materials bom2,

10551: AND bic3.implementation_date is not null
10552: AND bic3.effectivity_date <= sysdate
10553: AND nvl(bic3.disable_date,sysdate +1) > sysdate)
10554: AND NOT EXISTS
10555: ( SELECT 1 FROM bom_bill_of_materials bom2,
10556: bom_inventory_components bic2
10557: WHERE bic2.component_item_id = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
10558: AND bom2.organization_id =v_wlji_org_id(v_idx)
10559: AND bic2.bill_sequence_id = bom2.common_bill_sequence_id