VIEW: APPS.PO_REQUISITION_HEADERS_V

Source

View Text - Preformatted

SELECT PRH.ROWID , PRH.AGENT_RETURN_NOTE , PRH.AUTHORIZATION_STATUS , PRH.DESCRIPTION , PRH.END_DATE_ACTIVE , PRH.GOVERNMENT_CONTEXT , PRH.NOTE_TO_AUTHORIZER , PRH.PREPARER_FINISHED_DATE , PRH.START_DATE_ACTIVE , PRH.INTERFACE_SOURCE_LINE_ID , PRH.PREPARER_ID , PRH.REQUISITION_HEADER_ID , PRH.CLOSED_CODE , PRH.INTERFACE_SOURCE_CODE , PRH.TYPE_LOOKUP_CODE , PRH.USSGL_TRANSACTION_CODE , PRH.AGENT_RETURN_FLAG , PRH.CANCEL_FLAG , PRH.ENABLED_FLAG , PRH.ON_LINE_FLAG , PRH.PRELIMINARY_RESEARCH_FLAG , PRH.PREPARER_FINISHED_FLAG , PRH.RESEARCH_COMPLETE_FLAG , PRH.SUMMARY_FLAG , PRH.TRANSFERRED_TO_OE_FLAG , PRH.CREATED_BY , PRH.CREATION_DATE , PRH.LAST_UPDATED_BY , PRH.LAST_UPDATE_DATE , PRH.LAST_UPDATE_LOGIN , PRH.PROGRAM_APPLICATION_ID , PRH.PROGRAM_ID , PRH.PROGRAM_UPDATE_DATE , PRH.REQUEST_ID , PRH.SEGMENT1 , PRH.SEGMENT2 , PRH.SEGMENT3 , PRH.SEGMENT4 , PRH.SEGMENT5 , 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.ATTRIBUTE_CATEGORY , PAPF.FULL_NAME , PLC1.DISPLAYED_FIELD , PODT.TYPE_NAME , PO_REQUISITION_HEADERS_PKG.GET_REQ_TOTAL(REQUISITION_HEADER_ID,CURRENCY_CODE) , SOB.CURRENCY_CODE , PO_REQ_LINES_SV1.GET_MAX_LINE_NUM(REQUISITION_HEADER_ID) , PRH.WF_ITEM_TYPE , PRH.WF_ITEM_KEY ,PRH.ORG_ID FROM PO_LOOKUP_CODES PLC1 ,PO_DOCUMENT_TYPES_ALL_TL PODT ,PO_DOCUMENT_TYPES_ALL_B PODB ,GL_SETS_OF_BOOKS SOB ,FINANCIALS_SYSTEM_PARAMS_ALL FSP ,PER_PEOPLE_F PAPF ,PO_REQUISITION_HEADERS PRH WHERE PRH.PREPARER_ID = PAPF.PERSON_ID AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE AND PLC1.LOOKUP_CODE = NVL(PRH.AUTHORIZATION_STATUS,'INCOMPLETE') AND PLC1.LOOKUP_TYPE = 'AUTHORIZATION STATUS' AND PODB.DOCUMENT_TYPE_CODE = 'REQUISITION' AND PODB.DOCUMENT_SUBTYPE = PRH.TYPE_LOOKUP_CODE AND PODB.DOCUMENT_TYPE_CODE = PODT.DOCUMENT_TYPE_CODE AND PODB.DOCUMENT_SUBTYPE = PODT.DOCUMENT_SUBTYPE AND PODT.LANGUAGE = USERENV('LANG') AND PODT.ORG_ID = PODB.ORG_ID AND PODB.ORG_ID = PRH.ORG_ID AND SOB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND FSP.ORG_ID = PRH.ORG_ID AND NVL( PRH.CONTRACTOR_REQUISITION_FLAG,'N') = 'N'

View Text - HTML Formatted

SELECT PRH.ROWID
, PRH.AGENT_RETURN_NOTE
, PRH.AUTHORIZATION_STATUS
, PRH.DESCRIPTION
, PRH.END_DATE_ACTIVE
, PRH.GOVERNMENT_CONTEXT
, PRH.NOTE_TO_AUTHORIZER
, PRH.PREPARER_FINISHED_DATE
, PRH.START_DATE_ACTIVE
, PRH.INTERFACE_SOURCE_LINE_ID
, PRH.PREPARER_ID
, PRH.REQUISITION_HEADER_ID
, PRH.CLOSED_CODE
, PRH.INTERFACE_SOURCE_CODE
, PRH.TYPE_LOOKUP_CODE
, PRH.USSGL_TRANSACTION_CODE
, PRH.AGENT_RETURN_FLAG
, PRH.CANCEL_FLAG
, PRH.ENABLED_FLAG
, PRH.ON_LINE_FLAG
, PRH.PRELIMINARY_RESEARCH_FLAG
, PRH.PREPARER_FINISHED_FLAG
, PRH.RESEARCH_COMPLETE_FLAG
, PRH.SUMMARY_FLAG
, PRH.TRANSFERRED_TO_OE_FLAG
, PRH.CREATED_BY
, PRH.CREATION_DATE
, PRH.LAST_UPDATED_BY
, PRH.LAST_UPDATE_DATE
, PRH.LAST_UPDATE_LOGIN
, PRH.PROGRAM_APPLICATION_ID
, PRH.PROGRAM_ID
, PRH.PROGRAM_UPDATE_DATE
, PRH.REQUEST_ID
, PRH.SEGMENT1
, PRH.SEGMENT2
, PRH.SEGMENT3
, PRH.SEGMENT4
, PRH.SEGMENT5
, 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.ATTRIBUTE_CATEGORY
, PAPF.FULL_NAME
, PLC1.DISPLAYED_FIELD
, PODT.TYPE_NAME
, PO_REQUISITION_HEADERS_PKG.GET_REQ_TOTAL(REQUISITION_HEADER_ID
, CURRENCY_CODE)
, SOB.CURRENCY_CODE
, PO_REQ_LINES_SV1.GET_MAX_LINE_NUM(REQUISITION_HEADER_ID)
, PRH.WF_ITEM_TYPE
, PRH.WF_ITEM_KEY
, PRH.ORG_ID
FROM PO_LOOKUP_CODES PLC1
, PO_DOCUMENT_TYPES_ALL_TL PODT
, PO_DOCUMENT_TYPES_ALL_B PODB
, GL_SETS_OF_BOOKS SOB
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, PER_PEOPLE_F PAPF
, PO_REQUISITION_HEADERS PRH
WHERE PRH.PREPARER_ID = PAPF.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE
AND PAPF.EFFECTIVE_END_DATE
AND PLC1.LOOKUP_CODE = NVL(PRH.AUTHORIZATION_STATUS
, 'INCOMPLETE')
AND PLC1.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
AND PODB.DOCUMENT_TYPE_CODE = 'REQUISITION'
AND PODB.DOCUMENT_SUBTYPE = PRH.TYPE_LOOKUP_CODE
AND PODB.DOCUMENT_TYPE_CODE = PODT.DOCUMENT_TYPE_CODE
AND PODB.DOCUMENT_SUBTYPE = PODT.DOCUMENT_SUBTYPE
AND PODT.LANGUAGE = USERENV('LANG')
AND PODT.ORG_ID = PODB.ORG_ID
AND PODB.ORG_ID = PRH.ORG_ID
AND SOB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID
AND FSP.ORG_ID = PRH.ORG_ID
AND NVL( PRH.CONTRACTOR_REQUISITION_FLAG
, 'N') = 'N'