APPS.AHL_PRD_DISPOSITION_PVT dependencies on MTL_ITEM_REVISIONS

Line 1378: SELECT 'x' FROM mtl_item_revisions

1374: WHERE serial_number = p_serial_number
1375: AND inventory_item_id = p_inventory_item_id;
1376:
1377: CURSOR item_revisions_csr (p_revision IN VARCHAR2, p_item_id IN NUMBER, p_organization_id IN NUMBER) IS
1378: SELECT 'x' FROM mtl_item_revisions
1379: WHERE inventory_item_id = p_item_id
1380: AND organization_id = p_organization_id
1381: AND revision = p_revision;
1382:

Line 2916: SELECT 'x' FROM mtl_item_revisions

2912: SELECT 'x' FROM mtl_units_of_measure_vl
2913: WHERE uom_code = p_uom;
2914:
2915: CURSOR item_revisions_csr (p_revision IN VARCHAR2, p_item_id IN NUMBER, p_organization_id IN NUMBER) IS
2916: SELECT 'x' FROM mtl_item_revisions
2917: WHERE inventory_item_id = p_item_id
2918: AND organization_id = p_organization_id
2919: AND revision = p_revision;
2920: