APPS.WSM_WLT_VALIDATE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

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 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 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