VIEW: APPS.POR_HEADER_V

Source

View Text - Preformatted

SELECT prh.requisition_header_id, prh.segment1, prh.preparer_id, hre.full_name, prh.type_lookup_code, plc_doctype.displayed_field, prh.emergency_po_num, prh.description, prh.note_to_authorizer, prh.authorization_status, plc_auth.displayed_field, prh.cancel_flag, plc_cancel.displayed_field, NVL(prh.closed_code,'OPEN'), plc_closed.displayed_field, prh.ussgl_transaction_code, prh.transferred_to_oe_flag, prh.org_id, prh.interface_source_code, prh.interface_source_line_id, prh.wf_item_type, prh.wf_item_key, prh.summary_flag, prh.enabled_flag, prh.start_date_active, prh.end_date_active, 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, prh.pcard_id, apc.card_number, apc.description, prl.urgent_flag, prl.note_to_agent, to_char( prh.last_update_date, 'MM-DD-YYYY HH24:MI:SS'), to_char(prh.creation_date, fnd_profile.value_wnps('ICX_DATE_FORMAT_MASK')) FROM po_lookup_codes plc_auth, po_lookup_codes plc_closed, po_lookup_codes plc_cancel, po_lookup_codes plc_doctype, hr_employees hre, ap_cards apc, po_requisition_headers prh, po_requisition_lines prl WHERE prh.preparer_id = hre.employee_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 plc_closed.lookup_code = NVL(prh.closed_code, 'OPEN') AND plc_closed.lookup_type = 'DOCUMENT STATE' AND plc_cancel.lookup_code = NVL(prh.cancel_flag, 'N') AND plc_cancel.lookup_type = 'YES/NO' AND plc_doctype.lookup_code = prh.type_lookup_code AND plc_doctype.lookup_type = 'REQUISITION TYPE' AND prl.requisition_header_id(+) = prh.requisition_header_id

View Text - HTML Formatted

SELECT PRH.REQUISITION_HEADER_ID
, PRH.SEGMENT1
, PRH.PREPARER_ID
, HRE.FULL_NAME
, PRH.TYPE_LOOKUP_CODE
, PLC_DOCTYPE.DISPLAYED_FIELD
, PRH.EMERGENCY_PO_NUM
, PRH.DESCRIPTION
, PRH.NOTE_TO_AUTHORIZER
, PRH.AUTHORIZATION_STATUS
, PLC_AUTH.DISPLAYED_FIELD
, PRH.CANCEL_FLAG
, PLC_CANCEL.DISPLAYED_FIELD
, NVL(PRH.CLOSED_CODE
, 'OPEN')
, PLC_CLOSED.DISPLAYED_FIELD
, PRH.USSGL_TRANSACTION_CODE
, PRH.TRANSFERRED_TO_OE_FLAG
, PRH.ORG_ID
, PRH.INTERFACE_SOURCE_CODE
, PRH.INTERFACE_SOURCE_LINE_ID
, PRH.WF_ITEM_TYPE
, PRH.WF_ITEM_KEY
, PRH.SUMMARY_FLAG
, PRH.ENABLED_FLAG
, PRH.START_DATE_ACTIVE
, PRH.END_DATE_ACTIVE
, 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
, PRH.PCARD_ID
, APC.CARD_NUMBER
, APC.DESCRIPTION
, PRL.URGENT_FLAG
, PRL.NOTE_TO_AGENT
, TO_CHAR( PRH.LAST_UPDATE_DATE
, 'MM-DD-YYYY HH24:MI:SS')
, TO_CHAR(PRH.CREATION_DATE
, FND_PROFILE.VALUE_WNPS('ICX_DATE_FORMAT_MASK'))
FROM PO_LOOKUP_CODES PLC_AUTH
, PO_LOOKUP_CODES PLC_CLOSED
, PO_LOOKUP_CODES PLC_CANCEL
, PO_LOOKUP_CODES PLC_DOCTYPE
, HR_EMPLOYEES HRE
, AP_CARDS APC
, PO_REQUISITION_HEADERS PRH
, PO_REQUISITION_LINES PRL
WHERE PRH.PREPARER_ID = HRE.EMPLOYEE_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 PLC_CLOSED.LOOKUP_CODE = NVL(PRH.CLOSED_CODE
, 'OPEN')
AND PLC_CLOSED.LOOKUP_TYPE = 'DOCUMENT STATE'
AND PLC_CANCEL.LOOKUP_CODE = NVL(PRH.CANCEL_FLAG
, 'N')
AND PLC_CANCEL.LOOKUP_TYPE = 'YES/NO'
AND PLC_DOCTYPE.LOOKUP_CODE = PRH.TYPE_LOOKUP_CODE
AND PLC_DOCTYPE.LOOKUP_TYPE = 'REQUISITION TYPE'
AND PRL.REQUISITION_HEADER_ID(+) = PRH.REQUISITION_HEADER_ID