[Home] [Help] [Dependency Information]
Object Name: | MSC_PO_REQUISITIONS_INTERFACE# |
---|---|
Object Type: | VIEW |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ACCOUNTING_CONTEXT | VARCHAR2 | (30) | ||
PROJECT_ID | NUMBER | |||
TASK_ID | NUMBER | |||
NEED_BY_DATE | DATE | |||
ITEM_ID | NUMBER | |||
ITEM_REVISION | VARCHAR2 | (3) | ||
CHARGE_ACCOUNT_ID | NUMBER | |||
AUTHORIZATION_STATUS | VARCHAR2 | (25) | ||
BATCH_ID | NUMBER | |||
GROUP_CODE | VARCHAR2 | (30) | ||
PREPARER_ID | NUMBER | (9) | ||
AUTOSOURCE_FLAG | VARCHAR2 | (1) | ||
SOURCE_ORGANIZATION_ID | NUMBER | |||
DESTINATION_ORGANIZATION_ID | NUMBER | |||
DELIVER_TO_LOCATION_ID | NUMBER | |||
DELIVER_TO_REQUESTOR_ID | NUMBER | (9) | ||
SUGGESTED_VENDOR_ID | NUMBER | |||
SUGGESTED_VENDOR_SITE_ID | NUMBER | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
INTERFACE_SOURCE_CODE | VARCHAR2 | (25) | ||
SOURCE_TYPE_CODE | VARCHAR2 | (25) | ||
DESTINATION_TYPE_CODE | VARCHAR2 | (25) | ||
QUANTITY | NUMBER | |||
UOM_CODE | VARCHAR2 | (3) | ||
LINE_TYPE_ID | NUMBER | |||
ORG_ID | NUMBER | |||
END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | ||
SR_INSTANCE_ID | NUMBER | |||
SUGGESTED_VENDOR_SITE | VARCHAR2 | (120) | ||
SOURCE_LINE_ID | NUMBER | |||
VMI_FLAG | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ACCOUNTING_CONTEXT
, PROJECT_ID
, TASK_ID
, NEED_BY_DATE
, ITEM_ID
, ITEM_REVISION
, CHARGE_ACCOUNT_ID
, AUTHORIZATION_STATUS
, BATCH_ID
, GROUP_CODE
, PREPARER_ID
, AUTOSOURCE_FLAG
, SOURCE_ORGANIZATION_ID
, DESTINATION_ORGANIZATION_ID
, DELIVER_TO_LOCATION_ID
, DELIVER_TO_REQUESTOR_ID
, SUGGESTED_VENDOR_ID
, SUGGESTED_VENDOR_SITE_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, INTERFACE_SOURCE_CODE
, SOURCE_TYPE_CODE
, DESTINATION_TYPE_CODE
, QUANTITY
, UOM_CODE
, LINE_TYPE_ID
, ORG_ID
, END_ITEM_UNIT_NUMBER
, SR_INSTANCE_ID
, SUGGESTED_VENDOR_SITE
, SOURCE_LINE_ID
, VMI_FLAG
FROM MSC.MSC_PO_REQUISITIONS_INTERFACE#;
|
|
|