eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_SYSTEM_ITEM_EVENT_PKG dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 639: FROM mtl_onhand_quantities_detail ohqmv

635: FROM csm_mtl_onhand_qty_acc ohqacc
636: WHERE NOT EXISTS
637: (
638: SELECT 1
639: FROM mtl_onhand_quantities_detail ohqmv
640: WHERE ohqacc.inventory_item_id = ohqmv.inventory_item_id
641: AND ohqacc.organization_id = ohqmv.organization_id
642: AND ohqacc.subinventory_code = ohqmv.subinventory_code
643: AND ((ohqacc.locator_id IS NULL AND ohqmv.locator_id IS NULL) OR (ohqacc.locator_id = ohqmv.locator_id))

Line 670: mtl_onhand_quantities_detail ohqmv

666: , ohqmv.LOT_NUMBER
667: , ohqacc.quantity
668: , SUM(ohqmv.transaction_quantity) tot_qty
669: FROM csm_mtl_onhand_qty_acc ohqacc,
670: mtl_onhand_quantities_detail ohqmv
671: WHERE ohqacc.inventory_item_id = ohqmv.inventory_item_id
672: AND ohqacc.organization_id = ohqmv.organization_id
673: AND ohqacc.subinventory_code = ohqmv.subinventory_code
674: AND ((ohqacc.locator_id IS NULL AND ohqmv.locator_id IS NULL) OR (ohqacc.locator_id = ohqmv.locator_id))

Line 693: FROM mtl_onhand_quantities_detail ohqmv2 WHERE

689: , ohqmv.LOCATOR_ID
690: , ohqmv.REVISION
691: , ohqmv.LOT_NUMBER
692: , (SELECT SUM (ohqmv2.transaction_quantity)
693: FROM mtl_onhand_quantities_detail ohqmv2 WHERE
694: ohqmv.ORGANIZATION_ID=ohqmv2.ORGANIZATION_ID AND
695: ohqmv.SUBINVENTORY_CODE=ohqmv2.SUBINVENTORY_CODE AND
696: ohqmv.INVENTORY_ITEM_ID=ohqmv2.INVENTORY_ITEM_ID AND
697: nvl(ohqmv.LOCATOR_ID,-9999)=nvl(ohqmv2.LOCATOR_ID,-9999) AND

Line 702: mtl_onhand_quantities_detail ohqmv,

698: nvl(ohqmv.REVISION,-9999)=nvl(ohqmv2.REVISION,-9999) AND
699: nvl(ohqmv.LOT_NUMBER,-9999)=nvl(ohqmv2.LOT_NUMBER,-9999))
700: FROM asg_user au,
701: asg_user_pub_resps aupr,
702: mtl_onhand_quantities_detail ohqmv,
703: mtl_system_items_b msi,
704: CS_BILLING_TYPE_CATEGORIES cbtc
705: WHERE au.user_name = aupr.user_name
706: AND aupr.pub_name = 'SERVICEP'

Line 747: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities_detail.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;

743: TYPE sub_codeTab IS TABLE OF csm_mtl_onhand_qty_acc.subinventory_code%TYPE INDEX BY BINARY_INTEGER;
744: TYPE rvsionTab IS TABLE OF csm_mtl_onhand_qty_acc.revision%TYPE INDEX BY BINARY_INTEGER;
745: TYPE loc_idTab IS TABLE OF csm_mtl_onhand_qty_acc.locator_id%TYPE INDEX BY BINARY_INTEGER;
746: TYPE lot_numTab IS TABLE OF csm_mtl_onhand_qty_acc.lot_number%TYPE INDEX BY BINARY_INTEGER;
747: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities_detail.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;
748: TYPE user_idTab IS TABLE OF asg_user.user_id%TYPE INDEX BY BINARY_INTEGER;
749: TYPE access_idTab IS TABLE OF csm_mtl_onhand_qty_acc.access_id%TYPE INDEX BY BINARY_INTEGER;
750:
751: inv_id inv_idTab;