APPS.WMS_RETURN_SV dependencies on MTL_MATERIAL_TRANSACTIONS

Line 137: FROM mtl_material_transactions mmt

133: , rt.transaction_type
134: , rt.parent_transaction_id
135: , rsl.asn_line_flag
136: , DECODE(MSI.RETURN_INSPECTION_REQUIREMENT,1,'Y','N') INSPECTION_REQUIRED_FLAG
137: FROM mtl_material_transactions mmt
138: , mtl_transaction_lot_numbers mtln
139: , rcv_shipment_lines rsl
140: , rcv_transactions rt
141: , mtl_system_items msi

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