APPS.PO_ITEMS_SV1 dependencies on MTL_SYSTEM_ITEMS

Line 20: /* check to see if there are x_item_id exists in mtl_system_items table */

16:
17: BEGIN
18: x_progress := '010';
19:
20: /* check to see if there are x_item_id exists in mtl_system_items table */
21: SELECT count(*)
22: INTO x_temp
23: FROM mtl_system_items
24: WHERE inventory_item_id = x_item_id

Line 23: FROM mtl_system_items

19:
20: /* check to see if there are x_item_id exists in mtl_system_items table */
21: SELECT count(*)
22: INTO x_temp
23: FROM mtl_system_items
24: WHERE inventory_item_id = x_item_id
25: AND organization_id = x_organization_id
26: AND enabled_flag = 'Y'
27: AND purchasing_item_flag = 'Y'

Line 70: FROM mtl_system_items_kfv

66: /* check to see if there are any inventory_item_id exists */
67:
68: SELECT inventory_item_id
69: INTO X_inventory_item_id_v
70: FROM mtl_system_items_kfv
71: WHERE concatenated_segments = X_item_number
72: AND organization_id = X_organization_id;
73:
74: ELSIF (X_vendor_product_num is not null) THEN