DBA Data[Home] [Help]

APPS.GR_VALIDATE dependencies on MTL_SYSTEM_ITEMS_KFV

Line 26: FROM mtl_system_items_kfv

22:
23: -- Cursor used to validate item
24: CURSOR c_val_item IS
25: SELECT inventory_item_id
26: FROM mtl_system_items_kfv
27: WHERE concatenated_segments = p_item and
28: organization_id = p_organization_id;
29:
30:

Line 85: FROM mtl_system_items_kfv

81:
82: -- Cursor used to validate cas_number
83: CURSOR c_val_cas_number IS
84: SELECT inventory_item_id, concatenated_segments
85: FROM mtl_system_items_kfv
86: WHERE cas_number = p_cas_number and
87: organization_id = p_organization_id;
88:
89: -- Local Variables