[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GME_RESOURCE_TXNS |
|---|---|
| Object Type: | TABLE |
| Owner: | GME |
| FND Design Data: |  GME.GME_RESOURCE_TXNS
|
| Subobject Name: | |
| Status: | VALID |
Process operations control transaction table. This table stores resource transactions created in POC.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GME_RESOURCE_TXNS_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 POC_TRANS_ID
|
| GME_RESOURCE_TXNS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DOC_TYPE
DOC_ID
LINE_ID
|
| GME_RESOURCE_TXNS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TRANS_DATE
|
| GME_RESOURCE_TXNS_N3 | FUNCTION-BASED NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
CASE "POSTED_IND" WHEN 0 THEN 0 ELSE NULL END
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| POC_TRANS_ID | NUMBER | (10) | Yes | Key identifying a POC transaction. |
| ORGN_CODE | VARCHAR2 | (4) | Obsolete in R12. New column is organization_id | |
| DOC_TYPE | VARCHAR2 | (4) | Yes | Type of document that created the POC transaction.FPO - Firm Planned Order. |
| DOC_ID | NUMBER | (10) | Yes | Surrogate key of the document that created the POC transaction |
| LINE_TYPE | NUMBER | (5) | Yes | Type of line. Batch step line. |
| LINE_ID | NUMBER | (10) | Yes | Surrogate key of the document line that created the POC transaction. FK to GME_BATCH_STEP_RESOURCES. |
| RESOURCES | VARCHAR2 | (16) | Yes | Resource used in the transaction |
| RESOURCE_USAGE | NUMBER | Yes | Quantity of the resource used. | |
| TRANS_UM | VARCHAR2 | (4) | Obsolete in R12. New column is trans_qty_um | |
| TRANS_DATE | DATE | Yes | Date of the POC transaction. GL uses this date to determine the period to post the resource cost. | |
| COMPLETED_IND | NUMBER | (5) | Yes | Completed indicator. 0 = Pending, 1 = Completed. |
| EVENT_ID | NUMBER | (10) | Event id. FK to GME_BATCH_HISTORY. | |
| POSTED_IND | NUMBER | (5) | Yes | Posted indicator. 0 = Not posted 1 = Posted |
| OVERRIDED_PROTECTED_IND | VARCHAR2 | (1) | N - Default; Cannot override values entered.Y - Allows values to be overridden. | |
| REASON_CODE | VARCHAR2 | (4) | Reason code associated with the POC transaction | |
| START_DATE | DATE | Yes | Date/time the POC transaction started. Beginning of the resource transaction, needs to fall within the start date of the resources it is associated, GME_BATCH_RESOURCES | |
| END_DATE | DATE | Yes | Date/time the POC transaction ended. End of the resource transaction, needs to fall within the end date of the resources it is associated, GME_BATCH_RESOURCES | |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| DELETE_MARK | NUMBER | (5) | Yes | Delete Mark |
| TEXT_CODE | NUMBER | (10) | Text code | |
| ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE21 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE22 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE23 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE24 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE25 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE26 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE27 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE28 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE29 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE30 | VARCHAR2 | (240) | Descriptive Flexfield | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield Category | |
| PROGRAM_ID | NUMBER | (15) | Concurrent who column | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent who column | |
| REQUEST_ID | NUMBER | (15) | Concurrent who column | |
| PROGRAM_UPDATE_DATE | DATE | Concurrent who column | ||
| INSTANCE_ID | NUMBER | (15) | Record the instance that was used for the usage | |
| SEQUENCE_DEPENDENT_IND | NUMBER | (5) | Indicate that the transaction is for sequence dependent usage | |
| REVERSE_ID | NUMBER | (10) | This column will be populated with the poc_trans_id of the the coressponding reversal transaction. | |
| ORGANIZATION_ID | NUMBER | To identify the organization (Plant /Lab) | ||
| TRANS_QTY_UM | VARCHAR2 | (3) | Transaction usage UOM | |
| REASON_ID | NUMBER | Reason unique identifier |
Cut, paste (and edit) the following text to query this object:
SELECT POC_TRANS_ID
, ORGN_CODE
, DOC_TYPE
, DOC_ID
, LINE_TYPE
, LINE_ID
, RESOURCES
, RESOURCE_USAGE
, TRANS_UM
, TRANS_DATE
, COMPLETED_IND
, EVENT_ID
, POSTED_IND
, OVERRIDED_PROTECTED_IND
, REASON_CODE
, START_DATE
, END_DATE
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, DELETE_MARK
, TEXT_CODE
, 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
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
, PROGRAM_UPDATE_DATE
, INSTANCE_ID
, SEQUENCE_DEPENDENT_IND
, REVERSE_ID
, ORGANIZATION_ID
, TRANS_QTY_UM
, REASON_ID
FROM GME.GME_RESOURCE_TXNS;
GME.GME_RESOURCE_TXNS does not reference any database object
GME.GME_RESOURCE_TXNS is referenced by following:
APPS
GME_RESOURCE_TXNS
GME_RESOURCE_TXNS_D1
GME_RESOURCE_TXNS_I1
GME_RESOURCE_TXNS_U1
|
|
|
|