VIEW: APPS.PO_CLMREQ_LINE_SOL_REFS_V

Source

View Text - Preformatted

SELECT prh.requisition_header_id , prl.requisition_line_id , prh.segment1 requisition_number , nvl(prl.line_num_display, prl.line_num) line_number, ponref.auction_display_number , ponref.auction_header_id , ponref.auction_title, ponref.negotiation_status , ponref.doctype_id, ponref.auction_line_no , ponref.auction_status, ponref.trading_partner_contact_id, ponref.trading_partner_id, ponref.trading_partner_contact_name , ponref.org_id, ponref.po_start_date, ponref.creation_date, ponref.publish_date from po_requisition_headers_clm_v prh, po_requisition_lines_all prl , (SELECT pbr.auction_header_id , pbr.line_number auction_line_no , pbr.requisition_header_id , pbr.requisition_line_id , auch.auction_title, auch.negotiation_status , auch.doctype_id, auch.document_number auction_display_number, auch.auction_status, auch.trading_partner_contact_id, auch.trading_partner_id, auch.trading_partner_contact_name , auch.org_id, auch.po_start_date, auch.creation_date, auch.publish_date from pon_backing_requisitions pbr, pon_auction_headers_all_v auch where pbr.auction_header_id = auch.auction_header_id and nvl(auch.amendment_flag, 'N') = 'N' and auch.revision in (select max(revision) from pon_auction_headers_all_v pah where pah.auction_header_id_orig_amend = auch.auction_header_id_orig_amend) and nvl(auch.auction_round_number, 1) in (select max(nvl(auction_round_number, 1)) from pon_auction_headers_all_v pah where pah.auction_header_id_orig_round = auch.auction_header_id_orig_round ) ) ponref where prh.requisition_header_id = prl.requisition_header_id and prh.conformed_header_id is null and ponref.requisition_header_id = prl.requisition_header_id and ponref.requisition_line_id = prl.requisition_line_id

View Text - HTML Formatted

SELECT PRH.REQUISITION_HEADER_ID
, PRL.REQUISITION_LINE_ID
, PRH.SEGMENT1 REQUISITION_NUMBER
, NVL(PRL.LINE_NUM_DISPLAY
, PRL.LINE_NUM) LINE_NUMBER
, PONREF.AUCTION_DISPLAY_NUMBER
, PONREF.AUCTION_HEADER_ID
, PONREF.AUCTION_TITLE
, PONREF.NEGOTIATION_STATUS
, PONREF.DOCTYPE_ID
, PONREF.AUCTION_LINE_NO
, PONREF.AUCTION_STATUS
, PONREF.TRADING_PARTNER_CONTACT_ID
, PONREF.TRADING_PARTNER_ID
, PONREF.TRADING_PARTNER_CONTACT_NAME
, PONREF.ORG_ID
, PONREF.PO_START_DATE
, PONREF.CREATION_DATE
, PONREF.PUBLISH_DATE
FROM PO_REQUISITION_HEADERS_CLM_V PRH
, PO_REQUISITION_LINES_ALL PRL
, (SELECT PBR.AUCTION_HEADER_ID
, PBR.LINE_NUMBER AUCTION_LINE_NO
, PBR.REQUISITION_HEADER_ID
, PBR.REQUISITION_LINE_ID
, AUCH.AUCTION_TITLE
, AUCH.NEGOTIATION_STATUS
, AUCH.DOCTYPE_ID
, AUCH.DOCUMENT_NUMBER AUCTION_DISPLAY_NUMBER
, AUCH.AUCTION_STATUS
, AUCH.TRADING_PARTNER_CONTACT_ID
, AUCH.TRADING_PARTNER_ID
, AUCH.TRADING_PARTNER_CONTACT_NAME
, AUCH.ORG_ID
, AUCH.PO_START_DATE
, AUCH.CREATION_DATE
, AUCH.PUBLISH_DATE
FROM PON_BACKING_REQUISITIONS PBR
, PON_AUCTION_HEADERS_ALL_V AUCH
WHERE PBR.AUCTION_HEADER_ID = AUCH.AUCTION_HEADER_ID
AND NVL(AUCH.AMENDMENT_FLAG
, 'N') = 'N'
AND AUCH.REVISION IN (SELECT MAX(REVISION)
FROM PON_AUCTION_HEADERS_ALL_V PAH
WHERE PAH.AUCTION_HEADER_ID_ORIG_AMEND = AUCH.AUCTION_HEADER_ID_ORIG_AMEND)
AND NVL(AUCH.AUCTION_ROUND_NUMBER
, 1) IN (SELECT MAX(NVL(AUCTION_ROUND_NUMBER
, 1))
FROM PON_AUCTION_HEADERS_ALL_V PAH
WHERE PAH.AUCTION_HEADER_ID_ORIG_ROUND = AUCH.AUCTION_HEADER_ID_ORIG_ROUND ) ) PONREF
WHERE PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
AND PRH.CONFORMED_HEADER_ID IS NULL
AND PONREF.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
AND PONREF.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID