[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_PO_REQUISITIONS_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.MSC_PO_REQUISITIONS_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
MSC_PO_REQUISITIONS_INTERFACE contains requisition information from
ORACLE MSC application. Each row includes all the information necessary to
create approved or unapproved requisitions in Oracle Purchasing. The
Oracle Purchasing Requisition Import feature uses this information to
create new requisition headers, lines and distributions.
You use the Submit Request window to launch the Requisition Import
program for any set of rows. You identify the set of rows you want to import
by setting the INTERFACE_SOURCE_CODE and BATCH_ID columns appropriately
in the interface table.
The Requisition Import program validates your data, derives or
defaults additional information and writes an error message for every
validation that fails into the PO_INTERFACE_ERRORS table. Then the
program groups and numbers requisition lines according to the criteria
you specify in the GROUP_CODE and REQ_NUMBER_SEGMENT1 columns, and
creates new requisitions.
Most of the columns in the PO_REQUISITIONS_INTERFACE_ALL table are
identical to the corresponding columns in
the PO_REQUISITIONS_HEADERS_ALL, PO_REQUISITION_LINES_ALL and
PO_REQ_DISTRIBUTIONS_ALL tables. You can additionally enter reference
information in the INTERFACE_SOURCE_LINE_ID column.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT_ACCOUNTING_CONTEXT | VARCHAR2 | (30) | Project accouting descriptive flexfield context column | |
| PROJECT_ID | NUMBER | Project identifier | ||
| TASK_ID | NUMBER | Task identifier | ||
| NEED_BY_DATE | DATE | Date the requisition is needed internally | ||
| ITEM_ID | NUMBER | Item identifier | ||
| ITEM_REVISION | VARCHAR2 | (3) | Item name | |
| CHARGE_ACCOUNT_ID | NUMBER | Charge account identifier | ||
| AUTHORIZATION_STATUS | VARCHAR2 | (25) | Authorization status type | |
| BATCH_ID | NUMBER | Import batch identifier | ||
| GROUP_CODE | VARCHAR2 | (30) | Import group code | |
| PREPARER_ID | NUMBER | (9) | Preparer identifier | |
| AUTOSOURCE_FLAG | VARCHAR2 | (1) | Flag indicates whether autosourcing | |
| SOURCE_ORGANIZATION_ID | NUMBER | Source organization identifier | ||
| DESTINATION_ORGANIZATION_ID | NUMBER | Destination organization identifier | ||
| DELIVER_TO_LOCATION_ID | NUMBER | Deliver-to-location unique identifier | ||
| DELIVER_TO_REQUESTOR_ID | NUMBER | (9) | Requestor unique identifier | |
| SUGGESTED_VENDOR_ID | NUMBER | Suggested supplier unique identifier | ||
| SUGGESTED_VENDOR_SITE_ID | NUMBER | Suggested supplier site unique identifier | ||
| LAST_UPDATED_BY | NUMBER | Standard Who Column | ||
| LAST_UPDATE_DATE | DATE | Standard Who Column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who Column | ||
| CREATION_DATE | DATE | Standard Who Column | ||
| CREATED_BY | NUMBER | Standard Who Column | ||
| INTERFACE_SOURCE_CODE | VARCHAR2 | (25) | Interface transaction source | |
| SOURCE_TYPE_CODE | VARCHAR2 | (25) | Requisition source | |
| DESTINATION_TYPE_CODE | VARCHAR2 | (25) | Requisition destionation type | |
| QUANTITY | NUMBER | Quantity ordered | ||
| UOM_CODE | VARCHAR2 | (3) | Unit of measure code | |
| LINE_TYPE_ID | NUMBER | Line type identifier | ||
| ORG_ID | NUMBER | Organization identifier | ||
| END_ITEM_UNIT_NUMBER | VARCHAR2 | (30) | End item unit number | |
| SR_INSTANCE_ID | NUMBER | Source application instance identifier | ||
| SUGGESTED_VENDOR_SITE | VARCHAR2 | (120) | Suggested supplier site name | |
| SOURCE_LINE_ID | NUMBER | Source Line Id | ||
| VMI_FLAG | NUMBER | VMI Flag Identifier |
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;
MSC.MSC_PO_REQUISITIONS_INTERFACE does not reference any database object
MSC.MSC_PO_REQUISITIONS_INTERFACE is referenced by following:
APPS
MSC_PO_REQUISITIONS_INTERFACE
|
|
|
|