VIEW: APPS.PO_HEADERS_INQ_REL_V

Source

View Text - Preformatted

SELECT POR.ROWID , 'RELEASE' , POR.CREATION_DATE , POR.ACCEPTANCE_DUE_DATE , POH.AMOUNT_LIMIT , POR.APPROVED_DATE , NVL(POR.AUTHORIZATION_STATUS, 'INCOMPLETE') , POH.BLANKET_TOTAL_AMOUNT , POH.CLOSED_DATE , POH.COMMENTS , POH.END_DATE , POH.END_DATE_ACTIVE , POR.FIRM_DATE , POR.GOVERNMENT_CONTEXT , POH.MIN_RELEASE_AMOUNT , POH.NOTE_TO_AUTHORIZER , POH.NOTE_TO_RECEIVER , POR.NOTE_TO_VENDOR , POR.PRINT_COUNT , POR.PRINTED_DATE , POH.QUOTE_VENDOR_QUOTE_NUMBER , POH.QUOTE_WARNING_DELAY , POH.QUOTE_WARNING_DELAY_UNIT , POH.RATE , POH.RATE_DATE , POH.RATE_TYPE , POH.REPLY_DATE , POR.REVISED_DATE , POR.REVISION_NUM , POH.RFQ_CLOSE_DATE , POH.START_DATE , POH.START_DATE_ACTIVE , POH.VENDOR_ORDER_NUM , POR.AGENT_ID , POH.BILL_TO_LOCATION_ID , POH.FROM_HEADER_ID , POR.PO_HEADER_ID , POH.SHIP_TO_LOCATION_ID , POH.TERMS_ID , POH.VENDOR_CONTACT_ID , POH.VENDOR_ID , POH.VENDOR_SITE_ID , NVL(POR.CLOSED_CODE, 'OPEN') , POH.CURRENCY_CODE , NVL(POR.FIRM_STATUS_LOOKUP_CODE,'N') , POH.FOB_LOOKUP_CODE , POH.FREIGHT_TERMS_LOOKUP_CODE , POH.FROM_TYPE_LOOKUP_CODE , POH.QUOTATION_CLASS_CODE , POH.QUOTE_TYPE_LOOKUP_CODE , POH.REPLY_METHOD_LOOKUP_CODE , POH.SHIP_VIA_LOOKUP_CODE , POH.STATUS_LOOKUP_CODE , POH.TYPE_LOOKUP_CODE , POR.USSGL_TRANSACTION_CODE , POR.ACCEPTANCE_REQUIRED_FLAG , POH.APPROVAL_REQUIRED_FLAG , POR.APPROVED_FLAG , DECODE (POR.CANCEL_FLAG, 'I', NULL, POR.CANCEL_FLAG) , POH.CONFIRMING_ORDER_FLAG , POH.ENABLED_FLAG , NVL(POR.FROZEN_FLAG, 'N') , POH.SUMMARY_FLAG , NVL(POR.HOLD_FLAG,'N') , POR.CREATED_BY , POR.CREATION_DATE , POR.LAST_UPDATED_BY , POR.LAST_UPDATE_DATE , POR.LAST_UPDATE_LOGIN , POR.PROGRAM_APPLICATION_ID , POR.PROGRAM_ID , POR.PROGRAM_UPDATE_DATE , POR.REQUEST_ID , POH.SEGMENT1 , POH.SEGMENT2 , POH.SEGMENT3 , POH.SEGMENT4 , POH.SEGMENT5 , POR.ATTRIBUTE_CATEGORY , POR.ATTRIBUTE1 , POR.ATTRIBUTE2 , POR.ATTRIBUTE3 , POR.ATTRIBUTE4 , POR.ATTRIBUTE5 , POR.ATTRIBUTE6 , POR.ATTRIBUTE7 , POR.ATTRIBUTE8 , POR.ATTRIBUTE9 , POR.ATTRIBUTE10 , POR.ATTRIBUTE11 , POR.ATTRIBUTE12 , POR.ATTRIBUTE13 , POR.ATTRIBUTE14 , POR.ATTRIBUTE15 , PDTL.TYPE_NAME , PDT.CAN_PREPARER_APPROVE_FLAG , PDT.SECURITY_LEVEL_CODE , V.VENDOR_NAME , V.TYPE_1099 , NULL , VS.VENDOR_SITE_CODE , VS.ADDRESS_LINE1 , VS.ADDRESS_LINE2 , VS.ADDRESS_LINE3 , VS.CITY , VS.STATE , VS.ZIP , VS.COUNTRY , DECODE (VS.PHONE, NULL, NULL, '('||VS.AREA_CODE||') '||VS.PHONE) , DECODE (VS.FAX, NULL, NULL, '('||VS.FAX_AREA_CODE||') '||VS.FAX) , DECODE(SUBSTR(HP.PERSON_LAST_NAME,1,15), NULL, NULL, SUBSTR(HP.PERSON_LAST_NAME,1,15) ||', ' || SUBSTR(HP.PERSON_FIRST_NAME,1,15)) , AT.NAME , HRL1.LOCATION_CODE , HRL2.LOCATION_CODE , NULL , NULL , NULL , NULL , NULL , POR.CANCEL_DATE , POR.CANCEL_REASON , POR.CANCELLED_BY , POR.HOLD_BY , POR.HOLD_DATE , POR.HOLD_REASON , POR.RELEASE_NUM , POR.RELEASE_TYPE , POR.PO_RELEASE_ID , POR.PCARD_ID , TO_NUMBER(NULL) , POR.PAY_ON_CODE , NULL , POH.GLOBAL_AGREEMENT_FLAG ,POH.ENABLE_ALL_SITES , POH.ORG_ID , POH.ORG_ID , POH.CBC_ACCOUNTING_DATE , POR.CONSIGNED_CONSUMPTION_FLAG , POH.CONTERMS_EXIST_FLAG , POH.CONTERMS_ARTICLES_UPD_DATE , POH.CONTERMS_DELIV_UPD_DATE , POR.SHIPPING_CONTROL , NULL , POH.PENDING_SIGNATURE_FLAG , POH.CHANGE_SUMMARY , POH.STYLE_ID FROM PO_DOCUMENT_TYPES_ALL_B PDT, PO_DOCUMENT_TYPES_ALL_TL PDTL, PO_VENDORS V, PO_VENDOR_SITES_ALL VS, AP_SUPPLIER_CONTACTS PVC , HZ_PARTIES HP, AP_TERMS AT, HR_LOCATIONS_ALL_TL HRL1, HR_LOCATIONS_ALL_TL HRL2, PO_RELEASES POR, PO_HEADERS_ALL POH WHERE POH.PO_HEADER_ID = POR.PO_HEADER_ID AND PDTL.DOCUMENT_TYPE_CODE(+)= 'RELEASE' AND PDTL.DOCUMENT_SUBTYPE(+) = POR.RELEASE_TYPE AND PDTL.LANGUAGE(+) = USERENV('LANG') AND PDT.DOCUMENT_TYPE_CODE(+)= 'RELEASE' AND PDT.DOCUMENT_SUBTYPE(+) = POR.RELEASE_TYPE AND PDT.ORG_ID = PDTL.ORG_ID AND PDT.ORG_ID(+) = POR.ORG_ID AND V.VENDOR_ID (+) = POH.VENDOR_ID AND VS.VENDOR_SITE_ID (+) = POH.VENDOR_SITE_ID AND PVC.PER_PARTY_ID = HP.PARTY_ID(+) AND PVC.VENDOR_CONTACT_ID (+) = POH.VENDOR_CONTACT_ID AND (POH.VENDOR_CONTACT_ID IS NULL OR POH.VENDOR_SITE_ID = PVC.VENDOR_SITE_ID) AND AT.TERM_ID (+) = POH.TERMS_ID AND HRL1.LOCATION_ID (+) = POH.SHIP_TO_LOCATION_ID AND HRL1.LANGUAGE (+) = USERENV('LANG') AND HRL2.LOCATION_ID (+) = POH.BILL_TO_LOCATION_ID AND HRL2.LANGUAGE (+) = USERENV('LANG')

