[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ICX_PO_SUPPLIER_AGREEMENTS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  ICX.ICX_PO_SUPPLIER_AGREEMENTS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PO_RELEASE_FLAG | CHAR | (2) | ||
| ACCEPTANCE_DUE_DATE | DATE | |||
| AMOUNT_LIMIT | VARCHAR2 | (4000) | ||
| APPROVED_DATE | DATE | |||
| AUTHORIZATION_STATUS | VARCHAR2 | (25) | ||
| BLANKET_TOTAL_AMOUNT | VARCHAR2 | (4000) | ||
| CLOSED_DATE | DATE | |||
| COMMENTS | VARCHAR2 | (240) | ||
| END_DATE | DATE | |||
| MIN_RELEASE_AMOUNT | VARCHAR2 | (4000) | ||
| 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 | |||
| START_DATE | DATE | |||
| AGENT_ID | NUMBER | (9) | Yes | |
| BILL_TO_LOCATION_ID | NUMBER | |||
| PO_HEADER_ID | NUMBER | Yes | ||
| 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) | ||
| FOB_LOOKUP_CODE | VARCHAR2 | (25) | ||
| FREIGHT_TERMS_LOOKUP_CODE | VARCHAR2 | (25) | ||
| SHIP_VIA_LOOKUP_CODE | VARCHAR2 | (25) | ||
| TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Yes | |
| 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) | Yes | |
| FROZEN_FLAG | VARCHAR2 | (1) | ||
| SUMMARY_FLAG | VARCHAR2 | (1) | Yes | |
| USER_HOLD_FLAG | VARCHAR2 | (1) | ||
| CREATED_BY | NUMBER | |||
| ORDER_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 | |||
| PO_NUM | VARCHAR2 | (20) | Yes | |
| 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) | Yes | |
| 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 | (60) | ||
| STATE | VARCHAR2 | (60) | ||
| 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) | Yes | Authorization status displayed value |
| FOB_DSP | VARCHAR2 | (80) | Type of free-on-board terms for the document | |
| FREIGHT_TERMS_DSP | VARCHAR2 | (80) | Type of freight terms for the document | |
| CLOSED_CODE_DSP | VARCHAR2 | (80) | Yes | Describes the closure status of the document |
| CANCEL_DATE | DATE | |||
| CANCEL_REASON | VARCHAR2 | (0) | ||
| CANCELLED_BY | NUMBER | |||
| CANCELLED_BY_NAME | VARCHAR2 | (0) | ||
| HOLD_BY | NUMBER | |||
| HOLD_DATE | DATE | |||
| HOLD_REASON | VARCHAR2 | (0) | ||
| RELEASE_NUM | NUMBER | |||
| RELEASE_TYPE | VARCHAR2 | (0) | ||
| PO_RELEASE_ID | NUMBER | |||
| AMOUNT | VARCHAR2 | (4000) | Total purchase order amount | |
| SUPPLIER_URL | VARCHAR2 | (150) | Supplier URL | |
| SUPPLIER_ID | NUMBER | |||
| SUPPLIER_SITE_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PO_RELEASE_FLAG
, ACCEPTANCE_DUE_DATE
, AMOUNT_LIMIT
, APPROVED_DATE
, AUTHORIZATION_STATUS
, BLANKET_TOTAL_AMOUNT
, CLOSED_DATE
, COMMENTS
, END_DATE
, MIN_RELEASE_AMOUNT
, NOTE_TO_AUTHORIZER
, NOTE_TO_RECEIVER
, NOTE_TO_VENDOR
, PRINT_COUNT
, PRINTED_DATE
, RATE
, RATE_DATE
, RATE_TYPE
, REVISED_DATE
, REVISION_NUM
, START_DATE
, AGENT_ID
, BILL_TO_LOCATION_ID
, PO_HEADER_ID
, SHIP_TO_LOCATION_ID
, TERMS_ID
, VENDOR_CONTACT_ID
, VENDOR_ID
, VENDOR_SITE_ID
, CLOSED_CODE
, CURRENCY_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
, SUPPLIER_ID
, SUPPLIER_SITE_ID
FROM APPS.ICX_PO_SUPPLIER_AGREEMENTS_V;
APPS
AP_TERMS
FND_CURRENCY
- show dependent code
FND_GLOBAL
- show dependent code
GL_DAILY_CONVERSION_TYPES
HR_GENERAL
- show dependent code
HR_LOCATIONS
PO_DOCUMENT_TYPES
PO_HEADERS
PO_INQ_SV
- show dependent code
PO_LOOKUP_CODES
PO_TOTALS_PO_SV
- show dependent code
PO_VENDORS
PO_VENDOR_CONTACTS
PO_VENDOR_SITES
APPS.ICX_PO_SUPPLIER_AGREEMENTS_V is not referenced by any database object
|
|
|
|