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

VIEW: BOM.CST_RECONCILIATION_SUMMARY#

Object Details
Object Name: CST_RECONCILIATION_SUMMARY#
Object Type: VIEW
Owner: BOM
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PO_DISTRIBUTION_ID NUMBER
Yes
ACCRUAL_ACCOUNT_ID NUMBER
Yes
PO_BALANCE NUMBER
Yes
AP_BALANCE NUMBER
Yes
WRITE_OFF_BALANCE NUMBER
Yes
LAST_RECEIPT_DATE DATE

LAST_INVOICE_DIST_DATE DATE

LAST_WRITE_OFF_DATE DATE

INVENTORY_ITEM_ID NUMBER

VENDOR_ID NUMBER

DESTINATION_TYPE_CODE VARCHAR2 (25)
WRITE_OFF_SELECT_FLAG VARCHAR2 (1)
OPERATING_UNIT_ID NUMBER
Yes
BUILD_ID NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

Query Text

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


SELECT PO_DISTRIBUTION_ID
,      ACCRUAL_ACCOUNT_ID
,      PO_BALANCE
,      AP_BALANCE
,      WRITE_OFF_BALANCE
,      LAST_RECEIPT_DATE
,      LAST_INVOICE_DIST_DATE
,      LAST_WRITE_OFF_DATE
,      INVENTORY_ITEM_ID
,      VENDOR_ID
,      DESTINATION_TYPE_CODE
,      WRITE_OFF_SELECT_FLAG
,      OPERATING_UNIT_ID
,      BUILD_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM BOM.CST_RECONCILIATION_SUMMARY#;

Dependencies

[top of page]

BOM.CST_RECONCILIATION_SUMMARY# references the following:

SchemaBOM
TableCST_RECONCILIATION_SUMMARY
BOM.CST_RECONCILIATION_SUMMARY# is referenced by following:

SchemaAPPS
SynonymCST_RECONCILIATION_SUMMARY