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


VIEW: APPS.ICX_PO_HDR_ARCHIVE_OPEN_V

Object Details
Object Name: ICX_PO_HDR_ARCHIVE_OPEN_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.ICX_PO_HDR_ARCHIVE_OPEN_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
PO_RELEASE_FLAG VARCHAR2 (7)

ACCEPTANCE_DUE_DATE DATE


APPROVED_DATE DATE


AUTHORIZATION_STATUS VARCHAR2 (25)

CLOSED_DATE DATE


COMMENTS VARCHAR2 (240)

FIRM_DATE DATE


NOTE_TO_AUTHORIZER VARCHAR2 (240)

NOTE_TO_RECEIVER VARCHAR2 (480)

NOTE_TO_VENDOR VARCHAR2 (480)

PRINT_COUNT NUMBER


PRINTED_DATE DATE


RATE NUMBER


RATE_DATE DATE


RATE_TYPE VARCHAR2 (30)

REVISED_DATE DATE


REVISION_NUM NUMBER


AGENT_ID NUMBER (9)

BILL_TO_LOCATION_ID NUMBER


FROM_HEADER_ID NUMBER


PO_HEADER_ID NUMBER


SHIP_TO_LOCATION_ID NUMBER


TERMS_ID NUMBER


VENDOR_CONTACT_ID NUMBER


VENDOR_ID NUMBER


VENDOR_SITE_ID NUMBER


CLOSED_CODE VARCHAR2 (25)

CURRENCY_CODE VARCHAR2 (15)

FIRM_STATUS_LOOKUP_CODE VARCHAR2 (30)

FOB_LOOKUP_CODE VARCHAR2 (25)

FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 (25)

SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)

TYPE_LOOKUP_CODE VARCHAR2 (25)

ACCEPTANCE_REQUIRED_FLAG VARCHAR2 (1)

APPROVAL_REQUIRED_FLAG VARCHAR2 (1)

APPROVED_FLAG VARCHAR2 (1)

CANCEL_FLAG VARCHAR2 (1)

CONFIRMING_ORDER_FLAG VARCHAR2 (1)

ENABLED_FLAG VARCHAR2 (1)

FROZEN_FLAG VARCHAR2 (1)

SUMMARY_FLAG VARCHAR2 (1)

USER_HOLD_FLAG VARCHAR2 (1)

CREATED_BY NUMBER


ORDER_DATE DATE


LAST_UPDATED_BY NUMBER


LAST_UPDATE_DATE DATE


LAST_UPDATE_LOGIN NUMBER


PROGRAM_APPLICATION_ID NUMBER


PROGRAM_ID NUMBER


PROGRAM_UPDATE_DATE DATE


REQUEST_ID NUMBER


PO_NUM VARCHAR2 (61)

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)

DOC_TYPE_NAME VARCHAR2 (80)

AGENT_NAME VARCHAR2 (4000)

VENDOR_NAME VARCHAR2 (240)

VENDOR_SITE_CODE VARCHAR2 (15)

ADDRESS_LINE1 VARCHAR2 (240)

ADDRESS_LINE2 VARCHAR2 (240)

ADDRESS_LINE3 VARCHAR2 (240)

CITY VARCHAR2 (25)

STATE VARCHAR2 (150)

ZIP VARCHAR2 (20)

COUNTRY VARCHAR2 (25)

PHONE VARCHAR2 (28)

FAX VARCHAR2 (28)

VENDOR_CONTACT VARCHAR2 (32)

TERMS_NAME VARCHAR2 (50)

SHIP_TO_LOCATION VARCHAR2 (60)

BILL_TO_LOCATION VARCHAR2 (60)

RATE_CONVERSION_TYPE VARCHAR2 (30)

AUTHORIZATION_STATUS_DSP VARCHAR2 (80)

FOB_DSP VARCHAR2 (80)

FREIGHT_TERMS_DSP VARCHAR2 (80)

CLOSED_CODE_DSP VARCHAR2 (80)

CANCEL_DATE DATE


CANCEL_REASON VARCHAR2 (240)

CANCELLED_BY NUMBER


CANCELLED_BY_NAME VARCHAR2 (4000)

HOLD_BY NUMBER


HOLD_DATE DATE


HOLD_REASON VARCHAR2 (240)

RELEASE_NUM NUMBER


RELEASE_TYPE VARCHAR2 (25)

PO_RELEASE_ID NUMBER


AMOUNT VARCHAR2 (4000)

SUPPLIER_URL VARCHAR2 (150)

Query Text

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


SELECT PO_RELEASE_FLAG
,      ACCEPTANCE_DUE_DATE
,      APPROVED_DATE
,      AUTHORIZATION_STATUS
,      CLOSED_DATE
,      COMMENTS
,      FIRM_DATE
,      NOTE_TO_AUTHORIZER
,      NOTE_TO_RECEIVER
,      NOTE_TO_VENDOR
,      PRINT_COUNT
,      PRINTED_DATE
,      RATE
,      RATE_DATE
,      RATE_TYPE
,      REVISED_DATE
,      REVISION_NUM
,      AGENT_ID
,      BILL_TO_LOCATION_ID
,      FROM_HEADER_ID
,      PO_HEADER_ID
,      SHIP_TO_LOCATION_ID
,      TERMS_ID
,      VENDOR_CONTACT_ID
,      VENDOR_ID
,      VENDOR_SITE_ID
,      CLOSED_CODE
,      CURRENCY_CODE
,      FIRM_STATUS_LOOKUP_CODE
,      FOB_LOOKUP_CODE
,      FREIGHT_TERMS_LOOKUP_CODE
,      SHIP_VIA_LOOKUP_CODE
,      TYPE_LOOKUP_CODE
,      ACCEPTANCE_REQUIRED_FLAG
,      APPROVAL_REQUIRED_FLAG
,      APPROVED_FLAG
,      CANCEL_FLAG
,      CONFIRMING_ORDER_FLAG
,      ENABLED_FLAG
,      FROZEN_FLAG
,      SUMMARY_FLAG
,      USER_HOLD_FLAG
,      CREATED_BY
,      ORDER_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      PO_NUM
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DOC_TYPE_NAME
,      AGENT_NAME
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      CITY
,      STATE
,      ZIP
,      COUNTRY
,      PHONE
,      FAX
,      VENDOR_CONTACT
,      TERMS_NAME
,      SHIP_TO_LOCATION
,      BILL_TO_LOCATION
,      RATE_CONVERSION_TYPE
,      AUTHORIZATION_STATUS_DSP
,      FOB_DSP
,      FREIGHT_TERMS_DSP
,      CLOSED_CODE_DSP
,      CANCEL_DATE
,      CANCEL_REASON
,      CANCELLED_BY
,      CANCELLED_BY_NAME
,      HOLD_BY
,      HOLD_DATE
,      HOLD_REASON
,      RELEASE_NUM
,      RELEASE_TYPE
,      PO_RELEASE_ID
,      AMOUNT
,      SUPPLIER_URL
FROM APPS.ICX_PO_HDR_ARCHIVE_OPEN_V;

Dependencies

[top of page]

APPS.ICX_PO_HDR_ARCHIVE_OPEN_V references the following:

SchemaAPPS
SynonymAP_TERMS
PL/SQL PackageFND_CURRENCY - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymGL_DAILY_CONVERSION_TYPES
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
SynonymPO_DOCUMENT_TYPES
SynonymPO_HEADERS_ARCHIVE
PL/SQL PackagePO_INQ_SV - show dependent code
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES_ARCHIVE
PL/SQL PackagePO_TOTALS_PO_SV - show dependent code
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES

APPS.ICX_PO_HDR_ARCHIVE_OPEN_V is not referenced by any database object