DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 1792: FROM mtl_secondary_inventories

1788: AND NVL(completion_date,SYSDATE+1)>=SYSDATE;
1789: /*Added by sowsubra*/
1790: CURSOR c_subinv_validate (p_subinv_code IN VARCHAR2, p_org_id IN VARCHAR2) IS
1791: SELECT status_id
1792: FROM mtl_secondary_inventories
1793: WHERE secondary_inventory_name = p_subinv_code
1794: AND organization_id = p_org_id;
1795:
1796: /*Added by sowsubra*/

Line 3474: FROM mtl_secondary_inventories

3470:
3471: /*Added by sowsubra*/
3472: CURSOR c_subinv_validate (p_subinv_code IN VARCHAR2, p_org_id IN VARCHAR2) IS
3473: SELECT status_id
3474: FROM mtl_secondary_inventories
3475: WHERE secondary_inventory_name = p_subinv_code
3476: AND organization_id = p_org_id;
3477:
3478: /*Added by sowsubra*/