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 728: FROM mtl_onhand_quantities_detail ohqmv

724: FROM csm_mtl_onhand_qty_acc ohqacc
725: WHERE NOT EXISTS
726: (
727: SELECT 1
728: FROM mtl_onhand_quantities_detail ohqmv
729: WHERE ohqacc.inventory_item_id = ohqmv.inventory_item_id
730: AND ohqacc.organization_id = ohqmv.organization_id
731: AND ohqacc.subinventory_code = ohqmv.subinventory_code
732: AND ((ohqacc.locator_id IS NULL AND ohqmv.locator_id IS NULL) OR (ohqacc.locator_id = ohqmv.locator_id))

Line 759: mtl_onhand_quantities_detail ohqmv

755: , ohqmv.LOT_NUMBER
756: , ohqacc.quantity
757: , SUM(ohqmv.transaction_quantity) tot_qty
758: FROM csm_mtl_onhand_qty_acc ohqacc,
759: mtl_onhand_quantities_detail ohqmv
760: WHERE ohqacc.inventory_item_id = ohqmv.inventory_item_id
761: AND ohqacc.organization_id = ohqmv.organization_id
762: AND ohqacc.subinventory_code = ohqmv.subinventory_code
763: AND ((ohqacc.locator_id IS NULL AND ohqmv.locator_id IS NULL) OR (ohqacc.locator_id = ohqmv.locator_id))

Line 782: FROM mtl_onhand_quantities_detail ohqmv2 WHERE

778: , ohqmv.LOCATOR_ID
779: , ohqmv.REVISION
780: , ohqmv.LOT_NUMBER
781: , (SELECT SUM (ohqmv2.transaction_quantity)
782: FROM mtl_onhand_quantities_detail ohqmv2 WHERE
783: ohqmv.ORGANIZATION_ID=ohqmv2.ORGANIZATION_ID AND
784: ohqmv.SUBINVENTORY_CODE=ohqmv2.SUBINVENTORY_CODE AND
785: ohqmv.INVENTORY_ITEM_ID=ohqmv2.INVENTORY_ITEM_ID AND
786: nvl(ohqmv.LOCATOR_ID,-9999)=nvl(ohqmv2.LOCATOR_ID,-9999) AND

Line 791: mtl_onhand_quantities_detail ohqmv,

787: nvl(ohqmv.REVISION,-9999)=nvl(ohqmv2.REVISION,-9999) AND
788: nvl(ohqmv.LOT_NUMBER,-9999)=nvl(ohqmv2.LOT_NUMBER,-9999))
789: FROM asg_user au,
790: asg_user_pub_resps aupr,
791: mtl_onhand_quantities_detail ohqmv,
792: mtl_system_items_b msi,
793: CS_BILLING_TYPE_CATEGORIES cbtc
794: WHERE au.user_name = aupr.user_name
795: AND aupr.pub_name = 'SERVICEP'

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

832: TYPE sub_codeTab IS TABLE OF csm_mtl_onhand_qty_acc.subinventory_code%TYPE INDEX BY BINARY_INTEGER;
833: TYPE rvsionTab IS TABLE OF csm_mtl_onhand_qty_acc.revision%TYPE INDEX BY BINARY_INTEGER;
834: TYPE loc_idTab IS TABLE OF csm_mtl_onhand_qty_acc.locator_id%TYPE INDEX BY BINARY_INTEGER;
835: TYPE lot_numTab IS TABLE OF csm_mtl_onhand_qty_acc.lot_number%TYPE INDEX BY BINARY_INTEGER;
836: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities_detail.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;
837: TYPE user_idTab IS TABLE OF asg_user.user_id%TYPE INDEX BY BINARY_INTEGER;
838: TYPE access_idTab IS TABLE OF csm_mtl_onhand_qty_acc.access_id%TYPE INDEX BY BINARY_INTEGER;
839:
840: inv_id inv_idTab;

Line 1393: mtl_onhand_quantities_detail ohqmv

1389: , ohqmv.LOT_NUMBER
1390: , ohqacc.quantity
1391: , SUM(ohqmv.transaction_quantity) tot_qty
1392: FROM csm_mtl_onhand_qty_acc ohqacc,
1393: mtl_onhand_quantities_detail ohqmv
1394: WHERE ohqmv.inventory_item_id=p_item_id
1395: AND ohqmv.organization_id=p_org_id
1396: AND nvl(ohqmv.subinventory_code,'-999') = nvl(p_subinv_code,'-999')
1397: AND ohqacc.user_id=p_user_id

Line 1417: FROM mtl_onhand_quantities_detail ohqmv2 WHERE

1413: , ohqmv.LOCATOR_ID
1414: , ohqmv.REVISION
1415: , ohqmv.LOT_NUMBER
1416: , (SELECT SUM (ohqmv2.transaction_quantity)
1417: FROM mtl_onhand_quantities_detail ohqmv2 WHERE
1418: ohqmv.ORGANIZATION_ID=ohqmv2.ORGANIZATION_ID AND
1419: ohqmv.SUBINVENTORY_CODE=ohqmv2.SUBINVENTORY_CODE AND
1420: ohqmv.INVENTORY_ITEM_ID=ohqmv2.INVENTORY_ITEM_ID AND
1421: nvl(ohqmv.LOCATOR_ID,-9999)=nvl(ohqmv2.LOCATOR_ID,-9999) AND

Line 1425: mtl_onhand_quantities_detail ohqmv

1421: nvl(ohqmv.LOCATOR_ID,-9999)=nvl(ohqmv2.LOCATOR_ID,-9999) AND
1422: nvl(ohqmv.REVISION,'-9999')=nvl(ohqmv2.REVISION,'-9999') AND
1423: nvl(ohqmv.LOT_NUMBER,'-9999')=nvl(ohqmv2.LOT_NUMBER,'-9999'))
1424: FROM asg_user au,
1425: mtl_onhand_quantities_detail ohqmv
1426: WHERE ohqmv.inventory_item_id=p_item_id
1427: AND ohqmv.organization_id=p_org_id
1428: AND nvl(ohqmv.subinventory_code,'-999') = nvl(p_subinv_code,'-999')
1429: AND au.user_id = au.owner_id

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

1482: TYPE sub_codeTab IS TABLE OF csm_mtl_onhand_qty_acc.subinventory_code%TYPE INDEX BY BINARY_INTEGER;
1483: TYPE rvsionTab IS TABLE OF csm_mtl_onhand_qty_acc.revision%TYPE INDEX BY BINARY_INTEGER;
1484: TYPE loc_idTab IS TABLE OF csm_mtl_onhand_qty_acc.locator_id%TYPE INDEX BY BINARY_INTEGER;
1485: TYPE lot_numTab IS TABLE OF csm_mtl_onhand_qty_acc.lot_number%TYPE INDEX BY BINARY_INTEGER;
1486: TYPE tran_qtyTab IS TABLE OF mtl_onhand_quantities_detail.transaction_quantity%TYPE INDEX BY BINARY_INTEGER;
1487: TYPE user_idTab IS TABLE OF asg_user.user_id%TYPE INDEX BY BINARY_INTEGER;
1488: TYPE access_idTab IS TABLE OF csm_mtl_onhand_qty_acc.access_id%TYPE INDEX BY BINARY_INTEGER;
1489:
1490: inv_id inv_idTab;