DBA Data[Home] [Help]

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 3797: from mtl_system_items_kfv msi

3793:
3794: begin
3795: select 1
3796: into l_no_of_records
3797: from mtl_system_items_kfv msi
3798: where msi.inventory_item_id = v_wlji_item(v_index)
3799: and msi.organization_id = v_wlji_org(v_index)
3800: and msi.lot_control_code = 2;
3801: exception

Line 3815: from mtl_system_items_kfv msi

3811: begin
3812: l_no_of_records := 0;
3813: select 1
3814: into l_no_of_records
3815: from mtl_system_items_kfv msi
3816: where msi.inventory_item_id = v_wlji_item(v_index)
3817: and msi.organization_id = v_wlji_org(v_index)
3818: and msi.serial_number_control_code = 1;
3819: exception

Line 4193: FROM mtl_system_items MS,

4189: MS.restrict_locators_code,
4190: MS.location_control_code item_loc_control
4191: into l_sub_loc_control, l_org_loc_control,
4192: l_restrict_locators_code, l_item_loc_control
4193: FROM mtl_system_items MS,
4194: mtl_secondary_inventories MSUB,
4195: mtl_parameters MP
4196: WHERE MP.organization_id = v_wlji_org(v_index)
4197: AND MS.organization_id = v_wlji_org(v_index)

Line 4699: from mtl_system_items_kfv msi

4695: select SERIAL_NUMBER_CONTROL_CODE,
4696: revision_qty_control_code -- Add bug 2963225
4697: into l_dummy,
4698: l_rev_control_code -- Add bug 2963225
4699: from mtl_system_items_kfv msi
4700: where msi.inventory_item_id = v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id
4701: and msi.organization_id = v_wlji_org(v_index);
4702:
4703: if(l_dummy <> 1) then

Line 4883: MTL_SYSTEM_ITEMS C

4879: begin
4880: SELECT 1
4881: INTO l_dummy
4882: FROM BOM_INVENTORY_COMPONENTS BIC,
4883: MTL_SYSTEM_ITEMS C
4884: WHERE BIC.COMPONENT_ITEM_ID = C.INVENTORY_ITEM_ID
4885: AND C.ORGANIZATION_ID = v_wlji_org(v_index)
4886: AND BIC.BILL_SEQUENCE_ID = bom_seq_id
4887: AND BIC.COMPONENT_ITEM_ID = v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id

Line 4999: from mtl_System_items msi,

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

Line 5144: MTL_SYSTEM_ITEMS C

5140: begin
5141: SELECT 1
5142: INTO l_dummy
5143: FROM BOM_INVENTORY_COMPONENTS BIC,
5144: MTL_SYSTEM_ITEMS C
5145: WHERE BIC.COMPONENT_ITEM_ID = C.INVENTORY_ITEM_ID
5146: AND C.ORGANIZATION_ID = v_wlji_org(v_index)
5147: AND BIC.BILL_SEQUENCE_ID = bom_seq_id
5148: AND BIC.COMPONENT_ITEM_ID = v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id

Line 5745: FROM mtl_system_items MS,

5741: MS.restrict_locators_code,
5742: MS.location_control_code item_loc_control
5743: into l_sub_loc_control, l_org_loc_control,
5744: l_restrict_locators_code, l_item_loc_control
5745: FROM mtl_system_items MS,
5746: mtl_secondary_inventories MSUB,
5747: mtl_parameters MP
5748: WHERE MP.organization_id = v_wlji_org(v_index)
5749: AND MS.organization_id = v_wlji_org(v_index)

Line 7501: from mtl_system_items_kfv

7497:
7498: begin
7499: select unique(concatenated_segments)
7500: into assembly_name
7501: from mtl_system_items_kfv
7502: where inventory_item_id = v_wlji_item(v_index)
7503: and organization_id = v_wlji_org(v_index);
7504: exception
7505: when others then