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.CLN_SYNC_INVENTORY_PKG dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 169: SELECT 'X' FROM mtl_secondary_inventories msi, mtl_onhand_quantities_detail moqd

165: WHERE (CLN_INVENTORY_REPORT_V.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID(+)
166: AND CLN_INVENTORY_REPORT_V.ORGANIZATION_ID = MIC.ORGANIZATION_ID(+))
167: AND MIC.category_id = nvl(p_item_category,MIC.category_id))
168: AND EXISTS (
169: SELECT 'X' FROM mtl_secondary_inventories msi, mtl_onhand_quantities_detail moqd
170: WHERE msi.organization_id = moqd.organization_id
171: AND msi.secondary_inventory_name = moqd.subinventory_code
172: AND msi.organization_id = CLN_INVENTORY_REPORT_V.organization_id
173: AND msi.secondary_inventory_name = NVL(p_sub_inv,msi.secondary_inventory_name)

Line 487: FROM mtl_onhand_quantities_detail moqd, mtl_secondary_inventories msi

483: l_onhand_source := 2;
484: BEGIN
485: SELECT nvl(sum(moqd.primary_transaction_quantity),0)
486: INTO x_quantity_blocked
487: FROM mtl_onhand_quantities_detail moqd, mtl_secondary_inventories msi
488: WHERE moqd.organization_id = p_inv_org
489: AND moqd.inventory_item_id = p_item_number
490: AND moqd.subinventory_code = msi.secondary_inventory_name
491: AND moqd.organization_id = msi.organization_id

Line 515: FROM mtl_onhand_quantities_detail moqd, mtl_secondary_inventories msi

511:
512: BEGIN
513: SELECT nvl(sum(moqd.primary_transaction_quantity),0)
514: INTO x_quantity_blocked
515: FROM mtl_onhand_quantities_detail moqd, mtl_secondary_inventories msi
516: WHERE moqd.organization_id = p_inv_org
517: AND moqd.inventory_item_id = p_item_number
518: AND moqd.subinventory_code = msi.secondary_inventory_name
519: AND moqd.organization_id = msi.organization_id

Line 543: FROM mtl_onhand_quantities_detail moqd, mtl_secondary_inventories msi

539:
540: BEGIN
541: SELECT nvl(sum(moqd.primary_transaction_quantity),0)
542: INTO x_quantity_blocked
543: FROM mtl_onhand_quantities_detail moqd, mtl_secondary_inventories msi
544: WHERE moqd.organization_id = p_inv_org
545: AND moqd.inventory_item_id = p_item_number
546: AND moqd.subinventory_code = msi.secondary_inventory_name
547: AND moqd.organization_id = msi.organization_id