DBA Data[Home] [Help]

APPS.GMD_API_GRP dependencies on MTL_ITEM_REVISIONS

Line 1955: FROM mtl_item_revisions

1951: AND b.inventory_item_id = d.inventory_item_id
1952: AND b.organization_id = V_organization_id
1953: AND revision IS NOT NULL
1954: AND NOT EXISTS (SELECT 1
1955: FROM mtl_item_revisions
1956: WHERE inventory_item_id = d.inventory_item_id
1957: AND organization_id = V_organization_id
1958: AND revision = d.revision);
1959:

Line 2677: FROM mtl_item_revisions

2673: CURSOR Cur_check_revision (V_revision VARCHAR2) IS
2674: SELECT 1
2675: FROM sys.dual
2676: WHERE EXISTS (SELECT 1
2677: FROM mtl_item_revisions
2678: WHERE inventory_item_id = p_inventory_item_id
2679: AND organization_id = p_organization_id
2680: AND revision = V_revision);
2681: