DBA Data[Home] [Help]

APPS.WMS_RETURN_SV dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 3262: /* SELECT mtl_material_transactions_s.NEXTVAL

3258: FROM mtl_system_items
3259: WHERE INVENTORY_ITEM_ID = l_item_id
3260: AND ORGANIZATION_ID = l_org_id
3261: AND ROWNUM <2 ; */
3262: /* SELECT mtl_material_transactions_s.NEXTVAL
3263: INTO l_trx_header_id
3264: FROM dual; */
3265:
3266: IF (l_debug = 1) THEN

Line 3435: SELECT mtl_material_transactions_s.NEXTVAL INTO l_trx_header_id FROM dual;

3431: print_debug('Enter cancel_return_order_RTV :Sum of RTi qty w.r.t LPN id: ' || l_lpnrti_rec.rti_qty);
3432: END IF;
3433:
3434: --Review Comments
3435: SELECT mtl_material_transactions_s.NEXTVAL INTO l_trx_header_id FROM dual;
3436: --Review Comments
3437:
3438: OPEN get_unpack_lpn(l_lpnrti_rec.transfer_lpn_id,l_lpnrti_rec.rti_qty);
3439: LOOP