DBA Data[Home] [Help]

APPS.OKL_SYP_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 1085: FROM MTL_SECONDARY_INVENTORIES

1081: p_remk_subinventory IN VARCHAR2) IS
1082:
1083: CURSOR l_mtlsecinventories_csr(cp_SECONDARY_INVENTORY_NAME IN VARCHAR2) IS
1084: SELECT 'x'
1085: FROM MTL_SECONDARY_INVENTORIES
1086: WHERE SECONDARY_INVENTORY_NAME = cp_SECONDARY_INVENTORY_NAME
1087: AND NVL(DISABLE_DATE, SYSDATE+1) > SYSDATE
1088: AND LOCATOR_TYPE=1
1089: AND ASSET_INVENTORY = 1

Line 2263: FROM mtl_secondary_inventories

2259: -- SECHAWLA 16-DEC-04 4067511 : added following cursors
2260: -- This cursor is used to validate Organization and subinventory
2261: CURSOR l_mtlsecinv_csr(cp_inv_org_id NUMBER, cp_subinv_code VARCHAR2) IS
2262: SELECT 'x'
2263: FROM mtl_secondary_inventories
2264: WHERE organization_id = cp_inv_org_id
2265: AND secondary_inventory_name = cp_subinv_code;
2266:
2267: -- get org name