VIEW: APPS.PO_OWNED_REQUISITION_LINES

Source

View Text - Preformatted

SELECT PORL.requisition_line_id , PORL.requisition_header_id , PORL.line_num , PORL.line_type_id , PORL.category_id , PORL.item_description , PORL.unit_meas_lookup_code , PORL.unit_price , PORL.quantity , PORL.deliver_to_location_id , PORL.to_person_id , PORL.last_update_date , PORL.last_updated_by , PORL.source_type_code , PORH.preparer_id , PORL.last_update_login , PORL.creation_date , PORL.created_by , PORL.item_id , PORL.item_revision , PORL.quantity_delivered , PORL.suggested_buyer_id , PORL.encumbered_flag , PORL.rfq_required_flag , PORL.need_by_date , PORL.line_location_id , PORL.modified_by_agent_flag , PORL.parent_req_line_id , PORL.justification , PORL.note_to_agent , PORL.note_to_receiver , PORL.purchasing_agent_id , PORL.blanket_po_header_id , PORL.blanket_po_line_num , PORL.suggested_vendor_name , PORL.suggested_vendor_location , PORL.suggested_vendor_contact , PORL.suggested_vendor_phone , PORL.suggested_vendor_product_code , PORL.un_number_id , PORL.hazard_class_id , PORL.must_use_sugg_vendor_flag , PORL.reference_num , PORL.on_rfq_flag , PORL.urgent_flag , PORL.cancel_flag , PORL.source_organization_id , PORL.source_subinventory , PORL.destination_type_code , PORL.destination_organization_id , PORL.destination_subinventory , PORL.quantity_cancelled , PORL.cancel_date , PORL.cancel_reason , PORL.closed_code , PORL.agent_return_note , PORL.changed_after_research_flag , PORL.vendor_id , PORL.vendor_site_id , PORL.vendor_contact_id , PORL.research_agent_id , PORL.on_line_flag , PORL.wip_entity_id , PORL.wip_line_id , PORL.wip_repetitive_schedule_id , PORL.wip_operation_seq_num , PORL.wip_resource_seq_num , PORL.bom_resource_id , PORL.destination_context , PORL.inventory_source_context , PORL.vendor_source_context , PORL.ussgl_transaction_code , PORL.government_context , PORL.attribute_category , PORL.attribute1 , PORL.attribute2 , PORL.attribute3 , PORL.attribute4 , PORL.attribute5 , PORL.attribute6 , PORL.attribute7 , PORL.attribute8 , PORL.attribute9 , PORL.attribute10 , PORL.attribute11 , PORL.attribute12 , PORL.attribute13 , PORL.attribute14 , PORL.attribute15 ,PORL.org_id FROM PO_REQUISITION_LINES PORL, PO_REQUISITION_HEADERS_ALL PORH WHERE PORH.requisition_header_id = PORL.requisition_header_id

View Text - HTML Formatted

SELECT PORL.REQUISITION_LINE_ID
, PORL.REQUISITION_HEADER_ID
, PORL.LINE_NUM
, PORL.LINE_TYPE_ID
, PORL.CATEGORY_ID
, PORL.ITEM_DESCRIPTION
, PORL.UNIT_MEAS_LOOKUP_CODE
, PORL.UNIT_PRICE
, PORL.QUANTITY
, PORL.DELIVER_TO_LOCATION_ID
, PORL.TO_PERSON_ID
, PORL.LAST_UPDATE_DATE
, PORL.LAST_UPDATED_BY
, PORL.SOURCE_TYPE_CODE
, PORH.PREPARER_ID
, PORL.LAST_UPDATE_LOGIN
, PORL.CREATION_DATE
, PORL.CREATED_BY
, PORL.ITEM_ID
, PORL.ITEM_REVISION
, PORL.QUANTITY_DELIVERED
, PORL.SUGGESTED_BUYER_ID
, PORL.ENCUMBERED_FLAG
, PORL.RFQ_REQUIRED_FLAG
, PORL.NEED_BY_DATE
, PORL.LINE_LOCATION_ID
, PORL.MODIFIED_BY_AGENT_FLAG
, PORL.PARENT_REQ_LINE_ID
, PORL.JUSTIFICATION
, PORL.NOTE_TO_AGENT
, PORL.NOTE_TO_RECEIVER
, PORL.PURCHASING_AGENT_ID
, PORL.BLANKET_PO_HEADER_ID
, PORL.BLANKET_PO_LINE_NUM
, PORL.SUGGESTED_VENDOR_NAME
, PORL.SUGGESTED_VENDOR_LOCATION
, PORL.SUGGESTED_VENDOR_CONTACT
, PORL.SUGGESTED_VENDOR_PHONE
, PORL.SUGGESTED_VENDOR_PRODUCT_CODE
, PORL.UN_NUMBER_ID
, PORL.HAZARD_CLASS_ID
, PORL.MUST_USE_SUGG_VENDOR_FLAG
, PORL.REFERENCE_NUM
, PORL.ON_RFQ_FLAG
, PORL.URGENT_FLAG
, PORL.CANCEL_FLAG
, PORL.SOURCE_ORGANIZATION_ID
, PORL.SOURCE_SUBINVENTORY
, PORL.DESTINATION_TYPE_CODE
, PORL.DESTINATION_ORGANIZATION_ID
, PORL.DESTINATION_SUBINVENTORY
, PORL.QUANTITY_CANCELLED
, PORL.CANCEL_DATE
, PORL.CANCEL_REASON
, PORL.CLOSED_CODE
, PORL.AGENT_RETURN_NOTE
, PORL.CHANGED_AFTER_RESEARCH_FLAG
, PORL.VENDOR_ID
, PORL.VENDOR_SITE_ID
, PORL.VENDOR_CONTACT_ID
, PORL.RESEARCH_AGENT_ID
, PORL.ON_LINE_FLAG
, PORL.WIP_ENTITY_ID
, PORL.WIP_LINE_ID
, PORL.WIP_REPETITIVE_SCHEDULE_ID
, PORL.WIP_OPERATION_SEQ_NUM
, PORL.WIP_RESOURCE_SEQ_NUM
, PORL.BOM_RESOURCE_ID
, PORL.DESTINATION_CONTEXT
, PORL.INVENTORY_SOURCE_CONTEXT
, PORL.VENDOR_SOURCE_CONTEXT
, PORL.USSGL_TRANSACTION_CODE
, PORL.GOVERNMENT_CONTEXT
, PORL.ATTRIBUTE_CATEGORY
, PORL.ATTRIBUTE1
, PORL.ATTRIBUTE2
, PORL.ATTRIBUTE3
, PORL.ATTRIBUTE4
, PORL.ATTRIBUTE5
, PORL.ATTRIBUTE6
, PORL.ATTRIBUTE7
, PORL.ATTRIBUTE8
, PORL.ATTRIBUTE9
, PORL.ATTRIBUTE10
, PORL.ATTRIBUTE11
, PORL.ATTRIBUTE12
, PORL.ATTRIBUTE13
, PORL.ATTRIBUTE14
, PORL.ATTRIBUTE15
, PORL.ORG_ID
FROM PO_REQUISITION_LINES PORL
, PO_REQUISITION_HEADERS_ALL PORH
WHERE PORH.REQUISITION_HEADER_ID = PORL.REQUISITION_HEADER_ID