DBA Data[Home] [Help]

APPS.M4R_7B1_WSM_IN dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 3229: SELECT mtl_material_transactions_s.NEXTVAL

3225: l_trx_bat_seq :=1;
3226:
3227: SAVEPOINT before_insert;
3228:
3229: SELECT mtl_material_transactions_s.NEXTVAL
3230: INTO l_trx_if_id
3231: FROM DUAL;
3232:
3233: SELECT mtl_material_transactions_s.NEXTVAL

Line 3233: SELECT mtl_material_transactions_s.NEXTVAL

3229: SELECT mtl_material_transactions_s.NEXTVAL
3230: INTO l_trx_if_id
3231: FROM DUAL;
3232:
3233: SELECT mtl_material_transactions_s.NEXTVAL
3234: INTO l_trx_hdr_id
3235: FROM DUAL;
3236:
3237: IF (g_debug_level <= 1) THEN

Line 3337: SELECT mtl_material_transactions_s.NEXTVAL

3333: RAISE CORR_REC_FAILED;
3334:
3335: ELSE
3336:
3337: SELECT mtl_material_transactions_s.NEXTVAL
3338: INTO l_trx_if_id
3339: FROM DUAL;
3340:
3341: l_trx_bat_seq := l_trx_bat_seq +1;

Line 3502: SELECT mtl_material_transactions_s.NEXTVAL

3498:
3499: l_trx_bat_seq := l_trx_bat_seq +1;
3500: l_lot_qty := - l_rec.prev_lot_qty;
3501:
3502: SELECT mtl_material_transactions_s.NEXTVAL
3503: INTO l_trx_if_id
3504: FROM DUAL;
3505:
3506: IF (g_debug_level <= 1) THEN

Line 3704: SELECT mtl_material_transactions_s.NEXTVAL

3700: NULL, -- WIP NAME
3701: l_retcode,
3702: l_err_msg);
3703:
3704: SELECT mtl_material_transactions_s.NEXTVAL
3705: INTO l_trx_if_id
3706: FROM DUAL;
3707:
3708: INSERT_INV_REC( p_process_type,