[Home] [Help] [Dependency Information]
Object Name: | AHL_OSP_ORDERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AHL.AHL_OSP_ORDERS_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 |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Pseudo column for the AHL_OSP_ORDERS_B row_id | |
OSP_ORDER_ID | NUMBER | Yes | Unique internal identifier for OSP Order. | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Record version number. | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
OSP_ORDER_NUMBER | NUMBER | Yes | Unique OSP order number. | |
ORDER_TYPE_CODE | VARCHAR2 | (30) | Yes | The Order type Code associated to the OSP Order. |
ORDER_TYPE | VARCHAR2 | (80) | Yes | Order type associated to Order type code. |
SINGLE_INSTANCE_FLAG | VARCHAR2 | (1) | Yes | Single Instance Flag |
SINGLE_INSTANCE_MEANING | VARCHAR2 | (80) | Single Instance Meaning from FND_LOOKUP_VALUES_VL | |
PO_HEADER_ID | NUMBER | FK to PO_HEADERS | ||
PO_NUMBER | VARCHAR2 | (20) | PO Number | |
OE_HEADER_ID | NUMBER | FK to OE_HEADERS | ||
SHIPMENT_NUMBER | NUMBER | Shipment Number | ||
VENDOR_ID | NUMBER | FK to PO_VENDORS | ||
VENDOR | VARCHAR2 | (240) | Vendor Name associated to Vendor ID. | |
VENDOR_SITE_ID | NUMBER | FK to PO_VENDOR_SITES | ||
VENDOR_LOCATION | VARCHAR2 | (15) | Vendor Location assocaited to Vendor Site ID. | |
VENDOR_CONTACT_ID | NUMBER | |||
VENDOR_CONTACT | VARCHAR2 | (108) | ||
CUSTOMER_ID | NUMBER | FK to HZ_PARTIES | ||
CUSTOMER | VARCHAR2 | (360) | Customer | |
ORDER_DATE | DATE | Yes | Order Date | |
CONTRACT_ID | NUMBER | FK to OKC_K_HEADERS_B | ||
CONTRACT_NUMBER | VARCHAR2 | (120) | Contract Number | |
CONTRACT_TERMS | VARCHAR2 | (256) | Contract Terms | |
OPERATING_UNIT_ID | NUMBER | Yes | Operation Organization. | |
PO_SYNCH_FLAG | VARCHAR2 | (1) | OBSOLETE: Po Synch Flag column is not being used any more | |
STATUS_CODE | VARCHAR2 | (30) | Yes | Status Code of OSP order. |
STATUS | VARCHAR2 | (80) | Yes | Status of OSP order. |
PO_BATCH_ID | NUMBER | Unique Batch Number created for PO Interface headers | ||
PO_REQUEST_ID | NUMBER | Concurrent Request ID submission for PDOI. | ||
PO_AGENT_ID | NUMBER | FK to PO_AGENTS. | ||
BUYER | VARCHAR2 | (240) | PO Agent Name | |
PO_REQ_HEADER_ID | NUMBER | FK to PO_REQUISITIONS_HEADERS_ALL | ||
PO_REQ_NUMBER | VARCHAR2 | (20) | Requisition Number | |
SECURITY_GROUP_ID | NUMBER | Security Group Id | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
DESCRIPTION | VARCHAR2 | (2000) | OSP Order Description | |
PO_INTERFACE_HEADER_ID | NUMBER | Po Interface Header Id |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, OSP_ORDER_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, OSP_ORDER_NUMBER
, ORDER_TYPE_CODE
, ORDER_TYPE
, SINGLE_INSTANCE_FLAG
, SINGLE_INSTANCE_MEANING
, PO_HEADER_ID
, PO_NUMBER
, OE_HEADER_ID
, SHIPMENT_NUMBER
, VENDOR_ID
, VENDOR
, VENDOR_SITE_ID
, VENDOR_LOCATION
, VENDOR_CONTACT_ID
, VENDOR_CONTACT
, CUSTOMER_ID
, CUSTOMER
, ORDER_DATE
, CONTRACT_ID
, CONTRACT_NUMBER
, CONTRACT_TERMS
, OPERATING_UNIT_ID
, PO_SYNCH_FLAG
, STATUS_CODE
, STATUS
, PO_BATCH_ID
, PO_REQUEST_ID
, PO_AGENT_ID
, BUYER
, PO_REQ_HEADER_ID
, PO_REQ_NUMBER
, SECURITY_GROUP_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, DESCRIPTION
, PO_INTERFACE_HEADER_ID
FROM APPS.AHL_OSP_ORDERS_V;
APPS.AHL_OSP_ORDERS_V is not referenced by any database object
|
|
|