DBA Data[Home] [Help]

APPS.AHL_VWP_VISITS_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 1506: FROM mtl_secondary_inventories

1502:
1503: /*Added by sowsubra*/
1504: CURSOR c_subinv_validate (p_subinv_code IN VARCHAR2, p_org_id IN VARCHAR2) IS
1505: SELECT status_id
1506: FROM mtl_secondary_inventories
1507: WHERE secondary_inventory_name = p_subinv_code
1508: AND organization_id = p_org_id;
1509:
1510: /*Added by sowsubra*/

Line 2877: FROM mtl_secondary_inventories

2873:
2874: /*Added by sowsubra*/
2875: CURSOR c_subinv_validate (p_subinv_code IN VARCHAR2, p_org_id IN VARCHAR2) IS
2876: SELECT status_id
2877: FROM mtl_secondary_inventories
2878: WHERE secondary_inventory_name = p_subinv_code
2879: AND organization_id = p_org_id;
2880:
2881: /*Added by sowsubra*/