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 MTL_SYSTEM_ITEMS_KFV

Line 1982: from mtl_system_items_kfv

1978: l_stmt_num := 50;
1979: begin
1980: select unique(inventory_item_id)
1981: into v_wljdi_inventory_item_id_old(l_d)
1982: from mtl_system_items_kfv
1983: where concatenated_segments = v_wljdi_inventory_item_old(l_d)
1984: and organization_id = p_org_id;
1985: exception
1986: when others then

Line 1994: from mtl_system_items_kfv

1990: else
1991: begin
1992: select concatenated_segments
1993: into v_wljdi_inventory_item_old(l_d)
1994: from mtl_system_items_kfv
1995: where inventory_item_id = v_wljdi_inventory_item_id_old(l_d)
1996: and organization_id = p_org_id;
1997: exception
1998: when others then

Line 2027: from mtl_system_items_kfv

2023: else
2024: begin
2025: select unique(inventory_item_id)
2026: into v_wljdi_inventory_item_id_new(l_d)
2027: from mtl_system_items_kfv
2028: where concatenated_segments = v_wljdi_inventory_item_new(l_d)
2029: and organization_id = p_org_id;
2030: exception
2031: when others then

Line 2041: from mtl_system_items_kfv

2037: else
2038: begin
2039: select concatenated_segments
2040: into v_wljdi_inventory_item_new(l_d)
2041: from mtl_system_items_kfv
2042: where inventory_item_id = v_wljdi_inventory_item_id_new(l_d)
2043: and organization_id = p_org_id;
2044: exception
2045: when others then

Line 2072: from mtl_system_items_kfv

2068: else
2069: begin
2070: select unique(inventory_item_id)
2071: into v_wljdi_primary_item_id(l_d)
2072: from mtl_system_items_kfv
2073: where concatenated_segments = v_wljdi_primary_item(l_d)
2074: and organization_id = p_org_id;
2075: exception
2076: when others then

Line 2099: from mtl_system_items_kfv

2095: else
2096: begin
2097: select unique(inventory_item_id)
2098: into v_wljdi_src_phantom_item_id(l_d)
2099: from mtl_system_items_kfv
2100: where concatenated_segments = v_wljdi_src_phantom_item(l_d)
2101: and organization_id = p_org_id;
2102: exception
2103: when others then

Line 2113: from mtl_system_items_kfv

2109: else
2110: begin
2111: select concatenated_segments
2112: into v_wljdi_src_phantom_item(l_d)
2113: from mtl_system_items_kfv
2114: where inventory_item_id = v_wljdi_src_phantom_item_id(l_d)
2115: and organization_id = p_org_id;
2116: exception
2117: when others then

Line 5708: from mtl_system_items_kfv

5704: /*
5705: begin
5706: select 1
5707: into l_comp_exist
5708: from mtl_system_items_kfv
5709: where organization_id = p_org_id
5710: and inventory_item_id=l_item_old_id;
5711: exception
5712: when others then

Line 5777: from mtl_system_items_kfv

5773: --check if the inventory item id old is valid
5774: begin
5775: select 1
5776: into l_comp_exist
5777: from mtl_system_items_kfv
5778: where organization_id = p_org_id
5779: and inventory_item_id=l_item_old_id;
5780: exception
5781: when others then

Line 5831: from mtl_system_items_kfv

5827:
5828: /*begin
5829: select 1
5830: into l_comp_exist
5831: from mtl_system_items_kfv
5832: where inventory_item_id=l_item_id
5833: and organization_id=p_org_id;
5834: exception
5835: when others then

Line 5949: from mtl_system_items_kfv

5945:
5946: /*begin
5947: select 1
5948: into l_comp_exist
5949: from mtl_system_items_kfv
5950: where inventory_item_id=l_item_id
5951: and organization_id=p_org_id;
5952: exception
5953: when others then

Line 8446: from mtl_system_items_kfv msi

8442: l_num_records := 0;
8443: begin
8444: select 1
8445: into l_num_records
8446: from mtl_system_items_kfv msi
8447: where msi.inventory_item_id = v_wlji_item_id(v_idx)
8448: and msi.organization_id = v_wlji_org_id(v_idx)
8449: and msi.lot_control_code = 2;
8450: exception

Line 8464: from mtl_system_items_kfv msi

8460: l_num_records := 0;
8461: begin
8462: select 1
8463: into l_num_records
8464: from mtl_system_items_kfv msi
8465: where msi.inventory_item_id = v_wlji_item_id(v_idx)
8466: and msi.organization_id = v_wlji_org_id(v_idx)
8467: -- ST : Serial Support Project -----------------------------
8468: -- In OSFM we do support Serial controlled assemblies.......

Line 8540: from mtl_system_items_kfv msi

8536:
8537: BEGIN
8538: select msi.serial_number_control_code
8539: into l_serial_ctrl_code
8540: from mtl_system_items_kfv msi
8541: where msi.inventory_item_id = v_wlji_item_id(v_idx)
8542: and msi.organization_id = v_wlji_org_id(v_idx);
8543:
8544: IF l_serial_ctrl_code = 2 THEN -- Predefined serial control...

Line 10186: from mtl_system_items_kfv msi,wip_discrete_jobs wdj

10182:
10183: BEGIN
10184: select msi.serial_number_control_code
10185: into l_serial_ctrl_code
10186: from mtl_system_items_kfv msi,wip_discrete_jobs wdj
10187: where msi.inventory_item_id = wdj.primary_item_id
10188: and msi.organization_id = v_wlji_org_id(v_idx)
10189: and wdj.wip_entity_id = v_wlji_wip_entity_id(v_idx)
10190: and wdj.organization_id = v_wlji_org_id(v_idx);

Line 10585: from mtl_system_items_kfv msi

10581: select SERIAL_NUMBER_CONTROL_CODE,
10582: revision_qty_control_code -- Add bug 2963225
10583: into dummy_number,
10584: l_rev_control_code -- Add bug 2963225
10585: from mtl_system_items_kfv msi
10586: where msi.inventory_item_id = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
10587: and msi.organization_id = v_wlji_org_id(v_idx);
10588:
10589: -- Added code to restrict serial tagged components also.

Line 11895: from mtl_system_items_kfv

11891: l_stmt_num := 1040.3;
11892: begin
11893: select unique(concatenated_segments)
11894: into l_assembly_name
11895: from mtl_system_items_kfv
11896: where inventory_item_id = v_wlji_item_id(v_idx)
11897: and organization_id = v_wlji_org_id(v_idx);
11898: exception
11899: when others then