eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: BOM.CST_AP_VARIANCE_LINES

Object Details

Object Name:	CST_AP_VARIANCE_LINES
Object Type:	TABLE
Owner:	BOM
FND Design Data:	BOM.CST_AP_VARIANCE_LINES
Subobject Name:
Status:	VALID

Stores the variance information detail for a purchase order distribution and each batch run

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_AP_VARIANCE_LINES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	VARIANCE_HEADER_ID VARIANCE_LINE_ID
CST_AP_VARIANCE_LINES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID

Columns

Name	Datatype	Mandatory	Comments
VARIANCE_HEADER_ID	NUMBER	Yes	Variance header identifier
VARIANCE_LINE_ID	NUMBER	Yes	Variance line identifier
BATCH_ID	NUMBER	Yes	Batch identifier that created this record
INVOICE_DISTRIBUTION_ID	NUMBER	Yes	Invoice distribution ID as stored in AP tables
INVOICE_ID	NUMBER		Invoice ID as stored in AP tables
DISTRIBUTION_LINE_NUMBER	NUMBER		Invoice distribution line number
PO_DISTRIBUTION_ID	NUMBER	Yes	Purchase order distribution to which this invoice is matched
INVOICE_PRICE_VARIANCE	NUMBER		Invoice price variance amount
BASE_INVOICE_PRICE_VARIANCE	NUMBER		Invoice price variance amount in base currency
VAR_AMOUNT	NUMBER		Invoice variance amount to be transferred to Inventory
PROJECT_ID	NUMBER		Project as indicated on the invoice
ORGANIZATION_ID	NUMBER	Yes	Inventory Organization to which the PO distribution will deliver
INVENTORY_ITEM_ID	NUMBER	Yes	Inventory item as indicated on the purchase order line
CREATION_DATE	DATE	Yes	Standard Who column
LAST_UPDATE_DATE	DATE	Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	Yes	Standard Who column
CREATED_BY	NUMBER	Yes	Standard Who column
REQUEST_ID	NUMBER		Extended Who column
PROGRAM_APPLICATION_ID	NUMBER		Extended Who column
PROGRAM_ID	NUMBER		Extended Who column
PROGRAM_UPDATE_DATE	DATE		Extended Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
COST_GROUP_ID	NUMBER		Cost Group Identifier

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT VARIANCE_HEADER_ID
,      VARIANCE_LINE_ID
,      BATCH_ID
,      INVOICE_DISTRIBUTION_ID
,      INVOICE_ID
,      DISTRIBUTION_LINE_NUMBER
,      PO_DISTRIBUTION_ID
,      INVOICE_PRICE_VARIANCE
,      BASE_INVOICE_PRICE_VARIANCE
,      VAR_AMOUNT
,      PROJECT_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      COST_GROUP_ID
FROM BOM.CST_AP_VARIANCE_LINES;

Dependencies

[top of page]

BOM.CST_AP_VARIANCE_LINES does not reference any database object

BOM.CST_AP_VARIANCE_LINES is referenced by following:

BOM: CST_AP_VARIANCE_LINES#