INV_TRANSFER_ORDER_STATUS_GT
This is a global temp table that is used to store the transfer order lines used by Transfer Order Status Report.
Details
-
Schema: FUSION
-
Object owner: INV
-
Object type: TABLE
-
Tablespace: Default
Columns
Name | Datatype | Length | Precision | Comments |
---|---|---|---|---|
LINE_ID | NUMBER | 18 | Transfer Order Line Unique Identifier. | |
LINE_NUMBER | NUMBER | 9 | This is the transfer order line number. | |
HEADER_NUMBER | VARCHAR2 | 50 | This is the transfer order number. | |
SOURCE_TYPE_LOOKUP | VARCHAR2 | 30 | Source from where this order was requested. Eg. SSP/Planning/Return/Min-Max | |
SOURCE_TYPE | VARCHAR2 | 80 | Meaning of SOURCE_TYPE_LOOKUP. | |
REQUESTER_ID | NUMBER | 18 | Reference to unique identifier of the requester | |
REQUESTER_NAME | VARCHAR2 | 240 | Name of the requester | |
PLANNER_ID | NUMBER | 18 | Reference to unique identifier of the planner | |
PLANNER_NAME | VARCHAR2 | 240 | Name of the planner | |
SOURCE_ORGANIZATION_ID | NUMBER | 18 | Reference to the unique identifier for the source organization. | |
SOURCE_ORGANIZATION_CODE | VARCHAR2 | 18 | Organization code of the source organization. | |
DESTINATION_ORGANIZATION_ID | NUMBER | 18 | Reference to the unique identifier for the destination organization. | |
DESTINATION_ORGANIZATION_CODE | VARCHAR2 | 18 | Organization code of the destination organization. | |
DESTINATION_SUBINVENTORY_CODE | VARCHAR2 | 10 | Destination organization subinventory name | |
DESTINATION_LOCATION_ID | NUMBER | 18 | Destination location (from hr_locations) | |
DESTINATION_LOCATION_CODE | VARCHAR2 | 60 | Location code of the destination location. | |
INVENTORY_ITEM_ID | NUMBER | 18 | This identifies the inventory item. | |
ITEM_NUMBER | VARCHAR2 | 300 | This is the item number. | |
ITEM_DESCRIPTION | VARCHAR2 | 240 | This is the item description. | |
ITEM_REVISION | VARCHAR2 | 18 | Item revision. (References EGP_ITEM_REVISIONS_VL.revision.) | |
LINE_CREATION_DATE | TIMESTAMP | Indicates the date and time of the creation of the tranfer order line. | ||
LINE_LAST_UPDATE_DATE | TIMESTAMP | Indicates the date and time of the last update of the transfer order line. | ||
NEED_BY_DATE | DATE | Date this transfer order line is requested for arrival | ||
INTERFACE_STATUS_LOOKUP | VARCHAR2 | 30 | Meanings can be Awaiting Interface to DOO, Error, Awaiting Interface to Shipping, Interfaced to DOO, Interfaced to Shipping | |
INTERFACE_STATUS | VARCHAR2 | 80 | Meaning of INTERFACE_STATUS_LOOKUP. | |
REQ_BU_ID | NUMBER | 18 | Business Unit for requesting organization | |
REQ_BU_NAME | VARCHAR2 | 240 | Business unit name for requesting organization | |
REQUISITION_ID | NUMBER | 18 | Reference to unique identifier of requisition number from which this Transfer Order was created | |
REQUISITION_NUMBER | VARCHAR2 | 64 | Requisition header number. | |
REQUISITION_LINE_ID | NUMBER | 18 | Reference to unique identifier of the requisition line number from which this Transfer order line was created | |
REQUISITION_LINE_NUMBER | NUMBER | Requisition line number from which this Transfer order line was created. | ||
PREPARER_NAME | VARCHAR2 | 240 | Name of the preparer of a requisition | |
DESTINATION_TYPE_LOOKUP | VARCHAR2 | 30 | Destination type, whether Inventory or Expense | |
DESTINATION_TYPE | VARCHAR2 | 80 | Meaning of DESTINATION_TYPE_LOOKUP | |
QTY_UOM_CODE | VARCHAR2 | 3 | The unit of measure code of the line quantity | |
UNIT_OF_MEASURE | VARCHAR2 | 25 | The unit of measure name of the line quantity | |
REQUESTED_QTY | NUMBER | This is the quantity requested. | ||
SHIPPED_QTY | NUMBER | This column stores the quantity shipped. | ||
RECEIVED_QTY | NUMBER | This column stores the quantity received. | ||
DELIVERED_QTY | NUMBER | Quantity delivered and putaway in Inventory after receipt | ||
SECONDARY_QTY_UOM_CODE | VARCHAR2 | 3 | Secondary unit of measure code of line quantity | |
SECONDARY_UNIT_OF_MEASURE | VARCHAR2 | 25 | Secondary unit of measure name of line quantity | |
SECONDARY_REQUESTED_QTY | NUMBER | Quantity requested in secondary unit of measure | ||
SECONDARY_SHIPPED_QTY | NUMBER | Quantity shipped in secondary unit of measure | ||
SECONDARY_RECEIVED_QTY | NUMBER | Quantity received in secondary unit of measure | ||
SECONDARY_DELIVERED_QTY | NUMBER | Quantity delivered and putaway in Inventory in secondary unit of measure | ||
UNIT_PRICE | NUMBER | Price per unit of item requested | ||
CURRENCY_CODE | VARCHAR2 | 15 | Currency code. This is the Requesting Org's default currency, value supplied by SCO | |
TOTAL_PRICE | NUMBER | Total transfer price of the transfer order line. | ||
INCL_NONRECOVERABLE_TAX | NUMBER | Included Unit Non-Recoverable Tax | ||
INCL_RECOVERABLE_TAX | NUMBER | This is the included unit recoverable tax. | ||
NONINCL_NONRECOVERABLE_TAX | NUMBER | Non-included Unit Non-Recoverable Tax | ||
NONINCL_RECOVERABLE_TAX | NUMBER | Non-included Unit Recoverable Tax | ||
FULFILLMENT_STATUS | VARCHAR2 | 80 | Meaning can be Awaiting Fulfillment, Shipped, and etc. | |
CHARGE_ACCOUNT | VARCHAR2 | 120 | General ledger charge account | |
BUDGET_DATE | VARCHAR2 | 48 | Budget date of transfer order distributions of the line if only one, otherwise ???Multiple??? | |
SHIPMENT_PRIORITY_LOOKUP | VARCHAR2 | 30 | This lookup code indicates the shipment priority. | |
SHIPMENT_PRIORITY | VARCHAR2 | 80 | Meaning of SHIPMENT_PRIORITY_LOOKUP. | |
DESTINATION_LOCATION_NAME | VARCHAR2 | 240 | Name of the location. | |
SCHEDULED_SHIP_DATE | DATE | Date this transfer order is scheduled to ship | ||
ERR_MSG_TEXT | VARCHAR2 | 2000 | This message text from FND_MESSAGES is the error text. | |
STATUS_LOOKUP | VARCHAR2 | 30 | Indicates whether line is OPEN/CLOSED/CANCELLED | |
LINE_STATUS | VARCHAR2 | 80 | Meaning of STATUS_LOOKUP | |
CANCEL_RESULT_LOOKUP | VARCHAR2 | 30 | Indicates whether cancel remaining quantity result is SUCCESS/ERROR/SUBMITTED. | |
CANCEL_RESULT | VARCHAR2 | 80 | Meaning of CANCEL_RESULT_LOOKUP | |
WDD_IN_PROCESS_LOOKUP | VARCHAR2 | 1 | Y if a transfer order line has WDD lines in released or staged status. | |
WDD_IN_PROCESS | VARCHAR2 | 80 | meaning of WDD_IN_PROCESS_LOOKUP | |
SORT_SEQUENCE | NUMBER | Sequence number used in sorting the records. | ||
PJC_PROJECT_ID | NUMBER | 18 | Identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions. | |
PJC_TASK_ID | NUMBER | 18 | Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions. | |
PJC_PROJECT_NUMBER | VARCHAR2 | 25 | Number of the project used to build the transaction descriptive flexifeld. | |
PJC_TASK_NUMBER | VARCHAR2 | 100 | Number of the task used to build the transaction descriptive flexifeld. | |
CONSUMED_REQUESTED_QTY | NUMBER | The requested quantity consumed when a shipping tolerance exists. |