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_WLT_VALIDATE_PVT dependencies on MTL_SYSTEM_ITEMS

Line 330: FROM mtl_system_items_kfv msi

326: IF (l_bom_item_id IS NOT NULL) THEN
327: BEGIN
328: SELECT 1
329: INTO l_temp_num
330: FROM mtl_system_items_kfv msi
331: WHERE msi.inventory_item_id = l_bom_item_id
332: AND msi.organization_id = p_org_id;
333: EXCEPTION
334: WHEN too_many_rows THEN

Line 1984: from mtl_system_items msi

1980:
1981: -- ST : Serial Support --
1982: select nvl(serial_number_control_code,1)
1983: into l_code
1984: from mtl_system_items msi
1985: where inventory_item_id = p_starting_jobs_tbl(l_counter).primary_item_id
1986: and organization_id = p_txn_org_id;
1987:
1988: IF x_job_serial_code IS NULL THEN

Line 2349: from mtl_system_items msi

2345:
2346: -- ST : Serial Support --
2347: select nvl(serial_number_control_code,1)
2348: into l_start_serial_code
2349: from mtl_system_items msi
2350: where inventory_item_id = p_starting_job_rec.primary_item_id
2351: and organization_id = p_txn_org_id;
2352:
2353: select nvl(serial_number_control_code,1)

Line 2355: from mtl_system_items msi

2351: and organization_id = p_txn_org_id;
2352:
2353: select nvl(serial_number_control_code,1)
2354: into l_res_serial_code
2355: from mtl_system_items msi
2356: where inventory_item_id = p_resulting_job_rec.primary_item_id
2357: and organization_id = p_txn_org_id;
2358:
2359: IF l_start_serial_code <> l_res_serial_code then

Line 2931: from mtl_system_items msi

2927:
2928: -- ST : Serial Support Project --
2929: select nvl(serial_number_control_code,1)
2930: into l_start_serial_code
2931: from mtl_system_items msi
2932: where inventory_item_id = p_starting_job_rec.primary_item_id
2933: and organization_id = p_txn_org_id;
2934: -- ST : Serial Support Project --
2935:

Line 4088: from mtl_system_items msi

4084:
4085: -- ST : Serial Support Project --
4086: select nvl(serial_number_control_code,1)
4087: into l_start_serial_code
4088: from mtl_system_items msi
4089: where inventory_item_id = p_starting_job_rec.primary_item_id
4090: and organization_id = p_txn_org_id;
4091: -- ST : Serial Support Project --
4092:

Line 4553: from mtl_system_items msi

4549:
4550: -- ST : Serial Support Project --
4551: select nvl(serial_number_control_code,1)
4552: into l_res_serial_code
4553: from mtl_system_items msi
4554: where inventory_item_id = p_resulting_jobs_tbl(l_counter).primary_item_id
4555: and organization_id = p_txn_org_id;
4556:
4557: IF l_res_serial_code <> l_start_serial_code then

Line 5172: from mtl_system_items

5168: END IF;
5169:
5170: select nvl(serial_number_control_code,1)
5171: into l_serial_control
5172: from mtl_system_items
5173: where inventory_item_id = p_resulting_job_rec.primary_item_id
5174: and organization_id = p_resulting_job_rec.organization_id;
5175:
5176: -- Quantity check .....

Line 5848: from mtl_system_items_kfv

5844: -- ST : Bug fix 4914162 : Added an IF clause
5845: IF p_rj_rtg_reference_id IS NOT NULL THEN
5846: select inventory_item_id
5847: into p_rj_rtg_reference_id
5848: from mtl_system_items_kfv
5849: where inventory_item_id = p_rj_rtg_reference_id
5850: and concatenated_segments = nvl(p_rj_rtg_reference_item,concatenated_segments)
5851: and organization_id = p_txn_org_id;
5852: ELSE

Line 5855: from mtl_system_items_kfv

5851: and organization_id = p_txn_org_id;
5852: ELSE
5853: select inventory_item_id
5854: into p_rj_rtg_reference_id
5855: from mtl_system_items_kfv
5856: where concatenated_segments = p_rj_rtg_reference_item
5857: and organization_id = p_txn_org_id;
5858: END IF;
5859:

Line 6244: from mtl_system_items_kfv

6240: -- ST : Bug fix 4914162 : Added an IF clause
6241: IF p_rj_bom_reference_id IS NOT NULL THEN
6242: select inventory_item_id
6243: into p_rj_bom_reference_id
6244: from mtl_system_items_kfv
6245: where inventory_item_id = p_rj_bom_reference_id
6246: and concatenated_segments = nvl(p_rj_bom_reference_item,concatenated_segments)
6247: and organization_id = p_txn_org_id;
6248: ELSE

Line 6251: from mtl_system_items_kfv

6247: and organization_id = p_txn_org_id;
6248: ELSE
6249: select inventory_item_id
6250: into p_rj_bom_reference_id
6251: from mtl_system_items_kfv
6252: where concatenated_segments = p_rj_bom_reference_item
6253: and organization_id = p_txn_org_id;
6254: END IF;
6255:

Line 6665: from mtl_system_items ms,

6661: into l_sub_loc_control,
6662: l_org_loc_control,
6663: l_restrict_loc_code,
6664: l_item_loc_control
6665: from mtl_system_items ms,
6666: mtl_secondary_inventories msi,
6667: mtl_parameters mp
6668: where mp.organization_id = p_organization_id
6669: and ms.organization_id = p_organization_id

Line 7247: from mtl_system_items_kfv

7243: SELECT inventory_item_id,LOT_CONTROL_CODE,SERIAL_NUMBER_CONTROL_CODE
7244: INTO p_new_item_id,
7245: l_lot_control_code,
7246: l_serial_number_control_code
7247: from mtl_system_items_kfv
7248: where inventory_item_id = p_new_item_id
7249: and concatenated_segments = nvl(p_new_item_name,concatenated_segments)
7250: and organization_id = p_txn_org_id;
7251: ELSE

Line 7256: from mtl_system_items_kfv

7252: SELECT inventory_item_id,LOT_CONTROL_CODE,SERIAL_NUMBER_CONTROL_CODE
7253: INTO p_new_item_id,
7254: l_lot_control_code,
7255: l_serial_number_control_code
7256: from mtl_system_items_kfv
7257: where concatenated_segments = p_new_item_name
7258: and organization_id = p_txn_org_id;
7259: END IF;
7260: EXCEPTION