ICX Military Interdepartmental Purchase Request
Description
Categories: BI Publisher
Application: Oracle iProcurement
Source:
Short Name: ICXCLMREQ_XML
DB package: ICX_DATATEMPLATE_PKG
Source:
Short Name: ICXCLMREQ_XML
DB package: ICX_DATATEMPLATE_PKG
Run
ICX Military Interdepartmental Purchase Request and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT REQUISITION_LINE_ID as reqLineId , REQUISITION_HEADER_ID , LINE_NUM , LINE_TYPE_ID , CATEGORY_ID , ITEM_DESCRIPTION , UNIT_MEAS_LOOKUP_CODE , UNIT_PRICE , QUANTITY , DELIVER_TO_LOCATION_ID , TO_PERSON_ID , LAST_UPDATE_DATE , LAST_UPDATED_BY , SOURCE_TYPE_CODE , LAST_UPDATE_LOGIN , CREATION_DATE , CREATED_BY , ITEM_ID , ITEM_REVISION , QUANTITY_DELIVERED , SUGGESTED_BUYER_ID , ENCUMBERED_FLAG , RFQ_REQUIRED_FLAG , NEED_BY_DATE , LINE_LOCATION_ID , MODIFIED_BY_AGENT_FLAG , PARENT_REQ_LINE_ID , JUSTIFICATION , NOTE_TO_AGENT , NOTE_TO_RECEIVER , PURCHASING_AGENT_ID , DOCUMENT_TYPE_CODE , BLANKET_PO_HEADER_ID , BLANKET_PO_LINE_NUM , CURRENCY_CODE , RATE_TYPE , RATE_DATE , RATE , CURRENCY_UNIT_PRICE , SUGGESTED_VENDOR_NAME , SUGGESTED_VENDOR_LOCATION , SUGGESTED_VENDOR_CONTACT , SUGGESTED_VENDOR_PHONE , SUGGESTED_VENDOR_PRODUCT_CODE , UN_NUMBER_ID , HAZARD_CLASS_ID , MUST_USE_SUGG_VENDOR_FLAG , REFERENCE_NUM , ON_RFQ_FLAG , URGENT_FLAG , CANCEL_FLAG , SOURCE_ORGANIZATION_ID , SOURCE_SUBINVENTORY , DESTINATION_TYPE_CODE , DESTINATION_ORGANIZATION_ID , DESTINATION_SUBINVENTORY , QUANTITY_CANCELLED , CANCEL_DATE , CANCEL_REASON , CLOSED_CODE , AGENT_RETURN_NOTE , CHANGED_AFTER_RESEARCH_FLAG , VENDOR_ID , VENDOR_SITE_ID , VENDOR_CONTACT_ID , RESEARCH_AGENT_ID , ON_LINE_FLAG , WIP_ENTITY_ID , WIP_LINE_ID , WIP_REPETITIVE_SCHEDULE_ID , WIP_OPERATION_SEQ_NUM , WIP_RESOURCE_SEQ_NUM , ATTRIBUTE_CATEGORY , DESTINATION_CONTEXT , INVENTORY_SOURCE_CONTEXT , VENDOR_SOURCE_CONTEXT , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , BOM_RESOURCE_ID , REQUEST_ID , PROGRAM_APPLICATION_ID , PROGRAM_ID , PROGRAM_UPDATE_DATE , USSGL_TRANSACTION_CODE , GOVERNMENT_CONTEXT , CLOSED_REASON , CLOSED_DATE , TRANSACTION_REASON_CODE , QUANTITY_RECEIVED , SOURCE_REQ_LINE_ID , ORG_ID , GLOBAL_ATTRIBUTE1 , GLOBAL_ATTRIBUTE2 , GLOBAL_ATTRIBUTE3 , GLOBAL_ATTRIBUTE4 , GLOBAL_ATTRIBUTE5 , GLOBAL_ATTRIBUTE6 , GLOBAL_ATTRIBUTE7 , GLOBAL_ATTRIBUTE8 , GLOBAL_ATTRIBUTE9 , GLOBAL_ATTRIBUTE10 , GLOBAL_ATTRIBUTE11 , GLOBAL_ATTRIBUTE12 , GLOBAL_ATTRIBUTE13 , GLOBAL_ATTRIBUTE14 , GLOBAL_ATTRIBUTE15 , GLOBAL_ATTRIBUTE16 , GLOBAL_ATTRIBUTE17 , GLOBAL_ATTRIBUTE18 , GLOBAL_ATTRIBUTE19 , GLOBAL_ATTRIBUTE20 , GLOBAL_ATTRIBUTE_CATEGORY , KANBAN_CARD_ID , CATALOG_TYPE , CATALOG_SOURCE , MANUFACTURER_ID , MANUFACTURER_NAME , MANUFACTURER_PART_NUMBER , REQUESTER_EMAIL , REQUESTER_FAX , REQUESTER_PHONE , UNSPSC_CODE , OTHER_CATEGORY_CODE , SUPPLIER_DUNS , TAX_STATUS_INDICATOR , PCARD_FLAG , NEW_SUPPLIER_FLAG , AUTO_RECEIVE_FLAG , TAX_USER_OVERRIDE_FLAG , TAX_CODE_ID , NOTE_TO_VENDOR , OKE_CONTRACT_VERSION_ID , OKE_CONTRACT_HEADER_ID , ITEM_SOURCE_ID , SUPPLIER_REF_NUMBER , SECONDARY_UNIT_OF_MEASURE , SECONDARY_QUANTITY , PREFERRED_GRADE , SECONDARY_QUANTITY_RECEIVED , SECONDARY_QUANTITY_CANCELLED , VMI_FLAG , AUCTION_HEADER_ID , AUCTION_DISPLAY_NUMBER , AUCTION_LINE_NUMBER , REQS_IN_POOL_FLAG , BID_NUMBER , BID_LINE_NUMBER , NONCAT_TEMPLATE_ID , SUGGESTED_VENDOR_CONTACT_FAX , SUGGESTED_VENDOR_CONTACT_EMAIL, AMOUNT , CURRENCY_AMOUNT , LABOR_REQ_LINE_ID , JOB_ID , JOB_LONG_DESCRIPTION , CONTRACTOR_STATUS , CONTACT_INFORMATION , SUGGESTED_SUPPLIER_FLAG , CANDIDATE_SCREENING_REQD_FLAG , ASSIGNMENT_END_DATE , OVERTIME_ALLOWED_FLAG , CONTRACTOR_REQUISITION_FLAG , DROP_SHIP_FLAG , CANDIDATE_FIRST_NAME , CANDIDATE_LAST_NAME , ASSIGNMENT_START_DATE , ORDER_TYPE_LOOKUP_CODE , PURCHASE_BASIS , MATCHING_BASIS , NEGOTIATED_BY_PREPARER_FLAG , SHIP_METHOD , ESTIMATED_PICKUP_DATE , SUPPLIER_NOTIFIED_FOR_CANCEL , BASE_UNIT_PRICE , AT_SOURCING_FLAG , TAX_ATTRIBUTE_UPDATE_CODE , TAX_NAME , TRANSFERRED_TO_OE_FLAG , CONFORMED_LINE_ID , AMENDMENT_TYPE , AMENDMENT_STATUS , LINE_NUM_DISPLAY , GROUP_LINE_ID , CLM_INFO_FLAG , CLM_OPTION_INDICATOR , CLM_BASE_LINE_NUM , CLM_OPTION_NUM , CLM_OPTION_FROM_DATE , CLM_OPTION_TO_DATE , CLM_FUNDED_FLAG , UDA_TEMPLATE_ID , CONTRACT_TYPE , COST_CONSTRAINT , AMENDMENT_RESPONSE_REASON , CLM_PERIOD_PERF_START_DATE , CLM_PERIOD_PERF_END_DATE , CLM_EXTENDED_ITEM_DESCRIPTION , CLM_OPTION_EXERCISED , IS_LINE_NUM_DISPLAY_MODIFIED , ASSIGNMENT_NUMBER , PO_DRAFT_ID , PO_LINE_ID , CLM_EXERCISED_DATE , LINKED_TO_FUND , FUND_SOURCE_NOT_KNOWN , LINKED_PO_COUNT , CLM_MIPR_OBLIGATION_TYPE , ICX_DATATEMPLATE_PKG.GET_ADDRESS_FROM_LOCATION (DELIVER_TO_LOCATION_ID) DELIVER_TO_ADDRESS FROM PO_REQUISITION_LINES_ALL PRL WHERE PRL.REQUISITION_HEADER_ID = &reqHeaderId ORDER BY NVL(LINE_NUM_DISPLAY, LINE_NUM) |