[Home] [Help] [Dependency Information]
Object Name: | WIP_EAM_PO_REQ_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | WIP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | |||
PROCESS_FLAG | VARCHAR2 | (30) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
INTERFACE_SOURCE_CODE | VARCHAR2 | (25) | ||
SOURCE_TYPE_CODE | VARCHAR2 | (25) | ||
REQUISITION_TYPE | VARCHAR2 | (25) | ||
DESTINATION_TYPE_CODE | VARCHAR2 | (25) | ||
ITEM_DESCRIPTION | VARCHAR2 | (240) | ||
QUANTITY | NUMBER | (20) | ||
UNIT_PRICE | NUMBER | (20) | ||
AUTHORIZATION_STATUS | VARCHAR2 | (25) | ||
PREPARER_ID | NUMBER | |||
AUTOSOURCE_FLAG | VARCHAR2 | (1) | ||
SUGGESTED_VENDOR_NAME | VARCHAR2 | (240) | ||
NEED_BY_DATE | DATE | |||
REQ_NUMBER_SEGMENT1 | VARCHAR2 | (20) | ||
RFQ_REQUIRED_FLAG | VARCHAR2 | (1) | ||
NOTE_TO_BUYER | VARCHAR2 | (480) | ||
NOTE_TO_RECEIVER | VARCHAR2 | (480) | ||
ITEM_ID | NUMBER | |||
ITEM_SEGMENT1 | VARCHAR2 | (40) | ||
CHARGE_ACCOUNT_ID | NUMBER | |||
CATEGORY_ID | NUMBER | |||
UNIT_OF_MEASURE | VARCHAR2 | (25) | ||
UOM_CODE | VARCHAR2 | (3) | ||
LINE_TYPE_ID | NUMBER | |||
REFERENCE_NUM | VARCHAR2 | (25) | ||
WIP_ENTITY_ID | NUMBER | |||
WIP_OPERATION_SEQ_NUM | NUMBER | |||
WIP_RESOURCE_SEQ_NUM | NUMBER | |||
SOURCE_ORGANIZATION_ID | NUMBER | |||
SOURCE_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
SOURCE_SUBINVENTORY | VARCHAR2 | (10) | ||
DESTINATION_ORGANIZATION_ID | NUMBER | |||
DESTINATION_ORGANIZATION_CODE | VARCHAR2 | (3) | ||
DESTINATION_SUBINVENTORY | VARCHAR2 | (10) | ||
DELIVER_TO_LOCATION_ID | NUMBER | |||
DELIVER_TO_REQUESTOR_ID | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (10) | ||
PROJECT_ACCOUNTING_CONTEXT | VARCHAR2 | (30) | ||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
SYNCHED_UP | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, PROCESS_FLAG
, CREATION_DATE
, CREATED_BY
, INTERFACE_SOURCE_CODE
, SOURCE_TYPE_CODE
, REQUISITION_TYPE
, DESTINATION_TYPE_CODE
, ITEM_DESCRIPTION
, QUANTITY
, UNIT_PRICE
, AUTHORIZATION_STATUS
, PREPARER_ID
, AUTOSOURCE_FLAG
, SUGGESTED_VENDOR_NAME
, NEED_BY_DATE
, REQ_NUMBER_SEGMENT1
, RFQ_REQUIRED_FLAG
, NOTE_TO_BUYER
, NOTE_TO_RECEIVER
, ITEM_ID
, ITEM_SEGMENT1
, CHARGE_ACCOUNT_ID
, CATEGORY_ID
, UNIT_OF_MEASURE
, UOM_CODE
, LINE_TYPE_ID
, REFERENCE_NUM
, WIP_ENTITY_ID
, WIP_OPERATION_SEQ_NUM
, WIP_RESOURCE_SEQ_NUM
, SOURCE_ORGANIZATION_ID
, SOURCE_ORGANIZATION_CODE
, SOURCE_SUBINVENTORY
, DESTINATION_ORGANIZATION_ID
, DESTINATION_ORGANIZATION_CODE
, DESTINATION_SUBINVENTORY
, DELIVER_TO_LOCATION_ID
, DELIVER_TO_REQUESTOR_ID
, CURRENCY_CODE
, PROJECT_ACCOUNTING_CONTEXT
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, SYNCHED_UP
FROM WIP.WIP_EAM_PO_REQ_INTERFACE#;
|
|
|