VIEW: APPS.POR_VIEW_HEADER_V

Source

View Text - Preformatted

SELECT prh.requisition_header_id, prh.segment1, prh.preparer_id, hre.full_name, prh.description, prh.note_to_authorizer, prh.authorization_status, plc_auth.displayed_field, por_view_reqs_pkg.get_urgent_flag(prh.requisition_header_id), prh.pcard_id, apc.card_number, apc.description, por_view_reqs_pkg.get_note_to_agent(prh.requisition_header_id), to_char(prh.creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')), to_char(por_view_reqs_pkg.get_req_total(prh.requisition_header_id), fnd_currency.safe_get_format_mask(sob.currency_code, 30)), por_view_reqs_pkg.get_requester(prh.requisition_header_id), por_view_reqs_pkg.get_requester(prh.requisition_header_id) || '
' || por_view_reqs_pkg.get_deliver_to(prh.requisition_header_id), prh.emergency_po_num, prh.attribute1, prh.attribute2, prh.attribute3, prh.attribute4, prh.attribute5, prh.attribute6, prh.attribute7, prh.attribute8, prh.attribute9, prh.attribute10, prh.attribute11, prh.attribute12, prh.attribute13, prh.attribute14, prh.attribute15 FROM po_lookup_codes plc_auth, per_all_people_f hre, po_requisition_headers prh, ap_cards apc, gl_sets_of_books sob, financials_system_parameters fsp WHERE sysdate between hre.effective_start_date AND hre.effective_end_date AND prh.preparer_id = hre.person_id AND apc.card_id (+) = prh.pcard_id AND plc_auth.lookup_code = NVL(prh.authorization_status, 'INCOMPLETE') AND plc_auth.lookup_type = 'AUTHORIZATION STATUS' AND sob.set_of_books_id = fsp.set_of_books_id

View Text - HTML Formatted

SELECT PRH.REQUISITION_HEADER_ID
, PRH.SEGMENT1
, PRH.PREPARER_ID
, HRE.FULL_NAME
, PRH.DESCRIPTION
, PRH.NOTE_TO_AUTHORIZER
, PRH.AUTHORIZATION_STATUS
, PLC_AUTH.DISPLAYED_FIELD
, POR_VIEW_REQS_PKG.GET_URGENT_FLAG(PRH.REQUISITION_HEADER_ID)
, PRH.PCARD_ID
, APC.CARD_NUMBER
, APC.DESCRIPTION
, POR_VIEW_REQS_PKG.GET_NOTE_TO_AGENT(PRH.REQUISITION_HEADER_ID)
, TO_CHAR(PRH.CREATION_DATE
, FND_PROFILE.VALUE_WNPS('ICX_DATE_FORMAT_MASK'))
, TO_CHAR(POR_VIEW_REQS_PKG.GET_REQ_TOTAL(PRH.REQUISITION_HEADER_ID)
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(SOB.CURRENCY_CODE
, 30))
, POR_VIEW_REQS_PKG.GET_REQUESTER(PRH.REQUISITION_HEADER_ID)
, POR_VIEW_REQS_PKG.GET_REQUESTER(PRH.REQUISITION_HEADER_ID) || '
' || POR_VIEW_REQS_PKG.GET_DELIVER_TO(PRH.REQUISITION_HEADER_ID)
, PRH.EMERGENCY_PO_NUM
, PRH.ATTRIBUTE1
, PRH.ATTRIBUTE2
, PRH.ATTRIBUTE3
, PRH.ATTRIBUTE4
, PRH.ATTRIBUTE5
, PRH.ATTRIBUTE6
, PRH.ATTRIBUTE7
, PRH.ATTRIBUTE8
, PRH.ATTRIBUTE9
, PRH.ATTRIBUTE10
, PRH.ATTRIBUTE11
, PRH.ATTRIBUTE12
, PRH.ATTRIBUTE13
, PRH.ATTRIBUTE14
, PRH.ATTRIBUTE15
FROM PO_LOOKUP_CODES PLC_AUTH
, PER_ALL_PEOPLE_F HRE
, PO_REQUISITION_HEADERS PRH
, AP_CARDS APC
, GL_SETS_OF_BOOKS SOB
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE SYSDATE BETWEEN HRE.EFFECTIVE_START_DATE
AND HRE.EFFECTIVE_END_DATE
AND PRH.PREPARER_ID = HRE.PERSON_ID
AND APC.CARD_ID (+) = PRH.PCARD_ID
AND PLC_AUTH.LOOKUP_CODE = NVL(PRH.AUTHORIZATION_STATUS
, 'INCOMPLETE')
AND PLC_AUTH.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
AND SOB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID