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


VIEW: APPS.ICX_PO_REQ_HEADERS_V

Object Details
Object Name: ICX_PO_REQ_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_PO_REQ_HEADERS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[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
INTERFACE_SOURCE_CODE VARCHAR2 (25)

TYPE_LOOKUP_CODE VARCHAR2 (25)

USSGL_TRANSACTION_CODE VARCHAR2 (30)

AGENT_RETURN_FLAG VARCHAR2 (1)

CANCEL_FLAG VARCHAR2 (1)
Cancelled flag
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


CREATION_DATE DATE


LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER


PROGRAM_APPLICATION_ID NUMBER


PROGRAM_ID NUMBER


PROGRAM_UPDATE_DATE DATE


REQUEST_ID NUMBER


REQUISITION_NUM VARCHAR2 (20) Yes
SEGMENT2 VARCHAR2 (20)

SEGMENT3 VARCHAR2 (20)

SEGMENT4 VARCHAR2 (20)

SEGMENT5 VARCHAR2 (20)

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)

ATTRIBUTE_CATEGORY VARCHAR2 (30)

PREPARER_NAME VARCHAR2 (240)

AUTHORIZATION_STATUS_DSP VARCHAR2 (80) Yes
RESERVED_FLAG VARCHAR2 (4000)
Reserved flag
DOCUMENT_TYPE_DSP VARCHAR2 (80) Yes
REQ_HEADER_AMOUNT VARCHAR2 (4000)
Total requisition amount
CURRENCY_CODE VARCHAR2 (15) Yes
CLOSED_CODE_DSP VARCHAR2 (80) Yes Closed status (Yes or No)
ACTION_CODE_DISPLAY VARCHAR2 (3)

CANCEL_DSP VARCHAR2 (80) Yes
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
,      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
,      REQUISITION_NUM
,      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_DSP
,      RESERVED_FLAG
,      DOCUMENT_TYPE_DSP
,      REQ_HEADER_AMOUNT
,      CURRENCY_CODE
,      CLOSED_CODE_DSP
,      ACTION_CODE_DISPLAY
,      CANCEL_DSP
FROM APPS.ICX_PO_REQ_HEADERS_V;

Dependencies

[top of page]

APPS.ICX_PO_REQ_HEADERS_V references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMETERS
PL/SQL PackageFND_CURRENCY - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
PL/SQL PackageFND_PROFILE - show dependent code
ViewGL_SETS_OF_BOOKS
ViewHR_EMPLOYEES
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPO_DOCUMENT_TYPES
ViewPO_LOOKUP_CODES
PL/SQL PackagePO_REQS_INQ_SV - show dependent code
SynonymPO_REQUISITION_HEADERS
PL/SQL PackagePO_REQUISITION_HEADERS_PKG - show dependent code

APPS.ICX_PO_REQ_HEADERS_V is not referenced by any database object