VIEW: APPS.PO_RELEASES_V

Source

View Text - Preformatted

SELECT POR.ROWID , POR.RELEASE_NUM , POR.PO_RELEASE_ID , POH.SEGMENT1 , POH.TYPE_LOOKUP_CODE , POR.PO_HEADER_ID , POR.RELEASE_TYPE , POR.RELEASE_DATE , POR.REVISION_NUM , POR.REVISED_DATE , POH.REVISION_NUM , PPF.FULL_NAME , POR.AGENT_ID , POV.VENDOR_NAME , POV.VENDOR_ID , PVS.VENDOR_SITE_CODE , PVS.VENDOR_SITE_ID , POH.CURRENCY_CODE , HRL.INVENTORY_ORGANIZATION_ID , HRLT.LOCATION_CODE , POH.SHIP_TO_LOCATION_ID , PO_RELEASES_SV2.GET_RELEASE_STATUS(PO_RELEASE_ID) , PO_RELEASES_SV2.GET_REL_TOTAL(PO_RELEASE_ID) , POR.APPROVED_DATE , POR.APPROVED_FLAG , POR.AUTHORIZATION_STATUS , POR.ACCEPTANCE_DUE_DATE , POR.ACCEPTANCE_REQUIRED_FLAG , POR.FIRM_STATUS_LOOKUP_CODE , POR.CANCEL_DATE , POR.CANCEL_REASON , POR.CANCELLED_BY , POR.CANCEL_FLAG , POR.HOLD_BY , POR.HOLD_DATE , POR.HOLD_REASON , POR.HOLD_FLAG , POR.CLOSED_CODE , POR.FROZEN_FLAG , POR.PRINT_COUNT , POR.PRINTED_DATE , POR.USSGL_TRANSACTION_CODE , POR.GOVERNMENT_CONTEXT , 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 , POR.ATTRIBUTE1 , POR.ATTRIBUTE10 , POR.ATTRIBUTE11 , POR.ATTRIBUTE12 , POR.ATTRIBUTE13 , POR.ATTRIBUTE14 , POR.ATTRIBUTE15 , POR.ATTRIBUTE2 , POR.ATTRIBUTE3 , POR.ATTRIBUTE4 , POR.ATTRIBUTE5 , POR.ATTRIBUTE6 , POR.ATTRIBUTE7 , POR.ATTRIBUTE8 , POR.ATTRIBUTE9 , POR.ATTRIBUTE_CATEGORY , PDTL.type_name , POH.blanket_total_amount , PPF2.full_name , 0 , decode(POH.vendor_contact_id, NULL, NULL, PVC.last_name||', '||PVC.first_name) , POH.comments , POH.note_to_vendor , POH.note_to_receiver , POH.start_date , POH.end_date , APT.name ,POR.EDI_PROCESSED_FLAG ,POR.GLOBAL_ATTRIBUTE_CATEGORY ,POR.GLOBAL_ATTRIBUTE1 ,POR.GLOBAL_ATTRIBUTE2 ,POR.GLOBAL_ATTRIBUTE3 ,POR.GLOBAL_ATTRIBUTE4 ,POR.GLOBAL_ATTRIBUTE5 ,POR.GLOBAL_ATTRIBUTE6 ,POR.GLOBAL_ATTRIBUTE7 ,POR.GLOBAL_ATTRIBUTE8 ,POR.GLOBAL_ATTRIBUTE9 ,POR.GLOBAL_ATTRIBUTE10 ,POR.GLOBAL_ATTRIBUTE11 ,POR.GLOBAL_ATTRIBUTE12 ,POR.GLOBAL_ATTRIBUTE13 ,POR.GLOBAL_ATTRIBUTE14 ,POR.GLOBAL_ATTRIBUTE15 ,POR.GLOBAL_ATTRIBUTE16 ,POR.GLOBAL_ATTRIBUTE17 ,POR.GLOBAL_ATTRIBUTE18 ,POR.GLOBAL_ATTRIBUTE19 ,POR.GLOBAL_ATTRIBUTE20 ,POR.WF_ITEM_TYPE ,POR.WF_ITEM_KEY ,POR.PCARD_ID ,POR.PAY_ON_CODE ,POR.CONSIGNED_CONSUMPTION_FLAG ,POR.SHIPPING_CONTROL ,POR.CHANGE_SUMMARY ,POR.VENDOR_ORDER_NUM ,POH.AMOUNT_LIMIT ,POH.MIN_RELEASE_AMOUNT ,POH.PRICE_UPDATE_TOLERANCE ,POH.AUTHORIZATION_STATUS ,POH.FOB_LOOKUP_CODE ,POH.FREIGHT_TERMS_LOOKUP_CODE ,POR.ORG_ID ,PODB.SECURITY_LEVEL_CODE ,PODB.ACCESS_LEVEL_CODE ,'RELEASE' DOCUMENT_TYPE FROM HR_LOCATIONS_ALL_TL HRLT ,HR_LOCATIONS_ALL HRL ,PO_VENDOR_SITES_ALL PVS ,PER_ALL_PEOPLE_F PPF ,PO_VENDORS POV ,PO_HEADERS_ALL POH ,PO_RELEASES_ALL POR ,PO_DOCUMENT_TYPES_ALL_TL PDTL ,PER_ALL_PEOPLE_F PPF2 ,PO_VENDOR_CONTACTS PVC ,AP_TERMS APT ,PO_DOCUMENT_TYPES_ALL_B PODB WHERE POR.PO_HEADER_ID=POH.PO_HEADER_ID AND POH.VENDOR_ID=POV.VENDOR_ID AND POH.VENDOR_SITE_ID=PVS.VENDOR_SITE_ID AND pvc.vendor_site_id (+)=poh.vendor_site_id AND POR.AGENT_ID=PPF.PERSON_ID AND TRUNC(SYSDATE) BETWEEN PPF.EFFECTIVE_START_DATE AND PPF.EFFECTIVE_END_DATE AND POH.SHIP_TO_LOCATION_ID=HRL.LOCATION_ID AND NVL(HRL.BUSINESS_GROUP_ID(+), NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID,-99))=NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID,-99) AND HRL.LOCATION_ID=HRLT.LOCATION_ID AND HRLT.LANGUAGE=USERENV('LANG') AND PDTL.document_type_code = 'RELEASE' AND PDTL.document_subtype=POR.release_type AND PDTL.ORG_ID=POR.ORG_ID AND PDTL.LANGUAGE=USERENV('LANG') AND PPF2.person_id=POH.agent_id AND trunc(sysdate) between PPF2.effective_start_date and PPF2.effective_end_date AND POH.vendor_contact_id=PVC.vendor_contact_id (+) AND APT.term_id (+)=POH.terms_id AND PODB.DOCUMENT_TYPE_CODE=PDTL.DOCUMENT_TYPE_CODE AND PODB.DOCUMENT_SUBTYPE=PDTL.DOCUMENT_SUBTYPE AND PDTL.ORG_ID=PODB.ORG_ID

View Text - HTML Formatted

SELECT POR.ROWID
, POR.RELEASE_NUM
, POR.PO_RELEASE_ID
, POH.SEGMENT1
, POH.TYPE_LOOKUP_CODE
, POR.PO_HEADER_ID
, POR.RELEASE_TYPE
, POR.RELEASE_DATE
, POR.REVISION_NUM
, POR.REVISED_DATE
, POH.REVISION_NUM
, PPF.FULL_NAME
, POR.AGENT_ID
, POV.VENDOR_NAME
, POV.VENDOR_ID
, PVS.VENDOR_SITE_CODE
, PVS.VENDOR_SITE_ID
, POH.CURRENCY_CODE
, HRL.INVENTORY_ORGANIZATION_ID
, HRLT.LOCATION_CODE
, POH.SHIP_TO_LOCATION_ID
, PO_RELEASES_SV2.GET_RELEASE_STATUS(PO_RELEASE_ID)
, PO_RELEASES_SV2.GET_REL_TOTAL(PO_RELEASE_ID)
, POR.APPROVED_DATE
, POR.APPROVED_FLAG
, POR.AUTHORIZATION_STATUS
, POR.ACCEPTANCE_DUE_DATE
, POR.ACCEPTANCE_REQUIRED_FLAG
, POR.FIRM_STATUS_LOOKUP_CODE
, POR.CANCEL_DATE
, POR.CANCEL_REASON
, POR.CANCELLED_BY
, POR.CANCEL_FLAG
, POR.HOLD_BY
, POR.HOLD_DATE
, POR.HOLD_REASON
, POR.HOLD_FLAG
, POR.CLOSED_CODE
, POR.FROZEN_FLAG
, POR.PRINT_COUNT
, POR.PRINTED_DATE
, POR.USSGL_TRANSACTION_CODE
, POR.GOVERNMENT_CONTEXT
, 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
, POR.ATTRIBUTE1
, POR.ATTRIBUTE10
, POR.ATTRIBUTE11
, POR.ATTRIBUTE12
, POR.ATTRIBUTE13
, POR.ATTRIBUTE14
, POR.ATTRIBUTE15
, POR.ATTRIBUTE2
, POR.ATTRIBUTE3
, POR.ATTRIBUTE4
, POR.ATTRIBUTE5
, POR.ATTRIBUTE6
, POR.ATTRIBUTE7
, POR.ATTRIBUTE8
, POR.ATTRIBUTE9
, POR.ATTRIBUTE_CATEGORY
, PDTL.TYPE_NAME
, POH.BLANKET_TOTAL_AMOUNT
, PPF2.FULL_NAME
, 0
, DECODE(POH.VENDOR_CONTACT_ID
, NULL
, NULL
, PVC.LAST_NAME||'
, '||PVC.FIRST_NAME)
, POH.COMMENTS
, POH.NOTE_TO_VENDOR
, POH.NOTE_TO_RECEIVER
, POH.START_DATE
, POH.END_DATE
, APT.NAME
, POR.EDI_PROCESSED_FLAG
, POR.GLOBAL_ATTRIBUTE_CATEGORY
, POR.GLOBAL_ATTRIBUTE1
, POR.GLOBAL_ATTRIBUTE2
, POR.GLOBAL_ATTRIBUTE3
, POR.GLOBAL_ATTRIBUTE4
, POR.GLOBAL_ATTRIBUTE5
, POR.GLOBAL_ATTRIBUTE6
, POR.GLOBAL_ATTRIBUTE7
, POR.GLOBAL_ATTRIBUTE8
, POR.GLOBAL_ATTRIBUTE9
, POR.GLOBAL_ATTRIBUTE10
, POR.GLOBAL_ATTRIBUTE11
, POR.GLOBAL_ATTRIBUTE12
, POR.GLOBAL_ATTRIBUTE13
, POR.GLOBAL_ATTRIBUTE14
, POR.GLOBAL_ATTRIBUTE15
, POR.GLOBAL_ATTRIBUTE16
, POR.GLOBAL_ATTRIBUTE17
, POR.GLOBAL_ATTRIBUTE18
, POR.GLOBAL_ATTRIBUTE19
, POR.GLOBAL_ATTRIBUTE20
, POR.WF_ITEM_TYPE
, POR.WF_ITEM_KEY
, POR.PCARD_ID
, POR.PAY_ON_CODE
, POR.CONSIGNED_CONSUMPTION_FLAG
, POR.SHIPPING_CONTROL
, POR.CHANGE_SUMMARY
, POR.VENDOR_ORDER_NUM
, POH.AMOUNT_LIMIT
, POH.MIN_RELEASE_AMOUNT
, POH.PRICE_UPDATE_TOLERANCE
, POH.AUTHORIZATION_STATUS
, POH.FOB_LOOKUP_CODE
, POH.FREIGHT_TERMS_LOOKUP_CODE
, POR.ORG_ID
, PODB.SECURITY_LEVEL_CODE
, PODB.ACCESS_LEVEL_CODE
, 'RELEASE' DOCUMENT_TYPE
FROM HR_LOCATIONS_ALL_TL HRLT
, HR_LOCATIONS_ALL HRL
, PO_VENDOR_SITES_ALL PVS
, PER_ALL_PEOPLE_F PPF
, PO_VENDORS POV
, PO_HEADERS_ALL POH
, PO_RELEASES_ALL POR
, PO_DOCUMENT_TYPES_ALL_TL PDTL
, PER_ALL_PEOPLE_F PPF2
, PO_VENDOR_CONTACTS PVC
, AP_TERMS APT
, PO_DOCUMENT_TYPES_ALL_B PODB
WHERE POR.PO_HEADER_ID=POH.PO_HEADER_ID
AND POH.VENDOR_ID=POV.VENDOR_ID
AND POH.VENDOR_SITE_ID=PVS.VENDOR_SITE_ID
AND PVC.VENDOR_SITE_ID (+)=POH.VENDOR_SITE_ID
AND POR.AGENT_ID=PPF.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND POH.SHIP_TO_LOCATION_ID=HRL.LOCATION_ID
AND NVL(HRL.BUSINESS_GROUP_ID(+)
, NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99))=NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99)
AND HRL.LOCATION_ID=HRLT.LOCATION_ID
AND HRLT.LANGUAGE=USERENV('LANG')
AND PDTL.DOCUMENT_TYPE_CODE = 'RELEASE'
AND PDTL.DOCUMENT_SUBTYPE=POR.RELEASE_TYPE
AND PDTL.ORG_ID=POR.ORG_ID
AND PDTL.LANGUAGE=USERENV('LANG')
AND PPF2.PERSON_ID=POH.AGENT_ID
AND TRUNC(SYSDATE) BETWEEN PPF2.EFFECTIVE_START_DATE
AND PPF2.EFFECTIVE_END_DATE
AND POH.VENDOR_CONTACT_ID=PVC.VENDOR_CONTACT_ID (+)
AND APT.TERM_ID (+)=POH.TERMS_ID
AND PODB.DOCUMENT_TYPE_CODE=PDTL.DOCUMENT_TYPE_CODE
AND PODB.DOCUMENT_SUBTYPE=PDTL.DOCUMENT_SUBTYPE
AND PDTL.ORG_ID=PODB.ORG_ID