DBA Data[Home] [Help]

APPS.GMF_MIGRATION dependencies on IC_PERD_BAL

Line 8950: FROM ic_perd_bal

8946: FOR i IN cur_orgn_periods LOOP
8947:
8948: SELECT count(1)
8949: INTO l_perd_bal_count
8950: FROM ic_perd_bal
8951: WHERE whse_code = i.whse_code
8952: AND period_id = i.prior_period_id;
8953:
8954: INSERT INTO gmf_period_balances

Line 9006: FROM ic_perd_bal a,

9002: NULL,
9003: NULL,
9004: NULL,
9005: NULL
9006: FROM ic_perd_bal a,
9007: ic_item_mst_b_mig b,
9008: ic_lots_mst_mig c,
9009: ic_loct_mst d,
9010: mtl_secondary_inventories e

Line 9056: FROM ic_perd_bal

9052: **********************************************/
9053:
9054: SELECT count(*)
9055: INTO x_failure_count
9056: FROM ic_perd_bal
9057: WHERE whse_code = i.whse_code
9058: AND period_id = i.prior_period_id;
9059:
9060: IF nvl(x_failure_count,0) > 0 THEN