APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 394: SELECT mtl_material_transactions_s.nextval

390: trace('SPLIT_MMTT: p_txn_qty : ' ||p_txn_qty || ',p_pri_qty:'||p_pri_qty );
391: END IF;
392:
393:
394: SELECT mtl_material_transactions_s.nextval
395: INTO l_new_txn_temp_id FROM dual ;
396:
397:
398: INSERT INTO mtl_material_transactions_temp

Line 3199: SELECT mtl_material_transactions_s.NEXTVAL INTO l_txn_hdr_id FROM DUAL;

3195:
3196: SAVEPOINT WMS_DEVICE_REQUESTS_SP_OUTER;
3197:
3198: --this header_id will be used to call TM for the batch
3199: SELECT mtl_material_transactions_s.NEXTVAL INTO l_txn_hdr_id FROM DUAL;
3200:
3201: IF (l_debug = 1) THEN
3202: trace('Inside Device_Confirmation API:p_request_id'||p_request_id);
3203: END IF;