393:
394: /* -- moved to procedure RCV_TRANSACTIONS_SV.get_rma_dest_info()
395:
396: select displayed_field, lookup_code into x_destination_type_dsp, x_destination_type_code
397: from po_lookup_codes where
398: lookup_CODE = 'RECEIVING' and
399: lookup_type = 'RCV DESTINATION TYPE'; */
400:
401: /* Bug#4684017 START */
526: x_task_number, --
527: l_code_combination_id --
528: FROM rcv_shipment_lines rsl,
529: hr_locations hlo,
530: po_lookup_codes polc,
531: po_requisition_lines PRL, --
532: po_req_distributions PRD, --
533: mtl_kanban_cards MKC, --
534: pjm_projects_all_v PPA, --