DBA Data[Home] [Help]

APPS.EAM_OPERATIONS_JSP dependencies on MTL_ONHAND_QUANTITIES

Line 2334: from mtl_secondary_inventories msinv, mtl_onhand_quantities moq

2330: CURSOR c_subinv_cur IS --rhshriva
2331: select msinv.secondary_inventory_name,
2332: SUM(moq.transaction_quantity) on_hand_quantity
2333:
2334: from mtl_secondary_inventories msinv, mtl_onhand_quantities moq
2335: where moq.organization_id=msinv.organization_id
2336: and nvl(msinv.disable_date, sysdate+2) > sysdate
2337: and moq.subinventory_code = msinv.secondary_inventory_name
2338: and msinv.organization_id = p_organization_id