View Text - HTML Formatted

SELECT POR.ROWID
, 'RELEASE'
, POR.CREATION_DATE
, POR.ACCEPTANCE_DUE_DATE
, POH.AMOUNT_LIMIT
, POR.APPROVED_DATE
, NVL(POR.AUTHORIZATION_STATUS
, 'INCOMPLETE')
, POH.BLANKET_TOTAL_AMOUNT
, POH.CLOSED_DATE
, POH.COMMENTS
, POH.END_DATE
, POH.END_DATE_ACTIVE
, POR.FIRM_DATE
, POR.GOVERNMENT_CONTEXT
, POH.MIN_RELEASE_AMOUNT
, POH.NOTE_TO_AUTHORIZER
, POH.NOTE_TO_RECEIVER
, POR.NOTE_TO_VENDOR
, POR.PRINT_COUNT
, POR.PRINTED_DATE
, POH.QUOTE_VENDOR_QUOTE_NUMBER
, POH.QUOTE_WARNING_DELAY
, POH.QUOTE_WARNING_DELAY_UNIT
, POH.RATE
, POH.RATE_DATE
, POH.RATE_TYPE
, POH.REPLY_DATE
, POR.REVISED_DATE
, POR.REVISION_NUM
, POH.RFQ_CLOSE_DATE
, POH.START_DATE
, POH.START_DATE_ACTIVE
, POH.VENDOR_ORDER_NUM
, POR.AGENT_ID
, POH.BILL_TO_LOCATION_ID
, POH.FROM_HEADER_ID
, POR.PO_HEADER_ID
, POH.SHIP_TO_LOCATION_ID
, POH.TERMS_ID
, POH.VENDOR_CONTACT_ID
, POH.VENDOR_ID
, POH.VENDOR_SITE_ID
, NVL(POR.CLOSED_CODE
, 'OPEN')
, POH.CURRENCY_CODE
, NVL(POR.FIRM_STATUS_LOOKUP_CODE
, 'N')
, POH.FOB_LOOKUP_CODE
, POH.FREIGHT_TERMS_LOOKUP_CODE
, POH.FROM_TYPE_LOOKUP_CODE
, POH.QUOTATION_CLASS_CODE
, POH.QUOTE_TYPE_LOOKUP_CODE
, POH.REPLY_METHOD_LOOKUP_CODE
, POH.SHIP_VIA_LOOKUP_CODE
, POH.STATUS_LOOKUP_CODE
, POH.TYPE_LOOKUP_CODE
, POR.USSGL_TRANSACTION_CODE
, POR.ACCEPTANCE_REQUIRED_FLAG
, POH.APPROVAL_REQUIRED_FLAG
, POR.APPROVED_FLAG
, DECODE (POR.CANCEL_FLAG
, 'I'
, NULL
, POR.CANCEL_FLAG)
, POH.CONFIRMING_ORDER_FLAG
, POH.ENABLED_FLAG
, NVL(POR.FROZEN_FLAG
, 'N')
, POH.SUMMARY_FLAG
, NVL(POR.HOLD_FLAG
, 'N')
, POR.CREATED_BY
, POR.CREATION_DATE
, POR.LAST_UPDATED_BY
, POR.LAST_UPDATE_DATE
, POR.LAST_UPDATE_LOGIN
, POR.PROGRAM_APPLICATION_ID
, POR.PROGRAM_ID
, POR.PROGRAM_UPDATE_DATE
, POR.REQUEST_ID
, POH.SEGMENT1
, POH.SEGMENT2
, POH.SEGMENT3
, POH.SEGMENT4
, POH.SEGMENT5
, POR.ATTRIBUTE_CATEGORY
, POR.ATTRIBUTE1
, POR.ATTRIBUTE2
, POR.ATTRIBUTE3
, POR.ATTRIBUTE4
, POR.ATTRIBUTE5
, POR.ATTRIBUTE6
, POR.ATTRIBUTE7
, POR.ATTRIBUTE8
, POR.ATTRIBUTE9
, POR.ATTRIBUTE10
, POR.ATTRIBUTE11
, POR.ATTRIBUTE12
, POR.ATTRIBUTE13
, POR.ATTRIBUTE14
, POR.ATTRIBUTE15
, PDTL.TYPE_NAME
, PDT.CAN_PREPARER_APPROVE_FLAG
, PDT.SECURITY_LEVEL_CODE
, V.VENDOR_NAME
, V.TYPE_1099
, NULL
, VS.VENDOR_SITE_CODE
, VS.ADDRESS_LINE1
, VS.ADDRESS_LINE2
, VS.ADDRESS_LINE3
, VS.CITY
, VS.STATE
, VS.ZIP
, VS.COUNTRY
, DECODE (VS.PHONE
, NULL
, NULL
, '('||VS.AREA_CODE||') '||VS.PHONE)
, DECODE (VS.FAX
, NULL
, NULL
, '('||VS.FAX_AREA_CODE||') '||VS.FAX)
, DECODE(SUBSTR(HP.PERSON_LAST_NAME
, 1
, 15)
, NULL
, NULL
, SUBSTR(HP.PERSON_LAST_NAME
, 1
, 15) ||'
, ' || SUBSTR(HP.PERSON_FIRST_NAME
, 1
, 15))
, AT.NAME
, HRL1.LOCATION_CODE
, HRL2.LOCATION_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, POR.CANCEL_DATE
, POR.CANCEL_REASON
, POR.CANCELLED_BY
, POR.HOLD_BY
, POR.HOLD_DATE
, POR.HOLD_REASON
, POR.RELEASE_NUM
, POR.RELEASE_TYPE
, POR.PO_RELEASE_ID
, POR.PCARD_ID
, TO_NUMBER(NULL)
, POR.PAY_ON_CODE
, NULL
, POH.GLOBAL_AGREEMENT_FLAG
, POH.ENABLE_ALL_SITES
, POH.ORG_ID
, POH.ORG_ID
, POH.CBC_ACCOUNTING_DATE
, POR.CONSIGNED_CONSUMPTION_FLAG
, POH.CONTERMS_EXIST_FLAG
, POH.CONTERMS_ARTICLES_UPD_DATE
, POH.CONTERMS_DELIV_UPD_DATE
, POR.SHIPPING_CONTROL
, NULL
, POH.PENDING_SIGNATURE_FLAG
, POH.CHANGE_SUMMARY
, POH.STYLE_ID
FROM PO_DOCUMENT_TYPES_ALL_B PDT
, PO_DOCUMENT_TYPES_ALL_TL PDTL
, PO_VENDORS V
, PO_VENDOR_SITES_ALL VS
, AP_SUPPLIER_CONTACTS PVC
, HZ_PARTIES HP
, AP_TERMS AT
, HR_LOCATIONS_ALL_TL HRL1
, HR_LOCATIONS_ALL_TL HRL2
, PO_RELEASES POR
, PO_HEADERS_ALL POH
WHERE POH.PO_HEADER_ID = POR.PO_HEADER_ID
AND PDTL.DOCUMENT_TYPE_CODE(+)= 'RELEASE'
AND PDTL.DOCUMENT_SUBTYPE(+) = POR.RELEASE_TYPE
AND PDTL.LANGUAGE(+) = USERENV('LANG')
AND PDT.DOCUMENT_TYPE_CODE(+)= 'RELEASE'
AND PDT.DOCUMENT_SUBTYPE(+) = POR.RELEASE_TYPE
AND PDT.ORG_ID = PDTL.ORG_ID
AND PDT.ORG_ID(+) = POR.ORG_ID
AND V.VENDOR_ID (+) = POH.VENDOR_ID
AND VS.VENDOR_SITE_ID (+) = POH.VENDOR_SITE_ID
AND PVC.PER_PARTY_ID = HP.PARTY_ID(+)
AND PVC.VENDOR_CONTACT_ID (+) = POH.VENDOR_CONTACT_ID
AND (POH.VENDOR_CONTACT_ID IS NULL OR POH.VENDOR_SITE_ID = PVC.VENDOR_SITE_ID)
AND AT.TERM_ID (+) = POH.TERMS_ID
AND HRL1.LOCATION_ID (+) = POH.SHIP_TO_LOCATION_ID
AND HRL1.LANGUAGE (+) = USERENV('LANG')
AND HRL2.LOCATION_ID (+) = POH.BILL_TO_LOCATION_ID
AND HRL2.LANGUAGE (+) = USERENV('LANG')