DBA Data[Home] [Help]

APPS.GMF_CMCOMMON dependencies on ORG_ACCT_PERIODS

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