VIEW: APPS.PO_DOCUMENT_HEADERS_VIEW

Source

View Text - Preformatted

SELECT PORH.requisition_header_id ,'REQUISITION' ,decode(PORH.type_lookup_code, 'STANDARD', 'PURCHASE', PORH.type_lookup_code) ,PORH.segment1 ,to_number('0') ,PODT.type_name ,PO_EMPLOYEES_SV.get_emp_name(porh.preparer_id) ,PORH.preparer_id ,PORH.creation_date ,PORH.description ,PORH.note_to_authorizer ,PORH.org_id FROM PO_REQUISITION_HEADERS PORH, PO_DOCUMENT_TYPES_ALL_TL PODT, PO_DOCUMENT_TYPES_ALL_B PODB WHERE PODB.document_type_code = 'REQUISITION' AND PODB.document_subtype = decode(PORH.type_lookup_code, 'STANDARD', 'PURCHASE', PORH.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 = PORH.ORG_ID UNION SELECT POH.po_header_id, decode(POH.type_lookup_code, 'BLANKET', 'PA', 'CONTRACT', 'PA', 'STANDARD', 'PO', 'PLANNED', 'PO', POH.type_lookup_code), POH.type_lookup_code, POH.segment1, nvl(POH.revision_num, 0), PODT.type_name, PO_EMPLOYEES_SV.get_emp_name(poh.agent_id), POH.agent_id, POH.creation_date, POH.comments, POH.note_to_authorizer, POH.org_id FROM PO_DOCUMENT_TYPES_ALL_TL PODT, PO_DOCUMENT_TYPES_ALL_B PODB, PO_HEADERS POH WHERE PODB.document_type_code = decode(POH.type_lookup_code, 'STANDARD', 'PO', 'PLANNED', 'PO', 'BLANKET', 'PA', 'CONTRACT', 'PA', POH.type_lookup_code) AND PODB.document_subtype = POH.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 = POH.ORG_ID UNION SELECT POR.po_release_id, 'RELEASE', POR.release_type, POH.segment1 || '-' || POR.release_num, nvl(POR.revision_num, 0), PODT.type_name, PO_EMPLOYEES_SV.get_emp_name(por.agent_id), POR.agent_id, POR.creation_date, POH.comments, POH.note_to_authorizer, POR.org_id FROM PO_DOCUMENT_TYPES_ALL_TL PODT, PO_DOCUMENT_TYPES_ALL_B PODB, PO_HEADERS_ALL POH, PO_RELEASES POR WHERE POH.po_header_id = POR.po_header_id AND PODB.document_type_code = 'RELEASE' AND PODB.document_subtype = POR.release_type 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 = POR.ORG_ID

View Text - HTML Formatted

SELECT PORH.REQUISITION_HEADER_ID
, 'REQUISITION'
, DECODE(PORH.TYPE_LOOKUP_CODE
, 'STANDARD'
, 'PURCHASE'
, PORH.TYPE_LOOKUP_CODE)
, PORH.SEGMENT1
, TO_NUMBER('0')
, PODT.TYPE_NAME
, PO_EMPLOYEES_SV.GET_EMP_NAME(PORH.PREPARER_ID)
, PORH.PREPARER_ID
, PORH.CREATION_DATE
, PORH.DESCRIPTION
, PORH.NOTE_TO_AUTHORIZER
, PORH.ORG_ID
FROM PO_REQUISITION_HEADERS PORH
, PO_DOCUMENT_TYPES_ALL_TL PODT
, PO_DOCUMENT_TYPES_ALL_B PODB
WHERE PODB.DOCUMENT_TYPE_CODE = 'REQUISITION'
AND PODB.DOCUMENT_SUBTYPE = DECODE(PORH.TYPE_LOOKUP_CODE
, 'STANDARD'
, 'PURCHASE'
, PORH.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 = PORH.ORG_ID UNION SELECT POH.PO_HEADER_ID
, DECODE(POH.TYPE_LOOKUP_CODE
, 'BLANKET'
, 'PA'
, 'CONTRACT'
, 'PA'
, 'STANDARD'
, 'PO'
, 'PLANNED'
, 'PO'
, POH.TYPE_LOOKUP_CODE)
, POH.TYPE_LOOKUP_CODE
, POH.SEGMENT1
, NVL(POH.REVISION_NUM
, 0)
, PODT.TYPE_NAME
, PO_EMPLOYEES_SV.GET_EMP_NAME(POH.AGENT_ID)
, POH.AGENT_ID
, POH.CREATION_DATE
, POH.COMMENTS
, POH.NOTE_TO_AUTHORIZER
, POH.ORG_ID
FROM PO_DOCUMENT_TYPES_ALL_TL PODT
, PO_DOCUMENT_TYPES_ALL_B PODB
, PO_HEADERS POH
WHERE PODB.DOCUMENT_TYPE_CODE = DECODE(POH.TYPE_LOOKUP_CODE
, 'STANDARD'
, 'PO'
, 'PLANNED'
, 'PO'
, 'BLANKET'
, 'PA'
, 'CONTRACT'
, 'PA'
, POH.TYPE_LOOKUP_CODE)
AND PODB.DOCUMENT_SUBTYPE = POH.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 = POH.ORG_ID UNION SELECT POR.PO_RELEASE_ID
, 'RELEASE'
, POR.RELEASE_TYPE
, POH.SEGMENT1 || '-' || POR.RELEASE_NUM
, NVL(POR.REVISION_NUM
, 0)
, PODT.TYPE_NAME
, PO_EMPLOYEES_SV.GET_EMP_NAME(POR.AGENT_ID)
, POR.AGENT_ID
, POR.CREATION_DATE
, POH.COMMENTS
, POH.NOTE_TO_AUTHORIZER
, POR.ORG_ID
FROM PO_DOCUMENT_TYPES_ALL_TL PODT
, PO_DOCUMENT_TYPES_ALL_B PODB
, PO_HEADERS_ALL POH
, PO_RELEASES POR
WHERE POH.PO_HEADER_ID = POR.PO_HEADER_ID
AND PODB.DOCUMENT_TYPE_CODE = 'RELEASE'
AND PODB.DOCUMENT_SUBTYPE = POR.RELEASE_TYPE
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 = POR.ORG_ID