[Home] [Help] [Dependency Information]
Object Name: | PO_RTRN_DTL |
---|---|
Object Type: | TABLE |
Owner: | GML |
FND Design Data: | GML.PO_RTRN_DTL |
Subobject Name: | |
Status: | VALID |
PO_RTRN_DTL table tracks the returns made against a purchase order or in a stock receipt. This table has entries for every line that is returned against a specific receipt line (stock receipt or purchase order receipt).
Information in this table is transferred to Oracle Purchasing so that detailed return information is available in that application, and specifically, for matching invoices entered in Oracle Payables (and generating automatic invoices). The table RCV_TRANSACTIONS is updated to reflect returns entered in OPM.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PO_RTRN_DTL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | LINE_ID |
PO_RTRN_DTLI1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
RETURN_ID
LINE_NO |
PO_RTRN_DTLI2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RECVLINE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LINE_ID | NUMBER | (10) | Yes | Surrogate key for the line number in this return. |
RETURN_ID | NUMBER | (10) | Yes | Surrotate key for the return. |
LINE_NO | NUMBER | (5) | Yes | Line number. |
PO_ID | NUMBER | (10) | Surrogate key for the purchase order, ifapplicable, under which the material was originally received. | |
POLINE_ID | NUMBER | (10) | Surrogate key for the po line, if applicable, under which the material was originally received. | |
RECV_ID | NUMBER | (10) | Yes | Surrogate key for the receipt against which the material was originally received. |
RECVLINE_ID | NUMBER | (10) | Yes | Surrogate key for the receipt line against which the material was originally received. |
ITEM_ID | NUMBER | (10) | Yes | Surrogate key for the item being returned. |
RMA | VARCHAR2 | (16) | Yes | Return material authorization code, obtained from the vendor, acknowledging thereturn. |
RETURN_CODE | VARCHAR2 | (4) | Yes | Reason code for returning the material. |
RETURN_QTY1 | NUMBER | Yes | Quantity return (in uom 1). | |
RETURN_QTY2 | NUMBER | Quantity returned (in uom 2). | ||
RETURN_UM1 | VARCHAR2 | (4) | Yes | Unit of measure for quantity 1. |
RETURN_UM2 | VARCHAR2 | (4) | Unit of measure for quantity 2. | |
REORDER_IND | NUMBER | (5) | Yes | 1=reorder replacements for the materialreturned by creating new pending transaction. |
TRANS_CNT | NUMBER | (10) | Not currently used | |
TEXT_CODE | NUMBER | (10) | ID which joins any rows of text in this table to the Text Table for this Module | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE21 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE22 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE23 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE24 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE25 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE26 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE27 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE28 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE29 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE30 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT LINE_ID
, RETURN_ID
, LINE_NO
, PO_ID
, POLINE_ID
, RECV_ID
, RECVLINE_ID
, ITEM_ID
, RMA
, RETURN_CODE
, RETURN_QTY1
, RETURN_QTY2
, RETURN_UM1
, RETURN_UM2
, REORDER_IND
, TRANS_CNT
, TEXT_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, ATTRIBUTE_CATEGORY
FROM GML.PO_RTRN_DTL;
GML.PO_RTRN_DTL does not reference any database object
GML.PO_RTRN_DTL is referenced by following:
|
|
|