DBA Data[Home] [Help] [Dependency Information]


VIEW: PO.PO_RELEASES_ALL#

Object Details
Object Name: PO_RELEASES_ALL#
Object Type: VIEW
Owner: PO
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_RELEASE_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
PO_HEADER_ID NUMBER
Yes
RELEASE_NUM NUMBER
Yes
AGENT_ID NUMBER (9) Yes
RELEASE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

REVISION_NUM NUMBER

REVISED_DATE DATE

APPROVED_FLAG VARCHAR2 (1)
APPROVED_DATE DATE

PRINT_COUNT NUMBER

PRINTED_DATE DATE

ACCEPTANCE_REQUIRED_FLAG VARCHAR2 (1)
ACCEPTANCE_DUE_DATE DATE

HOLD_BY NUMBER (9)
HOLD_DATE DATE

HOLD_REASON VARCHAR2 (240)
HOLD_FLAG VARCHAR2 (1)
CANCEL_FLAG VARCHAR2 (1)
CANCELLED_BY NUMBER (9)
CANCEL_DATE DATE

CANCEL_REASON VARCHAR2 (240)
FIRM_STATUS_LOOKUP_CODE VARCHAR2 (25)
FIRM_DATE DATE

ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
AUTHORIZATION_STATUS VARCHAR2 (25)
USSGL_TRANSACTION_CODE VARCHAR2 (30)
GOVERNMENT_CONTEXT VARCHAR2 (30)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

CLOSED_CODE VARCHAR2 (25)
FROZEN_FLAG VARCHAR2 (1)
RELEASE_TYPE VARCHAR2 (25)
NOTE_TO_VENDOR VARCHAR2 (480)
ORG_ID NUMBER

EDI_PROCESSED_FLAG VARCHAR2 (1)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (150)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
WF_ITEM_TYPE VARCHAR2 (8)
WF_ITEM_KEY VARCHAR2 (240)
PCARD_ID NUMBER (15)
PAY_ON_CODE VARCHAR2 (25)
XML_FLAG VARCHAR2 (3)
XML_SEND_DATE DATE

XML_CHANGE_SEND_DATE DATE

CONSIGNED_CONSUMPTION_FLAG VARCHAR2 (1)
CBC_ACCOUNTING_DATE DATE

CHANGE_REQUESTED_BY VARCHAR2 (20)
SHIPPING_CONTROL VARCHAR2 (30)
CHANGE_SUMMARY VARCHAR2 (2000)
VENDOR_ORDER_NUM VARCHAR2 (25)
DOCUMENT_CREATION_METHOD VARCHAR2 (30)
SUBMIT_DATE DATE

TAX_ATTRIBUTE_UPDATE_CODE VARCHAR2 (15)
COMM_REV_NUM NUMBER

OTM_STATUS_CODE VARCHAR2 (40)
OTM_RECOVERY_FLAG VARCHAR2 (1)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PO_RELEASE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PO_HEADER_ID
,      RELEASE_NUM
,      AGENT_ID
,      RELEASE_DATE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REVISION_NUM
,      REVISED_DATE
,      APPROVED_FLAG
,      APPROVED_DATE
,      PRINT_COUNT
,      PRINTED_DATE
,      ACCEPTANCE_REQUIRED_FLAG
,      ACCEPTANCE_DUE_DATE
,      HOLD_BY
,      HOLD_DATE
,      HOLD_REASON
,      HOLD_FLAG
,      CANCEL_FLAG
,      CANCELLED_BY
,      CANCEL_DATE
,      CANCEL_REASON
,      FIRM_STATUS_LOOKUP_CODE
,      FIRM_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      AUTHORIZATION_STATUS
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CLOSED_CODE
,      FROZEN_FLAG
,      RELEASE_TYPE
,      NOTE_TO_VENDOR
,      ORG_ID
,      EDI_PROCESSED_FLAG
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      PCARD_ID
,      PAY_ON_CODE
,      XML_FLAG
,      XML_SEND_DATE
,      XML_CHANGE_SEND_DATE
,      CONSIGNED_CONSUMPTION_FLAG
,      CBC_ACCOUNTING_DATE
,      CHANGE_REQUESTED_BY
,      SHIPPING_CONTROL
,      CHANGE_SUMMARY
,      VENDOR_ORDER_NUM
,      DOCUMENT_CREATION_METHOD
,      SUBMIT_DATE
,      TAX_ATTRIBUTE_UPDATE_CODE
,      COMM_REV_NUM
,      OTM_STATUS_CODE
,      OTM_RECOVERY_FLAG
FROM PO.PO_RELEASES_ALL#;

Dependencies

[top of page]

PO.PO_RELEASES_ALL# references the following:

SchemaPO
TablePO_RELEASES_ALL
PO.PO_RELEASES_ALL# is referenced by following:

SchemaAPPS
TriggerITG_IP_RELEASES_ALL2_ARU
TriggerITG_IP_RELEASES_ALL_ARU
TriggerJAI_PO_RA_ARIUD_T1
SynonymPO_RELEASES
SynonymPO_RELEASES_ALL