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.WSMPLBJI dependencies on BOM_BILL_OF_MATERIALS

Line 4136: FROM bom_bill_of_materials bom

4132: IF v_wlji_alt_bom_designator(v_index) is NULL THEN
4133: begin
4134: SELECT bom.common_bill_sequence_id
4135: INTO bom_seq_id
4136: FROM bom_bill_of_materials bom
4137: WHERE bom.alternate_bom_designator is NULL
4138: AND BOM.assembly_item_id = v_wlji_item(v_index)
4139: AND bom.organization_id = v_wlji_org(v_index);
4140: exception

Line 4148: -- table bom_bill_of_materials does not have designator disable_date infor.

4144: ELSE
4145: begin
4146: -- bugfix 2681637 validation of alternate designator should check disable_date.
4147: -- (original bug for form 2558447)
4148: -- table bom_bill_of_materials does not have designator disable_date infor.
4149:
4150: SELECT bom.common_bill_sequence_id
4151: INTO bom_seq_id
4152: FROM bom_bill_of_materials bom,

Line 4152: FROM bom_bill_of_materials bom,

4148: -- table bom_bill_of_materials does not have designator disable_date infor.
4149:
4150: SELECT bom.common_bill_sequence_id
4151: INTO bom_seq_id
4152: FROM bom_bill_of_materials bom,
4153: bom_alternate_designators bad
4154: WHERE ((bom.alternate_bom_designator is null and
4155: bad.alternate_designator_code is null
4156: and bad.organization_id = -1)

Line 5007: bom_bill_of_materials bom,

5003: l_component_yield_factor,
5004: l_comp_basis_type -- LBM enh
5005: from mtl_System_items msi,
5006: bom_inventory_components bic,
5007: bom_bill_of_materials bom,
5008: bom_bill_of_materials bom2
5009: WHERE bic.bill_sequence_id = bom2.bill_sequence_id
5010: and bom.common_bill_sequence_id = bom2.bill_sequence_id
5011: and msi.organization_id = bom.organization_id

Line 5008: bom_bill_of_materials bom2

5004: l_comp_basis_type -- LBM enh
5005: from mtl_System_items msi,
5006: bom_inventory_components bic,
5007: bom_bill_of_materials bom,
5008: bom_bill_of_materials bom2
5009: WHERE bic.bill_sequence_id = bom2.bill_sequence_id
5010: and bom.common_bill_sequence_id = bom2.bill_sequence_id
5011: and msi.organization_id = bom.organization_id
5012: and msi.inventory_item_id = bom.assembly_item_id

Line 5704: FROM bom_bill_of_materials bom

5700: IF v_wlji_alt_bom_designator(v_index) is NULL THEN
5701: begin
5702: SELECT bom.common_bill_sequence_id
5703: INTO p_common_bill_sequence_id
5704: FROM bom_bill_of_materials bom
5705: WHERE bom.alternate_bom_designator is NULL
5706: AND BOM.assembly_item_id = v_wlji_item(v_index)
5707: AND bom.organization_id = v_wlji_org(v_index);
5708: exception

Line 5716: FROM bom_bill_of_materials bom, bom_alternate_designators bad

5712: ELSE
5713: begin
5714: SELECT bom.common_bill_sequence_id
5715: INTO p_common_bill_sequence_id
5716: FROM bom_bill_of_materials bom, bom_alternate_designators bad
5717: WHERE ((bom.alternate_bom_designator is null and bad.alternate_designator_code is null
5718: and bad.organization_id = -1)
5719: OR (bom.alternate_bom_designator = bad.alternate_designator_code
5720: and bom.organization_id = bad.organization_id))