DBA Data[Home] [Help]

APPS.AHL_PRD_OPERATIONS_PVT dependencies on MTL_ITEM_SUB_INVENTORIES

Line 772: FROM MTL_ITEM_SUB_INVENTORIES a,

768:
769: CURSOR get_completion_sub_inv(c_com_subinv VARCHAR2,c_inventory_item_id NUMBER)
770: IS
771: SELECT a.Secondary_inventory
772: FROM MTL_ITEM_SUB_INVENTORIES a,
773: MTL_PARAMETERS b
774: WHERE a.Secondary_inventory=c_com_subinv
775: AND a.organization_id=b.organization_id
776: AND a.inventory_item_id=c_inventory_item_id;