PO Receipt Traveler

Description
Categories: BI Publisher, Procurement
Application: Purchasing
Source: Receipt Traveler (XML)
Short Name: POXDLPDT_XML
DB package: PO_POXDLPDT_XMLP_PKG
		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
Parameter Name SQL text Validation
Category Structure
 
Number
Group ID
 
Number
Dynamic Precision Option
 
LOV Oracle
Ship to Location
 
LOV Oracle
To
 
Categories From
 
To
 
Items From
 
To
 
LOV Oracle
Receipt Numbers From
 
LOV Oracle
Receipt Source Type
 
LOV Oracle
Organization Name
 
LOV Oracle
Delivery Location
 
LOV Oracle
Operating Unit
 
LOV Oracle
Title