DBA Data[Home] [Help]

APPS.GMD_API_GRP dependencies on MTL_ITEM_REVISIONS

Line 1935: FROM mtl_item_revisions

1931: AND b.inventory_item_id = d.inventory_item_id
1932: AND b.organization_id = V_organization_id
1933: AND revision IS NOT NULL
1934: AND NOT EXISTS (SELECT 1
1935: FROM mtl_item_revisions
1936: WHERE inventory_item_id = d.inventory_item_id
1937: AND organization_id = V_organization_id
1938: AND revision = d.revision);
1939:

Line 2657: FROM mtl_item_revisions

2653: CURSOR Cur_check_revision (V_revision VARCHAR2) IS
2654: SELECT 1
2655: FROM sys.dual
2656: WHERE EXISTS (SELECT 1
2657: FROM mtl_item_revisions
2658: WHERE inventory_item_id = p_inventory_item_id
2659: AND organization_id = p_organization_id
2660: AND revision = V_revision);
2661: