[Home] [Help]
8953: * identifies all the organizations under the company and thus *
8954: * fetches all the warehouses under that company. *
8955: * *
8956: * 11-Apr-2012 Uday Phadtare Bug 13942118. *
8957: * Code modified so that data in gmf_period_balances gets *
8958: * populated correctly when ic_perd_bal has balances for the same *
8959: * lot in multiple locations. *
8960: **********************************************************************/
8961: PROCEDURE Migrate_Period_Balances
9062:
9063: BEGIN
9064:
9065: G_Migration_run_id := P_migration_run_id;
9066: G_Table_name := 'GMF_PERIOD_BALANCES';
9067: G_Context := 'Period Balances Migration';
9068: X_failure_count := 0;
9069:
9070: /********************************
9140: FROM ic_perd_bal
9141: WHERE whse_code = i.whse_code
9142: AND period_id = i.prior_period_id;
9143:
9144: INSERT INTO gmf_period_balances
9145: (
9146: period_balance_id,
9147: acct_period_id,
9148: organization_id,
9168: program_id,
9169: program_update_date
9170: )
9171: (
9172: SELECT gmf_period_balances_s.NEXTVAL,
9173: acct_period_id,
9174: organization_id,
9175: cost_group_id,
9176: subinventory_code,
9239: AND d.location = a.location
9240: AND a.lot_id <> 0 /* Bug 13045530 */
9241: AND NOT EXISTS (
9242: SELECT 'X'
9243: FROM gmf_period_balances x
9244: WHERE x.acct_period_id = i.acct_period_id
9245: AND x.organization_id = i.organization_id
9246: AND x.inventory_item_id = b.inventory_item_id
9247: AND nvl(x.subinventory_code, '~') = nvl(decode(i.subinventory_ind_flag, 'N', NULL, e.secondary_inventory_name), '~')
9287: AND d.location = a.location
9288: AND a.lot_id = 0 /* Bug 13045530 */
9289: AND NOT EXISTS (
9290: SELECT 'X'
9291: FROM gmf_period_balances x
9292: WHERE x.acct_period_id = i.acct_period_id
9293: AND x.organization_id = i.organization_id
9294: AND x.inventory_item_id = b.inventory_item_id
9295: AND nvl(x.subinventory_code, '~') = nvl(decode(i.subinventory_ind_flag, 'N', NULL, e.secondary_inventory_name), '~')