DBA Data[Home] [Help]

APPS.GMICCAL dependencies on GMI_PERD_BAL_ID_S

Line 402: SELECT gmi_perd_bal_id_s.nextval, 0, pper_id, pfiscal_year,

398: loct_usage, loct_usage2, loct_yield, loct_yield2,
399: loct_value, lot_status, qchold_res_code,
400: log_end_date, creation_date, created_by, last_update_date,
401: last_updated_by)
402: SELECT gmi_perd_bal_id_s.nextval, 0, pper_id, pfiscal_year,
403: pperiod, item_id, lot_id,
404: whse_code, location, ROUND(loct_onhand, 9),
405: ROUND(loct_onhand2, 9), 0,0,0,0,0,
406: lot_status, qchold_res_code, SYSDATE,

Line 584: (gmi_perd_bal_id_s.nextval, 0, pprd_id, l_prev_lot_id, --bug#2230683

580: loct_value, lot_status, qchold_res_code,
581: log_end_date, creation_date, created_by,
582: last_update_date, last_updated_by, last_update_login)
583: VALUES
584: (gmi_perd_bal_id_s.nextval, 0, pprd_id, l_prev_lot_id, --bug#2230683
585: pwhse_code, l_prev_location,
586: l_prev_item_id, pfiscal_year, pperiod,
587: ROUND((0 - l_delta_qty), 9),
588: ROUND((0 - l_delta_qty2), 9),