DBA Data[Home] [Help]

APPS.GMI_INVENTORY_CLOSE_CONC dependencies on GMI_PERD_BAL_ID_S

Line 548: VALUES(gmi_perd_bal_id_s.nextval,0, pprd_id, pfiscal_year, pperiod, get_loct_onhand_rec.item_id, get_loct_onhand_rec.lot_id,

544: loct_usage, loct_usage2, loct_yield, loct_yield2,
545: loct_value, lot_status, qchold_res_code,
546: log_end_date, creation_date, created_by, last_update_date,
547: last_updated_by)
548: VALUES(gmi_perd_bal_id_s.nextval,0, pprd_id, pfiscal_year, pperiod, get_loct_onhand_rec.item_id, get_loct_onhand_rec.lot_id,
549: get_loct_onhand_rec.whse_code, get_loct_onhand_rec.location, get_loct_onhand_rec.onhand,
550: get_loct_onhand_rec.onhand2, 0,0,0,0,0,
551: x_lot_status, get_loct_onhand_rec.qchold_res_code, l_log_end_date,
552: SYSDATE, pop_code, SYSDATE, pop_code);

Line 650: (gmi_perd_bal_id_s.nextval, 0, pprd_id, l_prev_lot_id,

646: loct_value, lot_status, qchold_res_code,
647: log_end_date, creation_date, created_by,
648: last_update_date, last_updated_by, last_update_login)
649: VALUES
650: (gmi_perd_bal_id_s.nextval, 0, pprd_id, l_prev_lot_id,
651: pwhse_code, l_prev_location,
652: l_prev_item_id, pfiscal_year, pperiod,
653: ROUND((0 - l_delta_qty), 9),
654: ROUND((0 - l_delta_qty2), 9),