APPS.GMF_MIGRATION dependencies on IC_PERD_BAL

Line 8958: * populated correctly when ic_perd_bal has balances for the same *

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
8962: (

Line 9048: FROM ic_perd_bal b

9044: whse_code,
9045: item_id,
9046: lot_id,
9047: location
9048: FROM ic_perd_bal b
9049: WHERE b.fiscal_year = p_fiscal_year
9050: AND b.period = p_period
9051: AND b.whse_code = p_whse_code
9052: AND NOT EXISTS (

Line 9140: FROM ic_perd_bal

9136: /* Bug 13045530 Migrate Lots - End */
9137:
9138: SELECT count(1)
9139: INTO l_perd_bal_count
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

Line 9222: FROM ic_perd_bal a,

9218: NULL request_id,
9219: NULL program_application_id,
9220: NULL program_id,
9221: NULL program_update_date
9222: FROM ic_perd_bal a,
9223: ic_item_mst_b_mig b,
9224: /* ic_lots_mst_mig c, Bug 13942118 */
9225: (SELECT DISTINCT item_id, lot_id, whse_code, lot_number FROM ic_lots_mst_mig) c, /* Bug 13942118 */
9226: ic_loct_mst d,

Line 9276: FROM ic_perd_bal a,

9272: NULL request_id,
9273: NULL program_application_id,
9274: NULL program_id,
9275: NULL program_update_date
9276: FROM ic_perd_bal a,
9277: ic_item_mst_b_mig b,
9278: ic_loct_mst d,
9279: mtl_secondary_inventories e
9280: WHERE a.whse_code = i.whse_code

Line 9323: FROM ic_perd_bal

9319: **********************************************/
9320:
9321: SELECT count(*)
9322: INTO x_failure_count
9323: FROM ic_perd_bal
9324: WHERE whse_code = i.whse_code
9325: AND period_id = i.prior_period_id;
9326:
9327: IF nvl(x_failure_count,0) > 0 THEN