DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on MTL_ITEM_REVISIONS

Line 1538: SELECT 'x' FROM mtl_item_revisions

1534: WHERE serial_number = p_serial_number
1535: AND inventory_item_id = p_inventory_item_id;
1536:
1537: CURSOR item_revisions_csr (p_revision IN VARCHAR2, p_item_id IN NUMBER, p_organization_id IN NUMBER) IS
1538: SELECT 'x' FROM mtl_item_revisions
1539: WHERE inventory_item_id = p_item_id
1540: AND organization_id = p_organization_id
1541: AND revision = p_revision;
1542:

Line 3339: SELECT 'x' FROM mtl_item_revisions

3335: SELECT 'x' FROM mtl_units_of_measure_vl
3336: WHERE uom_code = p_uom;
3337:
3338: CURSOR item_revisions_csr (p_revision IN VARCHAR2, p_item_id IN NUMBER, p_organization_id IN NUMBER) IS
3339: SELECT 'x' FROM mtl_item_revisions
3340: WHERE inventory_item_id = p_item_id
3341: AND organization_id = p_organization_id
3342: AND revision = p_revision;
3343: