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.GMF_CMCOMMON dependencies on MTL_SECONDARY_INVENTORIES

Line 682: FROM mtl_onhand_quantities_detail moqd, mtl_secondary_inventories msi

678: -- ?? What about negative on hands in both the cursors ??
679:
680: CURSOR cur_moqd (v_inventory_item_id NUMBER, v_organization_id NUMBER) IS
681: SELECT nvl(sum(moqd.primary_transaction_quantity), 0) qty, lot_number
682: FROM mtl_onhand_quantities_detail moqd, mtl_secondary_inventories msi
683: WHERE moqd.organization_id = v_organization_id
684: AND moqd.inventory_item_id = v_inventory_item_id
685: AND moqd.is_consigned = 2
686: AND msi.secondary_inventory_name = moqd.subinventory_code

Line 694: FROM gmf_period_balances gpb, org_acct_periods oap, mtl_secondary_inventories msi

690:
691:
692: CURSOR cur_gmf_perd_bal (v_inventory_item_id NUMBER, v_organization_id NUMBER, v_fiscal_year NUMBER, v_period NUMBER) IS
693: SELECT nvl(sum(gpb.primary_quantity), 0) qty, lot_number
694: FROM gmf_period_balances gpb, org_acct_periods oap, mtl_secondary_inventories msi
695: WHERE gpb.organization_id = v_organization_id
696: AND gpb.inventory_item_id = v_inventory_item_id
697: AND gpb.acct_period_id = oap.acct_period_id
698: AND oap.organization_id = gpb.organization_id