PO Receipt Traveler

		SELECT rrp.org_id,
		rrp.item_id,
		rrp.organization_id rrp_organization_id,
		decode(msi.inventory_item_id,null,null,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE')) C_FLEX_ITEM,   -- Bug18732768	
     	decode(rrp.category_id,null,null,fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'VALUE')) C_FLEX_CAT,           -- Bug18732768
		--fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_item_disp', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') C_FLEX_ITEM,
		--fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_cat_disp', 'INV', 'MCAT', MCA.STRUCTURE_ID, NULL, MCA.CATEGORY_ID, 'ALL', 'Y', 'VALUE')  C_FLEX_CAT,
		rrp.revision_num,
		rrp.category_id,
		rrp.item_description,
		rrp.un_num,
		rrp.un_description,
		rrp.hazard_class,
		rrp.routing_name,
		rrp.document_type_code,
		rrp.document_number,
		rrp.release_num,
		rrp.line_num,
		rrp.buyer_preparer_name,
		rrp.source_type,
		rrp.source,
		rrp.source_unit_of_measure,
		rrp.vendor_product_num,
		fnd_date.date_to_canonical(rrp.due_date) due_date,
		round(rrp.quantity_ordered, :P_QTY_PRECISION) quantity_ordered,
		rrp.note_to_receiver,
		rrp.pll_note_to_receiver,
		rrp.receipt_num RECEIPT_NUM,
		rrp.receipt_unit_of_measure,
		fnd_date.date_to_canonical(rrp.receipt_date) receipt_date,
		rrp.RECEIPT_LOCATION, rrp.receiver_first_name,
		rrp.receiver_last_name,
		rrp.freight_carrier,
		round(rrp.quantity_received, :P_QTY_PRECISION ) quantity_received,
		po_poxdlpdt_xmlp_pkg.quantity_received_fn(rrp.from_interface
                            ,rrp.transaction_id
                            ,rrp.primary_quantity 
                            ,:c_sum_corrected_qty 
                            ,rrp.quantity_received
                            ,rrp.shipment_line_id
                            ,rrp.receipt_unit_of_measure
                            ,rrp.item_id)  c_effective_qty_rcv , -- bug17161858
		rrp.primary_quantity parent_primary_quantity,
		round(rrp.quantity_remaining, :P_QTY_PRECISION ) quantity_remaining,
		po_poxdlpdt_xmlp_pkg.c_quantity_remaining_printform
        (rrp.quantity_remaining,
        :source_doc_unit_of_measure,
        rrp.receipt_unit_of_measure,
        rrp.item_id,
        rrp.organization_id
        ) c_quantity_remaining_print, --Bug17161858
		rrp.shipment_num,
		rrp.bill_of_lading,
		rrp.vendor_lot_num,
		rrp.packing_slip_num,
		rrp.containers,
		rrp.receiver_comment,
		rrp.transaction_type rrp_transaction_type,
		rrp.transaction_id rrp_transaction_id,
		rrp.shipment_line_id rrp_shipment_line_id,
		rrp.shipment_header_id rrp_shipment_header_id,
		rrp.distribution_id rrp_distribution_id,
		rrp.po_header_id, rrp.po_line_id,
		rrp.po_line_location_id,
		rrp.requisition_header_id,
		rrp.requisition_line_id,
		rrp.from_interface rrp_from_interface,
		rrp.deliver_to_location DELIVER_TO_LOCATION2,
		rrp.transfer_license_plate_number license_plate_number,
		rrp.locator_id LOCATOR_ID1,
		rrp.receiving_subinventory,
		PO_POXDLPDT_XMLP_PKG.BOILER_PLATE_DOC_TYPE(rrp.transaction_type) DOC_TYPE_BOILERPLATE,
		PO_POXDLPDT_XMLP_PKG.boiler_plate_buyer(rrp.transaction_type) Buyer_Preparer,
		PO_POXDLPDT_XMLP_PKG.boiler_plate_doc_num(rrp.transaction_type) Doc_Num_Boiler_Plate,
		PO_POXDLPDT_XMLP_PKG.CF_DIRECT_RCV_DLVFORMULA(rrp.transaction_id,rrp.from_interface) CF_DIRECT_RCV_DLV,
		PO_POXDLPDT_XMLP_PKG.CF_RECEIPT_LOCATIONFORMULA(rrp.locator_id ,rrp.RECEIPT_LOCATION,rrp.receiving_subinventory) CF_RECEIPT_LOCATION,
		PO_POXDLPDT_XMLP_PKG.CF_OPERATING_UNITFORMULA(rrp.org_id) CF_OPERATING_UNIT
		FROM &from_lexical ,
		    mtl_system_items msi,
		    mtl_categories mca
		WHERE mca.category_id = rrp.category_id
		AND msi.inventory_item_id (+) = rrp.item_id
		&and_lexical
		AND &P_WHERE_GROUP_ID
		AND &P_WHERE_ITEM
		AND &P_WHERE_CAT
		AND &P_WHERE_RECEIPT_NUM_FROM
		AND &P_WHERE_RECEIPT_NUM_TO
		AND &P_WHERE_SHIP_TO_LOCATION
		AND &P_WHERE_DELIVER_TO_LOCATION
		AND &P_WHERE_ORG_ID
		order by 2,25