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 MTL_SYSTEM_ITEMS

Line 253: type t_wsli_primary_uom_code is table of mtl_system_items.primary_uom_code%type;

249: type t_wsli_locator_id is table of wsm_starting_lots_interface.locator_id%type;
250: type t_wsli_revision is table of wsm_starting_lots_interface.revision%type;
251: type t_wsli_last_updated_by is table of wsm_starting_lots_interface.last_updated_by%type;
252: type t_wsli_created_by is table of wsm_starting_lots_interface.created_by%type;
253: type t_wsli_primary_uom_code is table of mtl_system_items.primary_uom_code%type;
254: type t_wsli_comp_issue_qty is table of wsm_starting_lots_interface.component_issue_quantity%type;
255:
256: v_wsli_header_id t_wsli_header_id := t_wsli_header_id();
257: v_wsli_lot_number t_wsli_lot_number := t_wsli_lot_number();

Line 283: primary_uom_code mtl_system_items.primary_uom_code%type,

279: locator_id wsm_starting_lots_interface.locator_id%type,
280: revision wsm_starting_lots_interface.revision%type,
281: last_updated_by wsm_starting_lots_interface.last_updated_by%type,
282: created_by wsm_starting_lots_interface.created_by%type,
283: primary_uom_code mtl_system_items.primary_uom_code%type,
284: comp_issue_quantity wsm_starting_lots_interface.component_issue_quantity%type);
285:
286: v_rec_wsli rec_wsli;
287:

Line 1510: mtl_system_items msi

1506: msi.primary_uom_code,
1507: wsli.component_issue_quantity
1508: from wsm_starting_lots_interface wsli,
1509: wsm_lot_job_interface wlji,
1510: mtl_system_items msi
1511: where wsli.header_id = wlji.source_line_id
1512: and wlji.group_id = l_group_id
1513: and wlji.process_status = 2 -- WIP_CONSTANTS.running
1514: and wlji.mode_flag = 2

Line 3803: from mtl_system_items_kfv msi

3799:
3800: begin
3801: select 1
3802: into l_no_of_records
3803: from mtl_system_items_kfv msi
3804: where msi.inventory_item_id = v_wlji_item(v_index)
3805: and msi.organization_id = v_wlji_org(v_index)
3806: and msi.lot_control_code = 2;
3807: exception

Line 3821: from mtl_system_items_kfv msi

3817: begin
3818: l_no_of_records := 0;
3819: select 1
3820: into l_no_of_records
3821: from mtl_system_items_kfv msi
3822: where msi.inventory_item_id = v_wlji_item(v_index)
3823: and msi.organization_id = v_wlji_org(v_index)
3824: and msi.serial_number_control_code = 1;
3825: exception

Line 4199: FROM mtl_system_items MS,

4195: MS.restrict_locators_code,
4196: MS.location_control_code item_loc_control
4197: into l_sub_loc_control, l_org_loc_control,
4198: l_restrict_locators_code, l_item_loc_control
4199: FROM mtl_system_items MS,
4200: mtl_secondary_inventories MSUB,
4201: mtl_parameters MP
4202: WHERE MP.organization_id = v_wlji_org(v_index)
4203: AND MS.organization_id = v_wlji_org(v_index)

Line 4705: from mtl_system_items_kfv msi

4701: select SERIAL_NUMBER_CONTROL_CODE,
4702: revision_qty_control_code -- Add bug 2963225
4703: into l_dummy,
4704: l_rev_control_code -- Add bug 2963225
4705: from mtl_system_items_kfv msi
4706: where msi.inventory_item_id = v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id
4707: and msi.organization_id = v_wlji_org(v_index);
4708:
4709: if(l_dummy <> 1) then

Line 4889: MTL_SYSTEM_ITEMS C

4885: begin
4886: SELECT 1
4887: INTO l_dummy
4888: FROM BOM_INVENTORY_COMPONENTS BIC,
4889: MTL_SYSTEM_ITEMS C
4890: WHERE BIC.COMPONENT_ITEM_ID = C.INVENTORY_ITEM_ID
4891: AND C.ORGANIZATION_ID = v_wlji_org(v_index)
4892: AND BIC.BILL_SEQUENCE_ID = bom_seq_id
4893: AND BIC.COMPONENT_ITEM_ID = v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id

Line 5005: from mtl_System_items msi,

5001: bic.basis_type -- LBM enh
5002: INTO l_component_quantity,
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

Line 5150: MTL_SYSTEM_ITEMS C

5146: begin
5147: SELECT 1
5148: INTO l_dummy
5149: FROM BOM_INVENTORY_COMPONENTS BIC,
5150: MTL_SYSTEM_ITEMS C
5151: WHERE BIC.COMPONENT_ITEM_ID = C.INVENTORY_ITEM_ID
5152: AND C.ORGANIZATION_ID = v_wlji_org(v_index)
5153: AND BIC.BILL_SEQUENCE_ID = bom_seq_id
5154: AND BIC.COMPONENT_ITEM_ID = v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id

Line 5751: FROM mtl_system_items MS,

5747: MS.restrict_locators_code,
5748: MS.location_control_code item_loc_control
5749: into l_sub_loc_control, l_org_loc_control,
5750: l_restrict_locators_code, l_item_loc_control
5751: FROM mtl_system_items MS,
5752: mtl_secondary_inventories MSUB,
5753: mtl_parameters MP
5754: WHERE MP.organization_id = v_wlji_org(v_index)
5755: AND MS.organization_id = v_wlji_org(v_index)

Line 7507: from mtl_system_items_kfv

7503:
7504: begin
7505: select unique(concatenated_segments)
7506: into assembly_name
7507: from mtl_system_items_kfv
7508: where inventory_item_id = v_wlji_item(v_index)
7509: and organization_id = v_wlji_org(v_index);
7510: exception
7511: when others then