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


VIEW: APPS.PO_REQUISITION_HEADERS_V

Object Details
Object Name: PO_REQUISITION_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_REQUISITION_HEADERS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)

AGENT_RETURN_NOTE VARCHAR2 (240)

AUTHORIZATION_STATUS VARCHAR2 (25)

DESCRIPTION VARCHAR2 (240)

END_DATE_ACTIVE DATE


GOVERNMENT_CONTEXT VARCHAR2 (30)

NOTE_TO_AUTHORIZER VARCHAR2 (4000)

PREPARER_FINISHED_DATE DATE


START_DATE_ACTIVE DATE


INTERFACE_SOURCE_LINE_ID NUMBER


PREPARER_ID NUMBER (9) Yes
REQUISITION_HEADER_ID NUMBER
Yes
CLOSED_CODE VARCHAR2 (25)

INTERFACE_SOURCE_CODE VARCHAR2 (25)

TYPE_LOOKUP_CODE VARCHAR2 (25)

USSGL_TRANSACTION_CODE VARCHAR2 (30)

AGENT_RETURN_FLAG VARCHAR2 (1)

CANCEL_FLAG VARCHAR2 (1)

ENABLED_FLAG VARCHAR2 (1) Yes
ON_LINE_FLAG VARCHAR2 (1)

PRELIMINARY_RESEARCH_FLAG VARCHAR2 (1)

PREPARER_FINISHED_FLAG VARCHAR2 (1)

RESEARCH_COMPLETE_FLAG VARCHAR2 (1)

SUMMARY_FLAG VARCHAR2 (1) Yes
TRANSFERRED_TO_OE_FLAG VARCHAR2 (1)

CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
SEGMENT1 VARCHAR2 (20) Yes Key flexfield segment
SEGMENT2 VARCHAR2 (20)
Key flexfield segment
SEGMENT3 VARCHAR2 (20)
Key flexfield segment
SEGMENT4 VARCHAR2 (20)
Key flexfield segment
SEGMENT5 VARCHAR2 (20)
Key flexfield segment
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
PREPARER_NAME VARCHAR2 (240)

AUTHORIZATION_STATUS_DISP VARCHAR2 (80) Yes
DOCUMENT_TYPE_DISPLAY VARCHAR2 (80) Yes
TOTAL NUMBER


CURRENCY_CODE VARCHAR2 (15) Yes
MAX_LINE_NUM_DB NUMBER


WF_ITEM_TYPE VARCHAR2 (8)
Workflow Approval Item Type
WF_ITEM_KEY VARCHAR2 (240)
Workflow Approval Item Key
ORG_ID NUMBER

Organization identifier
Query Text

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


SELECT ROW_ID
,      AGENT_RETURN_NOTE
,      AUTHORIZATION_STATUS
,      DESCRIPTION
,      END_DATE_ACTIVE
,      GOVERNMENT_CONTEXT
,      NOTE_TO_AUTHORIZER
,      PREPARER_FINISHED_DATE
,      START_DATE_ACTIVE
,      INTERFACE_SOURCE_LINE_ID
,      PREPARER_ID
,      REQUISITION_HEADER_ID
,      CLOSED_CODE
,      INTERFACE_SOURCE_CODE
,      TYPE_LOOKUP_CODE
,      USSGL_TRANSACTION_CODE
,      AGENT_RETURN_FLAG
,      CANCEL_FLAG
,      ENABLED_FLAG
,      ON_LINE_FLAG
,      PRELIMINARY_RESEARCH_FLAG
,      PREPARER_FINISHED_FLAG
,      RESEARCH_COMPLETE_FLAG
,      SUMMARY_FLAG
,      TRANSFERRED_TO_OE_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      PREPARER_NAME
,      AUTHORIZATION_STATUS_DISP
,      DOCUMENT_TYPE_DISPLAY
,      TOTAL
,      CURRENCY_CODE
,      MAX_LINE_NUM_DB
,      WF_ITEM_TYPE
,      WF_ITEM_KEY
,      ORG_ID
FROM APPS.PO_REQUISITION_HEADERS_V;

Dependencies

[top of page]

APPS.PO_REQUISITION_HEADERS_V references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
PL/SQL PackageFND_GLOBAL - show dependent code
ViewGL_SETS_OF_BOOKS
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
ViewPER_PEOPLE_F
SynonymPO_DOCUMENT_TYPES_ALL_B
SynonymPO_DOCUMENT_TYPES_ALL_TL
ViewPO_LOOKUP_CODES
SynonymPO_REQUISITION_HEADERS
PL/SQL PackagePO_REQUISITION_HEADERS_PKG - show dependent code
PL/SQL PackagePO_REQ_LINES_SV1 - show dependent code
APPS.PO_REQUISITION_HEADERS_V is referenced by following:

SchemaAPPS
Package BodyAHL_OSP_RCV_PVT - show dependent code
Package BodyJAI_PO_HOOK_PKG - show dependent code
Package BodyJAI_PO_RLA_TRIGGER_PKG - show dependent code