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 1977: from mtl_system_items_kfv

1973: l_stmt_num := 50;
1974: begin
1975: select unique(inventory_item_id)
1976: into v_wljdi_inventory_item_id_old(l_d)
1977: from mtl_system_items_kfv
1978: where concatenated_segments = v_wljdi_inventory_item_old(l_d)
1979: and organization_id = p_org_id;
1980: exception
1981: when others then

Line 1989: from mtl_system_items_kfv

1985: else
1986: begin
1987: select concatenated_segments
1988: into v_wljdi_inventory_item_old(l_d)
1989: from mtl_system_items_kfv
1990: where inventory_item_id = v_wljdi_inventory_item_id_old(l_d)
1991: and organization_id = p_org_id;
1992: exception
1993: when others then

Line 2022: from mtl_system_items_kfv

2018: else
2019: begin
2020: select unique(inventory_item_id)
2021: into v_wljdi_inventory_item_id_new(l_d)
2022: from mtl_system_items_kfv
2023: where concatenated_segments = v_wljdi_inventory_item_new(l_d)
2024: and organization_id = p_org_id;
2025: exception
2026: when others then

Line 2036: from mtl_system_items_kfv

2032: else
2033: begin
2034: select concatenated_segments
2035: into v_wljdi_inventory_item_new(l_d)
2036: from mtl_system_items_kfv
2037: where inventory_item_id = v_wljdi_inventory_item_id_new(l_d)
2038: and organization_id = p_org_id;
2039: exception
2040: when others then

Line 2067: from mtl_system_items_kfv

2063: else
2064: begin
2065: select unique(inventory_item_id)
2066: into v_wljdi_primary_item_id(l_d)
2067: from mtl_system_items_kfv
2068: where concatenated_segments = v_wljdi_primary_item(l_d)
2069: and organization_id = p_org_id;
2070: exception
2071: when others then

Line 2094: from mtl_system_items_kfv

2090: else
2091: begin
2092: select unique(inventory_item_id)
2093: into v_wljdi_src_phantom_item_id(l_d)
2094: from mtl_system_items_kfv
2095: where concatenated_segments = v_wljdi_src_phantom_item(l_d)
2096: and organization_id = p_org_id;
2097: exception
2098: when others then

Line 2108: from mtl_system_items_kfv

2104: else
2105: begin
2106: select concatenated_segments
2107: into v_wljdi_src_phantom_item(l_d)
2108: from mtl_system_items_kfv
2109: where inventory_item_id = v_wljdi_src_phantom_item_id(l_d)
2110: and organization_id = p_org_id;
2111: exception
2112: when others then

Line 5702: from mtl_system_items_kfv

5698: /*
5699: begin
5700: select 1
5701: into l_comp_exist
5702: from mtl_system_items_kfv
5703: where organization_id = p_org_id
5704: and inventory_item_id=l_item_old_id;
5705: exception
5706: when others then

Line 5771: from mtl_system_items_kfv

5767: --check if the inventory item id old is valid
5768: begin
5769: select 1
5770: into l_comp_exist
5771: from mtl_system_items_kfv
5772: where organization_id = p_org_id
5773: and inventory_item_id=l_item_old_id;
5774: exception
5775: when others then

Line 5825: from mtl_system_items_kfv

5821:
5822: /*begin
5823: select 1
5824: into l_comp_exist
5825: from mtl_system_items_kfv
5826: where inventory_item_id=l_item_id
5827: and organization_id=p_org_id;
5828: exception
5829: when others then

Line 5938: from mtl_system_items_kfv

5934:
5935: /*begin
5936: select 1
5937: into l_comp_exist
5938: from mtl_system_items_kfv
5939: where inventory_item_id=l_item_id
5940: and organization_id=p_org_id;
5941: exception
5942: when others then

Line 8348: from mtl_system_items_kfv msi

8344: l_num_records := 0;
8345: begin
8346: select 1
8347: into l_num_records
8348: from mtl_system_items_kfv msi
8349: where msi.inventory_item_id = v_wlji_item_id(v_idx)
8350: and msi.organization_id = v_wlji_org_id(v_idx)
8351: and msi.lot_control_code = 2;
8352: exception

Line 8366: from mtl_system_items_kfv msi

8362: l_num_records := 0;
8363: begin
8364: select 1
8365: into l_num_records
8366: from mtl_system_items_kfv msi
8367: where msi.inventory_item_id = v_wlji_item_id(v_idx)
8368: and msi.organization_id = v_wlji_org_id(v_idx)
8369: -- ST : Serial Support Project -----------------------------
8370: -- In OSFM we do support Serial controlled assemblies.......

Line 8442: from mtl_system_items_kfv msi

8438:
8439: BEGIN
8440: select msi.serial_number_control_code
8441: into l_serial_ctrl_code
8442: from mtl_system_items_kfv msi
8443: where msi.inventory_item_id = v_wlji_item_id(v_idx)
8444: and msi.organization_id = v_wlji_org_id(v_idx);
8445:
8446: IF l_serial_ctrl_code = 2 THEN -- Predefined serial control...

Line 10088: from mtl_system_items_kfv msi,wip_discrete_jobs wdj

10084:
10085: BEGIN
10086: select msi.serial_number_control_code
10087: into l_serial_ctrl_code
10088: from mtl_system_items_kfv msi,wip_discrete_jobs wdj
10089: where msi.inventory_item_id = wdj.primary_item_id
10090: and msi.organization_id = v_wlji_org_id(v_idx)
10091: and wdj.wip_entity_id = v_wlji_wip_entity_id(v_idx)
10092: and wdj.organization_id = v_wlji_org_id(v_idx);

Line 10487: from mtl_system_items_kfv msi

10483: select SERIAL_NUMBER_CONTROL_CODE,
10484: revision_qty_control_code -- Add bug 2963225
10485: into dummy_number,
10486: l_rev_control_code -- Add bug 2963225
10487: from mtl_system_items_kfv msi
10488: where msi.inventory_item_id = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id
10489: and msi.organization_id = v_wlji_org_id(v_idx);
10490:
10491: if(dummy_number <> 1) then

Line 11791: from mtl_system_items_kfv

11787: l_stmt_num := 1040.3;
11788: begin
11789: select unique(concatenated_segments)
11790: into l_assembly_name
11791: from mtl_system_items_kfv
11792: where inventory_item_id = v_wlji_item_id(v_idx)
11793: and organization_id = v_wlji_org_id(v_idx);
11794: exception
11795: when others then