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_PAC_ACCRUAL_RECONCILE_TEMP

Object Details

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

CST_PAC_ACCRUAL_RECONCILE_TEMP is a temporary table that stores information pertinent to Periodic Accrual Reconciliation Report. This table holds accrual information from Oracle Payables, Oracle Purchasing, Oracle Inventory and Oracle Work in Process.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CST_PAC_ACCR_RECONCILE_TEMP_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	LEGAL_ENTITY_ID COST_GROUP_ID COST_TYPE_ID PERIOD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_DATE	DATE		Yes	Date for the transaction
INVENTORY_ITEM_ID	NUMBER			Item unique identifier
TRANSACTION_QUANTITY	NUMBER			Quantity for the transaction, in the PO_UOM
PO_HEADER_ID	NUMBER			Document header unique identifier
PO_LINE_NUM	NUMBER			Purchase order Line number
PO_LINE_ID	NUMBER			Document line unique identifier
VENDOR_NAME	VARCHAR2	(240)		Supplier name
INVOICE_ID	NUMBER			Invoice unique identifier
INVOICE_LINE_NUM	NUMBER			Invoice distribution number
LINE_MATCH_ORDER	NUMBER			Line sequence number for matching
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
TRANSACTION_ORGANIZATION_ID	NUMBER	(15)	Yes	Organization where transaction took place
VENDOR_ID	NUMBER			Supplier unique identifier
ITEM_MASTER_ORGANIZATION_ID	NUMBER		Yes	Item Master/Purchasing reference organization
ACCRUAL_ACCOUNT_ID	NUMBER		Yes	Accrual account unique identifier
ACCRUAL_CODE	VARCHAR2	(80)		Type of transaction or A/P match condition
PO_TRANSACTION_TYPE	VARCHAR2	(25)		Purchasing transaction code
INVOICE_NUM	VARCHAR2	(50)		Invoice number
RECEIPT_NUM	VARCHAR2	(30)		Receipt number
PO_TRANSACTION_ID	NUMBER			Receiving transaction unique identifier
INV_TRANSACTION_ID	NUMBER			Inventory transaction unique identifier
INV_TRANSACTION_TYPE_ID	NUMBER			Inventory transaction type unique identifier
WIP_TRANSACTION_ID	NUMBER			WIP transaction unique identifier
WIP_TRANSACTION_TYPE_ID	NUMBER			WIP transaction type unique identifier
PO_UNIT_OF_MEASURE	VARCHAR2	(25)		PO unit of measure
PRIMARY_UNIT_OF_MEASURE	VARCHAR2	(25)		Primary unit of measure for the item
NET_PO_LINE_QUANTITY	NUMBER			Po line invoice quantity less PO line receipt quantity, for Release 9 calculations
PO_NUM	VARCHAR2	(20)		PO number
PO_DISTRIBUTION_ID	NUMBER			Document distribution unique identifier
TRANSACTION_UNIT_PRICE	NUMBER			Unit price for the transaction
AVG_RECEIPT_PRICE	NUMBER			Average receipt price for the PO line
TRANSACTION_AMOUNT	NUMBER			Transaction debit or credit
TRANSACTION_SOURCE_CODE	VARCHAR2	(25)	Yes	Transaction source or subledger
WRITE_OFF_FLAG	VARCHAR2	(1)		Indicates whether what has been written off
WRITE_OFF_ID	NUMBER			Write-off unique identifier
DESTINATION_TYPE_CODE	VARCHAR2	(25)		Destination type for the transaction
REASON_ID	NUMBER			Transaction reason unique identifier
COMMENTS	VARCHAR2	(240)		Comments for accrual write-off
PERIOD_NAME	VARCHAR2	(15)		Accounting period name
NET_PO_LINE_AMOUNT	NUMBER			PO line invoice amount less receipt amount. Used for IPV.
INVOICE_PRICE_VARIANCE	NUMBER			Invoice price variance
AGING_DATE	DATE			Earliest transaction date for the PO line
PERIOD_ID	NUMBER			Periodic costing period unique identifier
LINE_LOCATION_ID	NUMBER			Document line location unique identifier
VENDOR_NAME_ALT	VARCHAR2	(320)		Alternate supplier name for Japanese location
LEGAL_ENTITY_ID	NUMBER	(15)	Yes	Legal entity unique identifier
COST_GROUP_ID	NUMBER	(15)	Yes	Cost group unique identifier
COST_TYPE_ID	NUMBER	(15)	Yes	Cost type unique identifier
ADJUSTMENT_TRANSACTION	NUMBER			Specifies if the transaction is a retro active price adjustment

Query Text

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


SELECT TRANSACTION_DATE
,      INVENTORY_ITEM_ID
,      TRANSACTION_QUANTITY
,      PO_HEADER_ID
,      PO_LINE_NUM
,      PO_LINE_ID
,      VENDOR_NAME
,      INVOICE_ID
,      INVOICE_LINE_NUM
,      LINE_MATCH_ORDER
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      TRANSACTION_ORGANIZATION_ID
,      VENDOR_ID
,      ITEM_MASTER_ORGANIZATION_ID
,      ACCRUAL_ACCOUNT_ID
,      ACCRUAL_CODE
,      PO_TRANSACTION_TYPE
,      INVOICE_NUM
,      RECEIPT_NUM
,      PO_TRANSACTION_ID
,      INV_TRANSACTION_ID
,      INV_TRANSACTION_TYPE_ID
,      WIP_TRANSACTION_ID
,      WIP_TRANSACTION_TYPE_ID
,      PO_UNIT_OF_MEASURE
,      PRIMARY_UNIT_OF_MEASURE
,      NET_PO_LINE_QUANTITY
,      PO_NUM
,      PO_DISTRIBUTION_ID
,      TRANSACTION_UNIT_PRICE
,      AVG_RECEIPT_PRICE
,      TRANSACTION_AMOUNT
,      TRANSACTION_SOURCE_CODE
,      WRITE_OFF_FLAG
,      WRITE_OFF_ID
,      DESTINATION_TYPE_CODE
,      REASON_ID
,      COMMENTS
,      PERIOD_NAME
,      NET_PO_LINE_AMOUNT
,      INVOICE_PRICE_VARIANCE
,      AGING_DATE
,      PERIOD_ID
,      LINE_LOCATION_ID
,      VENDOR_NAME_ALT
,      LEGAL_ENTITY_ID
,      COST_GROUP_ID
,      COST_TYPE_ID
,      ADJUSTMENT_TRANSACTION
FROM BOM.CST_PAC_ACCRUAL_RECONCILE_TEMP;

Dependencies

[top of page]

BOM.CST_PAC_ACCRUAL_RECONCILE_TEMP does not reference any database object

BOM.CST_PAC_ACCRUAL_RECONCILE_TEMP is referenced by following:

APPS: CST_PAC_ACCRUAL_RECONCILE_TEMP