VIEW: APPS.PO_HEADERS_V

Source

View Text - Preformatted

SELECT POH.ROWID , POH.CREATION_DATE , POH.COMMENTS , POH.ACCEPTANCE_REQUIRED_FLAG , POH.ACCEPTANCE_DUE_DATE , POH.USER_HOLD_FLAG , POH.CANCEL_FLAG , POH.FIRM_STATUS_LOOKUP_CODE , POH.FROZEN_FLAG , POH.ATTRIBUTE1 , POH.ATTRIBUTE2 , POH.ATTRIBUTE3 , POH.ATTRIBUTE5 , POH.ATTRIBUTE7 , POH.ATTRIBUTE8 , POH.ATTRIBUTE10 , POH.ATTRIBUTE11 , POH.ATTRIBUTE13 , POH.ATTRIBUTE14 , POH.AMOUNT_LIMIT , POH.MIN_RELEASE_AMOUNT , POH.QUOTATION_CLASS_CODE , POH.ATTRIBUTE12 , POH.ATTRIBUTE15 , POH.APPROVAL_REQUIRED_FLAG , POH.CLOSED_CODE , POH.SHIP_VIA_LOOKUP_CODE , POH.FREIGHT_TERMS_LOOKUP_CODE , POH.RATE_TYPE , POH.RATE , POH.FROM_TYPE_LOOKUP_CODE , POH.END_DATE , POH.AUTHORIZATION_STATUS , POH.REVISED_DATE , POH.NOTE_TO_AUTHORIZER , POH.NOTE_TO_VENDOR , POH.PRINT_COUNT , POH.VENDOR_ORDER_NUM , POH.REPLY_DATE , POH.LAST_UPDATE_DATE , POH.SEGMENT1 , POH.SEGMENT2 , POH.SEGMENT4 , POH.END_DATE_ACTIVE , POH.CREATED_BY , POH.VENDOR_ID , POH.VENDOR_SITE_ID , POH.ATTRIBUTE6 , POH.ATTRIBUTE9 , POH.VENDOR_CONTACT_ID , POH.SHIP_TO_LOCATION_ID , POH.BILL_TO_LOCATION_ID , POH.TERMS_ID , POH.FOB_LOOKUP_CODE , POH.STATUS_LOOKUP_CODE , POH.CURRENCY_CODE , POH.RATE_DATE , POH.FROM_HEADER_ID , POH.START_DATE , POH.BLANKET_TOTAL_AMOUNT , POH.REVISION_NUM , POH.APPROVED_FLAG , POH.APPROVED_DATE , POH.NOTE_TO_RECEIVER , POH.PRINTED_DATE , POH.CONFIRMING_ORDER_FLAG , POH.REPLY_METHOD_LOOKUP_CODE , POH.PO_HEADER_ID , POH.AGENT_ID , POH.TYPE_LOOKUP_CODE , POH.LAST_UPDATED_BY , POH.SUMMARY_FLAG , POH.ENABLED_FLAG , POH.SEGMENT3 , POH.SEGMENT5 , POH.START_DATE_ACTIVE , POH.LAST_UPDATE_LOGIN , POH.GOVERNMENT_CONTEXT , POH.PROGRAM_APPLICATION_ID , POH.PROGRAM_ID , POH.PROGRAM_UPDATE_DATE , POH.REQUEST_ID , POH.USSGL_TRANSACTION_CODE , POH.CLOSED_DATE , POH.FIRM_DATE , POH.ATTRIBUTE_CATEGORY , POH.ATTRIBUTE4 , POH.RFQ_CLOSE_DATE , POH.QUOTE_TYPE_LOOKUP_CODE , POH.QUOTE_WARNING_DELAY_UNIT , POH.QUOTE_WARNING_DELAY , POH.QUOTE_VENDOR_QUOTE_NUMBER , P.FULL_NAME , PODT.TYPE_NAME , PODB.CAN_PREPARER_APPROVE_FLAG , PODB.SECURITY_LEVEL_CODE , PODB.ACCESS_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 , '('||VS.AREA_CODE||') '||VS.PHONE , '('||VS.FAX_AREA_CODE||') '||VS.FAX , DECODE(POH.VENDOR_CONTACT_ID, NULL, NULL, VC.LAST_NAME||', '|| VC.FIRST_NAME) , AT.NAME , HRL1.LOCATION_CODE , HRL2.LOCATION_CODE , GLDC.USER_CONVERSION_TYPE , POH.CREATION_DATE , PO_HEADERS_SV3.GET_PO_STATUS(POH.PO_HEADER_ID) , POLC2.DISPLAYED_FIELD , POLC3.DISPLAYED_FIELD ,POH.SUPPLY_AGREEMENT_FLAG ,POH.GLOBAL_ATTRIBUTE_CATEGORY ,POH.GLOBAL_ATTRIBUTE1 ,POH.GLOBAL_ATTRIBUTE2 ,POH.GLOBAL_ATTRIBUTE3 ,POH.GLOBAL_ATTRIBUTE4 ,POH.GLOBAL_ATTRIBUTE5 ,POH.GLOBAL_ATTRIBUTE6 ,POH.GLOBAL_ATTRIBUTE7 ,POH.GLOBAL_ATTRIBUTE8 ,POH.GLOBAL_ATTRIBUTE9 ,POH.GLOBAL_ATTRIBUTE10 ,POH.GLOBAL_ATTRIBUTE11 ,POH.GLOBAL_ATTRIBUTE12 ,POH.GLOBAL_ATTRIBUTE13 ,POH.GLOBAL_ATTRIBUTE14 ,POH.GLOBAL_ATTRIBUTE15 ,POH.GLOBAL_ATTRIBUTE16 ,POH.GLOBAL_ATTRIBUTE17 ,POH.GLOBAL_ATTRIBUTE18 ,POH.GLOBAL_ATTRIBUTE19 ,POH.GLOBAL_ATTRIBUTE20 ,POH.WF_ITEM_TYPE ,POH.WF_ITEM_KEY ,POH.PCARD_ID ,POH.PRICE_UPDATE_TOLERANCE ,POH.PAY_ON_CODE ,POLC4.DISPLAYED_FIELD ,POH.GLOBAL_AGREEMENT_FLAG ,POH.CONSIGNED_CONSUMPTION_FLAG ,POH.SHIPPING_CONTROL , POH.CONTERMS_EXIST_FLAG , POH.CONTERMS_ARTICLES_UPD_DATE , POH.CONTERMS_DELIV_UPD_DATE ,POH.PENDING_SIGNATURE_FLAG ,POH.CHANGE_SUMMARY ,POH.ENCUMBRANCE_REQUIRED_FLAG ,POH.ORG_ID ,POH.STYLE_ID ,POH.LOCK_OWNER_ROLE ,POH.LOCK_OWNER_USER_ID ,POH.ENABLE_ALL_SITES FROM PO_DOCUMENT_TYPES_ALL_TL PODT, PO_DOCUMENT_TYPES_ALL_B PODB, PO_LOOKUP_CODES POLC, PO_LOOKUP_CODES POLC2, PO_LOOKUP_CODES POLC3, PO_LOOKUP_CODES POLC4, GL_DAILY_CONVERSION_TYPES GLDC, AP_TERMS AT, PER_PEOPLE_F P, PO_VENDORS V, PO_VENDOR_SITES_ALL VS, PO_VENDOR_CONTACTS VC, HR_LOCATIONS_ALL_TL HRL1, HR_LOCATIONS_ALL_TL HRL2, PO_HEADERS POH, PO_DOC_STYLE_HEADERS PDSH WHERE POH.AGENT_ID = P.PERSON_ID AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE AND P.EFFECTIVE_END_DATE AND ( (PODB.DOCUMENT_TYPE_CODE in ( 'PO','PA') AND PODB.DOCUMENT_SUBTYPE = POH.TYPE_LOOKUP_CODE ) ) 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 VC.Vendor_site_id (+) = poh.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') AND GLDC.CONVERSION_TYPE (+) = POH.RATE_TYPE AND NVL(POH.AUTHORIZATION_STATUS,'INCOMPLETE') = POLC.LOOKUP_CODE(+) AND POLC.LOOKUP_TYPE(+) = 'AUTHORIZATION STATUS' AND POLC2.LOOKUP_CODE (+) = POH.FOB_LOOKUP_CODE AND POLC2.LOOKUP_TYPE (+) = 'FOB' AND POLC3.LOOKUP_CODE (+) = POH.FREIGHT_TERMS_LOOKUP_CODE AND POLC3.LOOKUP_TYPE (+) = 'FREIGHT TERMS' AND POLC4.LOOKUP_CODE (+) = POH.PAY_ON_CODE AND POLC4.LOOKUP_TYPE (+) = 'PAY ON 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 AND PDSH.STYLE_ID = POH.STYLE_ID AND PDSH.STYLE_TYPE ='STANDARD'

View Text - HTML Formatted

SELECT POH.ROWID
, POH.CREATION_DATE
, POH.COMMENTS
, POH.ACCEPTANCE_REQUIRED_FLAG
, POH.ACCEPTANCE_DUE_DATE
, POH.USER_HOLD_FLAG
, POH.CANCEL_FLAG
, POH.FIRM_STATUS_LOOKUP_CODE
, POH.FROZEN_FLAG
, POH.ATTRIBUTE1
, POH.ATTRIBUTE2
, POH.ATTRIBUTE3
, POH.ATTRIBUTE5
, POH.ATTRIBUTE7
, POH.ATTRIBUTE8
, POH.ATTRIBUTE10
, POH.ATTRIBUTE11
, POH.ATTRIBUTE13
, POH.ATTRIBUTE14
, POH.AMOUNT_LIMIT
, POH.MIN_RELEASE_AMOUNT
, POH.QUOTATION_CLASS_CODE
, POH.ATTRIBUTE12
, POH.ATTRIBUTE15
, POH.APPROVAL_REQUIRED_FLAG
, POH.CLOSED_CODE
, POH.SHIP_VIA_LOOKUP_CODE
, POH.FREIGHT_TERMS_LOOKUP_CODE
, POH.RATE_TYPE
, POH.RATE
, POH.FROM_TYPE_LOOKUP_CODE
, POH.END_DATE
, POH.AUTHORIZATION_STATUS
, POH.REVISED_DATE
, POH.NOTE_TO_AUTHORIZER
, POH.NOTE_TO_VENDOR
, POH.PRINT_COUNT
, POH.VENDOR_ORDER_NUM
, POH.REPLY_DATE
, POH.LAST_UPDATE_DATE
, POH.SEGMENT1
, POH.SEGMENT2
, POH.SEGMENT4
, POH.END_DATE_ACTIVE
, POH.CREATED_BY
, POH.VENDOR_ID
, POH.VENDOR_SITE_ID
, POH.ATTRIBUTE6
, POH.ATTRIBUTE9
, POH.VENDOR_CONTACT_ID
, POH.SHIP_TO_LOCATION_ID
, POH.BILL_TO_LOCATION_ID
, POH.TERMS_ID
, POH.FOB_LOOKUP_CODE
, POH.STATUS_LOOKUP_CODE
, POH.CURRENCY_CODE
, POH.RATE_DATE
, POH.FROM_HEADER_ID
, POH.START_DATE
, POH.BLANKET_TOTAL_AMOUNT
, POH.REVISION_NUM
, POH.APPROVED_FLAG
, POH.APPROVED_DATE
, POH.NOTE_TO_RECEIVER
, POH.PRINTED_DATE
, POH.CONFIRMING_ORDER_FLAG
, POH.REPLY_METHOD_LOOKUP_CODE
, POH.PO_HEADER_ID
, POH.AGENT_ID
, POH.TYPE_LOOKUP_CODE
, POH.LAST_UPDATED_BY
, POH.SUMMARY_FLAG
, POH.ENABLED_FLAG
, POH.SEGMENT3
, POH.SEGMENT5
, POH.START_DATE_ACTIVE
, POH.LAST_UPDATE_LOGIN
, POH.GOVERNMENT_CONTEXT
, POH.PROGRAM_APPLICATION_ID
, POH.PROGRAM_ID
, POH.PROGRAM_UPDATE_DATE
, POH.REQUEST_ID
, POH.USSGL_TRANSACTION_CODE
, POH.CLOSED_DATE
, POH.FIRM_DATE
, POH.ATTRIBUTE_CATEGORY
, POH.ATTRIBUTE4
, POH.RFQ_CLOSE_DATE
, POH.QUOTE_TYPE_LOOKUP_CODE
, POH.QUOTE_WARNING_DELAY_UNIT
, POH.QUOTE_WARNING_DELAY
, POH.QUOTE_VENDOR_QUOTE_NUMBER
, P.FULL_NAME
, PODT.TYPE_NAME
, PODB.CAN_PREPARER_APPROVE_FLAG
, PODB.SECURITY_LEVEL_CODE
, PODB.ACCESS_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
, '('||VS.AREA_CODE||') '||VS.PHONE
, '('||VS.FAX_AREA_CODE||') '||VS.FAX
, DECODE(POH.VENDOR_CONTACT_ID
, NULL
, NULL
, VC.LAST_NAME||'
, '|| VC.FIRST_NAME)
, AT.NAME
, HRL1.LOCATION_CODE
, HRL2.LOCATION_CODE
, GLDC.USER_CONVERSION_TYPE
, POH.CREATION_DATE
, PO_HEADERS_SV3.GET_PO_STATUS(POH.PO_HEADER_ID)
, POLC2.DISPLAYED_FIELD
, POLC3.DISPLAYED_FIELD
, POH.SUPPLY_AGREEMENT_FLAG
, POH.GLOBAL_ATTRIBUTE_CATEGORY
, POH.GLOBAL_ATTRIBUTE1
, POH.GLOBAL_ATTRIBUTE2
, POH.GLOBAL_ATTRIBUTE3
, POH.GLOBAL_ATTRIBUTE4
, POH.GLOBAL_ATTRIBUTE5
, POH.GLOBAL_ATTRIBUTE6
, POH.GLOBAL_ATTRIBUTE7
, POH.GLOBAL_ATTRIBUTE8
, POH.GLOBAL_ATTRIBUTE9
, POH.GLOBAL_ATTRIBUTE10
, POH.GLOBAL_ATTRIBUTE11
, POH.GLOBAL_ATTRIBUTE12
, POH.GLOBAL_ATTRIBUTE13
, POH.GLOBAL_ATTRIBUTE14
, POH.GLOBAL_ATTRIBUTE15
, POH.GLOBAL_ATTRIBUTE16
, POH.GLOBAL_ATTRIBUTE17
, POH.GLOBAL_ATTRIBUTE18
, POH.GLOBAL_ATTRIBUTE19
, POH.GLOBAL_ATTRIBUTE20
, POH.WF_ITEM_TYPE
, POH.WF_ITEM_KEY
, POH.PCARD_ID
, POH.PRICE_UPDATE_TOLERANCE
, POH.PAY_ON_CODE
, POLC4.DISPLAYED_FIELD
, POH.GLOBAL_AGREEMENT_FLAG
, POH.CONSIGNED_CONSUMPTION_FLAG
, POH.SHIPPING_CONTROL
, POH.CONTERMS_EXIST_FLAG
, POH.CONTERMS_ARTICLES_UPD_DATE
, POH.CONTERMS_DELIV_UPD_DATE
, POH.PENDING_SIGNATURE_FLAG
, POH.CHANGE_SUMMARY
, POH.ENCUMBRANCE_REQUIRED_FLAG
, POH.ORG_ID
, POH.STYLE_ID
, POH.LOCK_OWNER_ROLE
, POH.LOCK_OWNER_USER_ID
, POH.ENABLE_ALL_SITES
FROM PO_DOCUMENT_TYPES_ALL_TL PODT
, PO_DOCUMENT_TYPES_ALL_B PODB
, PO_LOOKUP_CODES POLC
, PO_LOOKUP_CODES POLC2
, PO_LOOKUP_CODES POLC3
, PO_LOOKUP_CODES POLC4
, GL_DAILY_CONVERSION_TYPES GLDC
, AP_TERMS AT
, PER_PEOPLE_F P
, PO_VENDORS V
, PO_VENDOR_SITES_ALL VS
, PO_VENDOR_CONTACTS VC
, HR_LOCATIONS_ALL_TL HRL1
, HR_LOCATIONS_ALL_TL HRL2
, PO_HEADERS POH
, PO_DOC_STYLE_HEADERS PDSH
WHERE POH.AGENT_ID = P.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND ( (PODB.DOCUMENT_TYPE_CODE IN ( 'PO'
, 'PA')
AND PODB.DOCUMENT_SUBTYPE = POH.TYPE_LOOKUP_CODE ) )
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 VC.VENDOR_SITE_ID (+) = POH.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')
AND GLDC.CONVERSION_TYPE (+) = POH.RATE_TYPE
AND NVL(POH.AUTHORIZATION_STATUS
, 'INCOMPLETE') = POLC.LOOKUP_CODE(+)
AND POLC.LOOKUP_TYPE(+) = 'AUTHORIZATION STATUS'
AND POLC2.LOOKUP_CODE (+) = POH.FOB_LOOKUP_CODE
AND POLC2.LOOKUP_TYPE (+) = 'FOB'
AND POLC3.LOOKUP_CODE (+) = POH.FREIGHT_TERMS_LOOKUP_CODE
AND POLC3.LOOKUP_TYPE (+) = 'FREIGHT TERMS'
AND POLC4.LOOKUP_CODE (+) = POH.PAY_ON_CODE
AND POLC4.LOOKUP_TYPE (+) = 'PAY ON 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
AND PDSH.STYLE_ID = POH.STYLE_ID
AND PDSH.STYLE_TYPE ='STANDARD'