APPS.GMF_CMCOMMON dependencies on GMF_PERIOD_BALANCES

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

Line 879: -- get the lots and lot qty from gmf_period_balances;

875: END IF;
876:
877: IF (p_from_where = 'GPB') then -- add item lot costed check as well??
878:
879: -- get the lots and lot qty from gmf_period_balances;
880:
881: FOR cur_gmf_perd_bal_rec IN cur_gmf_perd_bal (p_inventory_item_id, p_organization_id, p_fiscal_year, p_period)
882: LOOP
883: l_cum_qty := l_cum_qty + cur_gmf_perd_bal_rec.qty;