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. |