VIEW: APPS.PO_HEADERS_INQ_V

Source

View Text - Preformatted

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, 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 ( 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.ENABLE_ALL_SITES , 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, POH.STYLE_ID 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 ( POH.VENDOR_CONTACT_ID IS NULL OR POH.VENDOR_SITE_ID=VC.VENDOR_SITE_ID ) 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, 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 ( 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.ENABLE_ALL_SITES , 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, POH.STYLE_ID 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 ( POH.VENDOR_CONTACT_ID IS NULL OR POH.VENDOR_SITE_ID=VC.VENDOR_SITE_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')

View Text - HTML Formatted

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
, 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 ( 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.ENABLE_ALL_SITES
, 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
, POH.STYLE_ID
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 ( POH.VENDOR_CONTACT_ID IS NULL OR POH.VENDOR_SITE_ID=VC.VENDOR_SITE_ID )
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
, 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 ( 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.ENABLE_ALL_SITES
, 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
, POH.STYLE_ID
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 ( POH.VENDOR_CONTACT_ID IS NULL OR POH.VENDOR_SITE_ID=VC.VENDOR_SITE_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')