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.

[Home] [Help]

APPS.WSMPLBJI dependencies on BOM_BILL_OF_MATERIALS

Line 4130: FROM bom_bill_of_materials bom

4126: IF v_wlji_alt_bom_designator(v_index) is NULL THEN
4127: begin
4128: SELECT bom.common_bill_sequence_id
4129: INTO bom_seq_id
4130: FROM bom_bill_of_materials bom
4131: WHERE bom.alternate_bom_designator is NULL
4132: AND BOM.assembly_item_id = v_wlji_item(v_index)
4133: AND bom.organization_id = v_wlji_org(v_index);
4134: exception

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

4138: ELSE
4139: begin
4140: -- bugfix 2681637 validation of alternate designator should check disable_date.
4141: -- (original bug for form 2558447)
4142: -- table bom_bill_of_materials does not have designator disable_date infor.
4143:
4144: SELECT bom.common_bill_sequence_id
4145: INTO bom_seq_id
4146: FROM bom_bill_of_materials bom,

Line 4146: FROM bom_bill_of_materials bom,

4142: -- table bom_bill_of_materials does not have designator disable_date infor.
4143:
4144: SELECT bom.common_bill_sequence_id
4145: INTO bom_seq_id
4146: FROM bom_bill_of_materials bom,
4147: bom_alternate_designators bad
4148: WHERE ((bom.alternate_bom_designator is null and
4149: bad.alternate_designator_code is null
4150: and bad.organization_id = -1)

Line 5001: bom_bill_of_materials bom,

4997: l_component_yield_factor,
4998: l_comp_basis_type -- LBM enh
4999: from mtl_System_items msi,
5000: bom_inventory_components bic,
5001: bom_bill_of_materials bom,
5002: bom_bill_of_materials bom2
5003: WHERE bic.bill_sequence_id = bom2.bill_sequence_id
5004: and bom.common_bill_sequence_id = bom2.bill_sequence_id
5005: and msi.organization_id = bom.organization_id

Line 5002: bom_bill_of_materials bom2

4998: l_comp_basis_type -- LBM enh
4999: from mtl_System_items msi,
5000: bom_inventory_components bic,
5001: bom_bill_of_materials bom,
5002: bom_bill_of_materials bom2
5003: WHERE bic.bill_sequence_id = bom2.bill_sequence_id
5004: and bom.common_bill_sequence_id = bom2.bill_sequence_id
5005: and msi.organization_id = bom.organization_id
5006: and msi.inventory_item_id = bom.assembly_item_id

Line 5698: FROM bom_bill_of_materials bom

5694: IF v_wlji_alt_bom_designator(v_index) is NULL THEN
5695: begin
5696: SELECT bom.common_bill_sequence_id
5697: INTO p_common_bill_sequence_id
5698: FROM bom_bill_of_materials bom
5699: WHERE bom.alternate_bom_designator is NULL
5700: AND BOM.assembly_item_id = v_wlji_item(v_index)
5701: AND bom.organization_id = v_wlji_org(v_index);
5702: exception

Line 5710: FROM bom_bill_of_materials bom, bom_alternate_designators bad

5706: ELSE
5707: begin
5708: SELECT bom.common_bill_sequence_id
5709: INTO p_common_bill_sequence_id
5710: FROM bom_bill_of_materials bom, bom_alternate_designators bad
5711: WHERE ((bom.alternate_bom_designator is null and bad.alternate_designator_code is null
5712: and bad.organization_id = -1)
5713: OR (bom.alternate_bom_designator = bad.alternate_designator_code
5714: and bom.organization_id = bad.organization_id))