FND Design Data [Home] [Help]

View: PO_HEADERS_INQ_V

Product: PO - Purchasing
Description: - Retrofitted
Implementation/DBA Data: ViewAPPS.PO_HEADERS_INQ_V
View Text

SELECT POH.ROWID
, 'PO'
, POH.CREATION_DATE
, POH.ACCEPTANCE_DUE_DATE
, POH.AMOUNT_LIMIT
, POH.APPROVED_DATE
, NVL (POH.AUTHORIZATION_STATUS
, 'INCOMPLETE')
, POH.BLANKET_TOTAL_AMOUNT
, POH.CLOSED_DATE
, POH.COMMENTS
, POH.END_DATE
, POH.END_DATE_ACTIVE
, POH.FIRM_DATE
, POH.GOVERNMENT_CONTEXT
, POH.MIN_RELEASE_AMOUNT
, POH.NOTE_TO_AUTHORIZER
, POH.NOTE_TO_RECEIVER
, POH.NOTE_TO_VENDOR
, POH.PRINT_COUNT
, POH.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
, POH.REVISED_DATE
, POH.REVISION_NUM
, POH.RFQ_CLOSE_DATE
, POH.START_DATE
, POH.START_DATE_ACTIVE
, POH.VENDOR_ORDER_NUM
, POH.AGENT_ID
, POH.BILL_TO_LOCATION_ID
, POH.FROM_HEADER_ID
, POH.PO_HEADER_ID
, POH.SHIP_TO_LOCATION_ID
, POH.TERMS_ID
, POH.VENDOR_CONTACT_ID
, POH.VENDOR_ID
, POH.VENDOR_SITE_ID
, NVL (POH.CLOSED_CODE
, 'OPEN')
, POH.CURRENCY_CODE
, NVL (POH.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
, POH.USSGL_TRANSACTION_CODE
, POH.ACCEPTANCE_REQUIRED_FLAG
, POH.APPROVAL_REQUIRED_FLAG
, POH.APPROVED_FLAG
, DECODE (POH.CANCEL_FLAG
, 'I'
, NULL
, POH.CANCEL_FLAG)
, POH.CONFIRMING_ORDER_FLAG
, POH.ENABLED_FLAG
, NVL (POH.FROZEN_FLAG
, 'N')
, POH.SUMMARY_FLAG
, NVL (POH.USER_HOLD_FLAG
, 'N')
, POH.CREATED_BY
, POH.CREATION_DATE
, POH.LAST_UPDATED_BY
, POH.LAST_UPDATE_DATE
, POH.LAST_UPDATE_LOGIN
, POH.PROGRAM_APPLICATION_ID
, POH.PROGRAM_ID
, POH.PROGRAM_UPDATE_DATE
, POH.REQUEST_ID
, POH.SEGMENT1
, POH.SEGMENT2
, POH.SEGMENT3
, POH.SEGMENT4
, POH.SEGMENT5
, POH.ATTRIBUTE_CATEGORY
, POH.ATTRIBUTE1
, POH.ATTRIBUTE2
, POH.ATTRIBUTE3
, POH.ATTRIBUTE4
, POH.ATTRIBUTE5
, POH.ATTRIBUTE6
, POH.ATTRIBUTE7
, POH.ATTRIBUTE8
, POH.ATTRIBUTE9
, POH.ATTRIBUTE10
, POH.ATTRIBUTE11
, POH.ATTRIBUTE12
, POH.ATTRIBUTE13
, POH.ATTRIBUTE14
, POH.ATTRIBUTE15
, PDTL.TYPE_NAME
, PDT.CAN_PREPARER_APPROVE_FLAG
, PDT.SECURITY_LEVEL_CODE
, V.VENDOR_NAME
, V.TYPE_1099
, V.VAT_CODE
, 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 ( VC.LAST_NAME
, NULL
, NULL
, VC.LAST_NAME || '
, ' || VC.FIRST_NAME )
, AT.NAME
, HRL1.LOCATION_CODE
, HRL2.LOCATION_CODE
, NULL
, NULL
, NULL
, NULL
, NULL
, TO_DATE (NULL)
, NULL
, TO_NUMBER (NULL)
, TO_NUMBER (NULL)
, TO_DATE (NULL)
, NULL
, TO_NUMBER (NULL)
, NULL
, TO_NUMBER (NULL)
, POH.PCARD_ID
, POH.PRICE_UPDATE_TOLERANCE
, POH.PAY_ON_CODE
, NULL
, POH.GLOBAL_AGREEMENT_FLAG
, POH.ORG_ID
, POH.ORG_ID
, POH.CBC_ACCOUNTING_DATE
, POH.CONSIGNED_CONSUMPTION_FLAG
, POH.SHIPPING_CONTROL
, NULL
, POH.CONTERMS_EXIST_FLAG
, POH.CONTERMS_ARTICLES_UPD_DATE
, POH.CONTERMS_DELIV_UPD_DATE
, POH.CHANGE_SUMMARY
, POH.PENDING_SIGNATURE_FLAG
FROM PO_DOCUMENT_TYPES_ALL_B PDT
, PO_DOCUMENT_TYPES_ALL_TL PDTL
, PO_VENDORS V
, PO_VENDOR_SITES_ALL VS
, PO_VENDOR_CONTACTS VC
, AP_TERMS AT
, HR_LOCATIONS_ALL_TL HRL1
, HR_LOCATIONS_ALL_TL HRL2
, PO_HEADERS_ALL POH
WHERE PDT.DOCUMENT_TYPE_CODE IN ('PO'
, 'PA')
AND PDT.DOCUMENT_SUBTYPE = POH.TYPE_LOOKUP_CODE
AND PDT.DOCUMENT_TYPE_CODE = PDTL.DOCUMENT_TYPE_CODE
AND PDT.DOCUMENT_SUBTYPE = PDTL.DOCUMENT_SUBTYPE
AND PDTL.LANGUAGE = USERENV ('LANG')
AND PDT.ORG_ID = PDTL.ORG_ID
AND PDT.ORG_ID = POH.ORG_ID
AND V.VENDOR_ID(+) = POH.VENDOR_ID
AND VS.VENDOR_SITE_ID(+) = POH.VENDOR_SITE_ID
AND VC.VENDOR_CONTACT_ID(+) = POH.VENDOR_CONTACT_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')
AND ( ( NVL (POH.GLOBAL_AGREEMENT_FLAG
, 'N') = 'Y'
AND (POH.ORG_ID IN (SELECT ORG_ID
FROM PO_SYSTEM_PARAMETERS) ) OR EXISTS ( SELECT ' CURRENT OU IS ROU OR POU'
FROM PO_GA_ORG_ASSIGNMENTS POGA
WHERE POH.PO_HEADER_ID = POGA.PO_HEADER_ID
AND POGA.ENABLED_FLAG = 'Y'
AND ( POGA.ORGANIZATION_ID IN (SELECT ORG_ID
FROM PO_SYSTEM_PARAMETERS) OR POGA.PURCHASING_ORG_ID IN (SELECT ORG_ID
FROM PO_SYSTEM_PARAMETERS)) )
AND POH.AUTHORIZATION_STATUS = 'APPROVED'
AND NVL (POH.CLOSED_CODE
, 'OPEN') <> 'FINALLY CLOSED'
AND NVL (POH.CANCEL_FLAG
, 'N') = 'N'
AND NVL (POH.FROZEN_FLAG
, 'N') = 'N'
AND ( TRUNC (SYSDATE) BETWEEN NVL ( TRUNC (POH.START_DATE)
, TRUNC (SYSDATE) - 1 )
AND NVL ( TRUNC (POH.END_DATE)
, TRUNC (SYSDATE) + 1 ) OR ( TRUNC (POH.START_DATE) IS NOT NULL
AND TRUNC (SYSDATE) <= TRUNC (POH.START_DATE) ) ) ) OR ( NVL (POH.GLOBAL_AGREEMENT_FLAG
, 'N') = 'N'
AND POH.ORG_ID IN (SELECT ORG_ID
FROM PO_SYSTEM_PARAMETERS)) ) UNION ALL 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
, V.VAT_CODE
, 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 ( VC.LAST_NAME
, NULL
, NULL
, VC.LAST_NAME || '
, ' || VC.FIRST_NAME )
, 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.ORG_ID
, POH.ORG_ID
, POH.CBC_ACCOUNTING_DATE
, POR.CONSIGNED_CONSUMPTION_FLAG
, POR.SHIPPING_CONTROL
, NULL
, POH.CONTERMS_EXIST_FLAG
, POH.CONTERMS_ARTICLES_UPD_DATE
, POH.CONTERMS_DELIV_UPD_DATE
, POH.CHANGE_SUMMARY
, NULL
FROM PO_DOCUMENT_TYPES_ALL_B PDT
, PO_DOCUMENT_TYPES_ALL_TL PDTL
, PO_VENDORS V
, PO_VENDOR_SITES_ALL VS
, PO_VENDOR_CONTACTS VC
, 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 PDT.ORG_ID(+) = POR.ORG_ID
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.DOCUMENT_TYPE_CODE = PDTL.DOCUMENT_TYPE_CODE (+)
AND PDT.DOCUMENT_SUBTYPE = PDTL.DOCUMENT_SUBTYPE (+)
AND V.VENDOR_ID(+) = POH.VENDOR_ID
AND VS.VENDOR_SITE_ID(+) = POH.VENDOR_SITE_ID
AND VC.VENDOR_CONTACT_ID(+) = POH.VENDOR_CONTACT_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')

Columns

Name
ROW_ID
PO_RELEASE_FLAG
CREATION_DATE
ACCEPTANCE_DUE_DATE
AMOUNT_LIMIT
APPROVED_DATE
AUTHORIZATION_STATUS
BLANKET_TOTAL_AMOUNT
CLOSED_DATE
COMMENTS
END_DATE
END_DATE_ACTIVE
FIRM_DATE
GOVERNMENT_CONTEXT
MIN_RELEASE_AMOUNT
NOTE_TO_AUTHORIZER
NOTE_TO_RECEIVER
NOTE_TO_VENDOR
PRINT_COUNT
PRINTED_DATE
QUOTE_VENDOR_QUOTE_NUMBER
QUOTE_WARNING_DELAY
QUOTE_WARNING_DELAY_UNIT
RATE
RATE_DATE
RATE_TYPE
REPLY_DATE
REVISED_DATE
REVISION_NUM
RFQ_CLOSE_DATE
START_DATE
START_DATE_ACTIVE
VENDOR_ORDER_NUM
AGENT_ID
BILL_TO_LOCATION_ID
FROM_HEADER_ID
PO_HEADER_ID
SHIP_TO_LOCATION_ID
TERMS_ID
VENDOR_CONTACT_ID
VENDOR_ID
VENDOR_SITE_ID
CLOSED_CODE
CURRENCY_CODE
FIRM_STATUS_LOOKUP_CODE
FOB_LOOKUP_CODE
FREIGHT_TERMS_LOOKUP_CODE
FROM_TYPE_LOOKUP_CODE
QUOTATION_CLASS_CODE
QUOTE_TYPE_LOOKUP_CODE
REPLY_METHOD_LOOKUP_CODE
SHIP_VIA_LOOKUP_CODE
STATUS_LOOKUP_CODE
TYPE_LOOKUP_CODE
USSGL_TRANSACTION_CODE
ACCEPTANCE_REQUIRED_FLAG
APPROVAL_REQUIRED_FLAG
APPROVED_FLAG
CANCEL_FLAG
CONFIRMING_ORDER_FLAG
ENABLED_FLAG
FROZEN_FLAG
SUMMARY_FLAG
USER_HOLD_FLAG
CREATED_BY
ORDER_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
REQUEST_ID
PO_NUM
SEGMENT2
SEGMENT3
SEGMENT4
SEGMENT5
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
DOC_TYPE_NAME
CAN_PREPARER_APPROVE_FLAG
SECURITY_LEVEL_CODE
VENDOR_NAME
TYPE_1099
VAT_CODE
VENDOR_SITE_CODE
ADDRESS_LINE1
ADDRESS_LINE2
ADDRESS_LINE3
CITY
STATE
ZIP
COUNTRY
PHONE
FAX
VENDOR_CONTACT
TERMS_NAME
SHIP_TO_LOCATION
BILL_TO_LOCATION
RATE_CONVERSION_TYPE
AUTHORIZATION_STATUS_DSP
FOB_DSP
FREIGHT_TERMS_DSP
CLOSED_CODE_DSP
CANCEL_DATE
CANCEL_REASON
CANCELLED_BY
HOLD_BY
HOLD_DATE
HOLD_REASON
RELEASE_NUM
RELEASE_TYPE
PO_RELEASE_ID
PCARD_ID
PRICE_UPDATE_TOLERANCE
PAY_ON_CODE
PAY_ON_DSP
GLOBAL_AGREEMENT_FLAG
OWNING_ORG_ID
ORG_ID
CBC_ACCOUNTING_DATE
CONSIGNED_CONSUMPTION_FLAG
SHIPPING_CONTROL
SHIPPING_CONTROL_DSP
CONTERMS_EXIST_FLAG
CONTERMS_ARTICLES_UPD_DATE
CONTERMS_DELIV_UPD_DATE
CHANGE_SUMMARY
PENDING_SIGNATURE_FLAG