[Home] [Help] [Dependency Information]
Object Name: | ICX_PO_REQUISITION_LINES_INQ_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ICX.ICX_PO_REQUISITION_LINES_INQ_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) | ||
REQUISITION_HEADER_ID | NUMBER | |||
REQUISITION_LINE_ID | NUMBER | |||
LINE_NUM | NUMBER | |||
LINE_TYPE | VARCHAR2 | (25) | ||
LINE_TYPE_ID | NUMBER | |||
ITEM_ID | NUMBER | |||
ITEM_REVISION | VARCHAR2 | (3) | ||
CATEGORY_ID | NUMBER | |||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
QUANTITY | NUMBER | |||
QUANTITY_RECEIVED | NUMBER | |||
QUANTITY_DELIVERED | NUMBER | |||
QUANTITY_CANCELLED | NUMBER | |||
UNIT_MEAS_LOOKUP_CODE | VARCHAR2 | (25) | ||
UNIT_PRICE | NUMBER | |||
DISPLAY_UNIT_PRICE | VARCHAR2 | (4000) | ||
NEED_BY_DATE | DATE | |||
NOTE_TO_AGENT | VARCHAR2 | (480) | ||
SUGGESTED_VENDOR_NAME | VARCHAR2 | (240) | ||
SUGGESTED_VENDOR_LOCATION | VARCHAR2 | (240) | ||
SUGGESTED_VENDOR_CONTACT | VARCHAR2 | (80) | ||
SUGGESTED_VENDOR_PHONE | VARCHAR2 | (25) | ||
RFQ_REQUIRED_FLAG | VARCHAR2 | (1) | ||
ON_RFQ_FLAG | VARCHAR2 | (1) | ||
CANCEL_FLAG | VARCHAR2 | (80) | ||
MODIFIED_BY_AGENT_FLAG | VARCHAR2 | (1) | ||
UN_NUMBER | VARCHAR2 | (25) | ||
HAZARD_CLASS | VARCHAR2 | (40) | ||
TRANSACTION_REASON | VARCHAR2 | (80) | ||
REFERENCE_NUM | VARCHAR2 | (25) | ||
URGENT | VARCHAR2 | (1) | ||
JUSTIFICATION | VARCHAR2 | (480) | ||
NOTE_TO_RECEIVER | VARCHAR2 | (480) | ||
ENCUMBERED_FLAG | VARCHAR2 | (1) | ||
DESTINATION_TYPE_CODE | VARCHAR2 | (25) | ||
SOURCE_TYPE_CODE | VARCHAR2 | (25) | ||
DEST_ORGANIZATION | VARCHAR2 | (240) | ||
DELIVER_TO_LOCATION | VARCHAR2 | (60) | ||
DEST_SUBINVENTORY | VARCHAR2 | (10) | ||
SOURCE_ORGANIZATION | VARCHAR2 | (240) | ||
SOURCE_SUBINVENTORY | VARCHAR2 | (10) | ||
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) | ||
OUTSIDE_OP_LINE_TYPE | VARCHAR2 | (1) | ||
DELIVER_TO_LOCATION_ID | NUMBER | |||
TO_PERSON_ID | NUMBER | (9) | ||
REQUESTOR | VARCHAR2 | (4000) | Requester name | |
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
SUGGESTED_VENDOR_PRODUCT_CODE | VARCHAR2 | (25) | ||
UN_NUMBER_ID | NUMBER | |||
HAZARD_CLASS_ID | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (15) | ||
RATE | NUMBER | |||
RATE_TYPE | VARCHAR2 | (30) | ||
RATE_DATE | DATE | |||
CURRENCY_UNIT_PRICE | NUMBER | |||
SUGGESTED_BUYER_ID | NUMBER | (9) | ||
SUGGESTED_BUYER | VARCHAR2 | (4000) | Suggested buyer name | |
CLOSED_CODE | VARCHAR2 | (25) | ||
LINE_LOCATION_ID | NUMBER | |||
ITEM_NUMBER | VARCHAR2 | (40) | ||
ITEM_CATEGORY | VARCHAR2 | (163) | ||
PARENT_REQ_LINE_ID | NUMBER | |||
PURCHASING_AGENT_ID | NUMBER | (9) | ||
DOCUMENT_TYPE_CODE | VARCHAR2 | (25) | ||
BLANKET_PO_HEADER_ID | NUMBER | |||
BLANKET_PO_LINE_NUM | NUMBER | |||
CANCEL_REASON | VARCHAR2 | (240) | ||
CANCEL_DATE | DATE | |||
AGENT_RETURN_NOTE | VARCHAR2 | (480) | ||
CHANGED_AFTER_RESEARCH_FLAG | VARCHAR2 | (1) | ||
VENDOR_ID | NUMBER | |||
VENDOR_SITE_ID | NUMBER | |||
VENDOR_CONTACT_ID | NUMBER | |||
RESEARCH_AGENT_ID | NUMBER | (9) | ||
ON_LINE_FLAG | VARCHAR2 | (1) | ||
DESTINATION_CONTEXT | VARCHAR2 | (30) | ||
INVENTORY_SOURCE_CONTEXT | VARCHAR2 | (30) | ||
VENDOR_SOURCE_CONTEXT | VARCHAR2 | (30) | ||
BOM_RESOURCE_ID | NUMBER | |||
USSGL_TRANSACTION_CODE | VARCHAR2 | (30) | ||
GOVERNMENT_CONTEXT | VARCHAR2 | (30) | ||
CLOSED_REASON | VARCHAR2 | (240) | ||
CLOSED_DATE | DATE | |||
TRANSACTION_REASON_CODE | VARCHAR2 | (25) | ||
SOURCE_REQ_LINE_ID | NUMBER | |||
DEST_ORGANIZATION_ID | NUMBER | |||
SOURCE_ORGANIZATION_ID | NUMBER | |||
PURCHASING_AGENT_NAME_DSP | VARCHAR2 | (4000) | Purchasing agent name | |
ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | ||
RATE_TYPE_DSP | VARCHAR2 | (30) | ||
DESTINATION_TYPE_DSP | VARCHAR2 | (80) | ||
SOURCE_TYPE_DSP | VARCHAR2 | (80) | ||
SOURCE_DOCUMENT_TYPE_DSP | VARCHAR2 | (80) | ||
DESTINATION_CUSTOMER_ID | NUMBER | |||
DESTINATION_ADDRESS_ID | NUMBER | |||
DESTINATION_USE_ID | NUMBER | |||
REQUISITION_NUM | VARCHAR2 | (20) | ||
PREPARER_ID | NUMBER | (9) | ||
PREPARER_NAME | VARCHAR2 | (4000) | Preparer name | |
AUTHORIZATION_STATUS | VARCHAR2 | (25) | ||
AUTHORIZATION_STATUS_DSP | VARCHAR2 | (80) | ||
TYPE_LOOKUP_CODE | VARCHAR2 | (25) | ||
DOCUMENT_TYPE_DSP | VARCHAR2 | (80) | ||
INTERFACE_SOURCE_CODE | VARCHAR2 | (25) | ||
BLANKET_PO_NUM_DSP | VARCHAR2 | (4000) | PO number | |
ORDER_NUM | VARCHAR2 | (4000) | Order number | |
SUPPLIER_ITEM_URL | VARCHAR2 | (240) | ||
SUPPLIER_URL | VARCHAR2 | (150) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, REQUISITION_HEADER_ID
, REQUISITION_LINE_ID
, LINE_NUM
, LINE_TYPE
, LINE_TYPE_ID
, ITEM_ID
, ITEM_REVISION
, CATEGORY_ID
, ITEM_DESCRIPTION
, QUANTITY
, QUANTITY_RECEIVED
, QUANTITY_DELIVERED
, QUANTITY_CANCELLED
, UNIT_MEAS_LOOKUP_CODE
, UNIT_PRICE
, DISPLAY_UNIT_PRICE
, NEED_BY_DATE
, NOTE_TO_AGENT
, SUGGESTED_VENDOR_NAME
, SUGGESTED_VENDOR_LOCATION
, SUGGESTED_VENDOR_CONTACT
, SUGGESTED_VENDOR_PHONE
, RFQ_REQUIRED_FLAG
, ON_RFQ_FLAG
, CANCEL_FLAG
, MODIFIED_BY_AGENT_FLAG
, UN_NUMBER
, HAZARD_CLASS
, TRANSACTION_REASON
, REFERENCE_NUM
, URGENT
, JUSTIFICATION
, NOTE_TO_RECEIVER
, ENCUMBERED_FLAG
, DESTINATION_TYPE_CODE
, SOURCE_TYPE_CODE
, DEST_ORGANIZATION
, DELIVER_TO_LOCATION
, DEST_SUBINVENTORY
, SOURCE_ORGANIZATION
, SOURCE_SUBINVENTORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, OUTSIDE_OP_LINE_TYPE
, DELIVER_TO_LOCATION_ID
, TO_PERSON_ID
, REQUESTOR
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, SUGGESTED_VENDOR_PRODUCT_CODE
, UN_NUMBER_ID
, HAZARD_CLASS_ID
, CURRENCY_CODE
, RATE
, RATE_TYPE
, RATE_DATE
, CURRENCY_UNIT_PRICE
, SUGGESTED_BUYER_ID
, SUGGESTED_BUYER
, CLOSED_CODE
, LINE_LOCATION_ID
, ITEM_NUMBER
, ITEM_CATEGORY
, PARENT_REQ_LINE_ID
, PURCHASING_AGENT_ID
, DOCUMENT_TYPE_CODE
, BLANKET_PO_HEADER_ID
, BLANKET_PO_LINE_NUM
, CANCEL_REASON
, CANCEL_DATE
, AGENT_RETURN_NOTE
, CHANGED_AFTER_RESEARCH_FLAG
, VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_CONTACT_ID
, RESEARCH_AGENT_ID
, ON_LINE_FLAG
, DESTINATION_CONTEXT
, INVENTORY_SOURCE_CONTEXT
, VENDOR_SOURCE_CONTEXT
, BOM_RESOURCE_ID
, USSGL_TRANSACTION_CODE
, GOVERNMENT_CONTEXT
, CLOSED_REASON
, CLOSED_DATE
, TRANSACTION_REASON_CODE
, SOURCE_REQ_LINE_ID
, DEST_ORGANIZATION_ID
, SOURCE_ORGANIZATION_ID
, PURCHASING_AGENT_NAME_DSP
, ORDER_TYPE_LOOKUP_CODE
, RATE_TYPE_DSP
, DESTINATION_TYPE_DSP
, SOURCE_TYPE_DSP
, SOURCE_DOCUMENT_TYPE_DSP
, DESTINATION_CUSTOMER_ID
, DESTINATION_ADDRESS_ID
, DESTINATION_USE_ID
, REQUISITION_NUM
, PREPARER_ID
, PREPARER_NAME
, AUTHORIZATION_STATUS
, AUTHORIZATION_STATUS_DSP
, TYPE_LOOKUP_CODE
, DOCUMENT_TYPE_DSP
, INTERFACE_SOURCE_CODE
, BLANKET_PO_NUM_DSP
, ORDER_NUM
, SUPPLIER_ITEM_URL
, SUPPLIER_URL
FROM APPS.ICX_PO_REQUISITION_LINES_INQ_V;
APPS.ICX_PO_REQUISITION_LINES_INQ_V is not referenced by any database object
|
|
|