[Home] [Help] [Dependency Information]

VIEW: APPS.CST_ORGANIZATION_DEFINITIONS

Object Details

Object Name:	CST_ORGANIZATION_DEFINITIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BOM.CST_ORGANIZATION_DEFINITIONS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

CST_ORGANIZATION_DEFINITIONS is a view that resolves certain
basic information including the organization names,
three-letter codes, charts of accounts, and sets of books by joining
MTL_PARAMETERS and HR_ORGANIZATIONS for inventory organizations.
More information regarding an inventory organization may be directly
obtained from MTL_PARAMETERS.
An organization is an inventory organization if:
- it has a classification of "Inventory Organization"
- it has a set of books defined
- it has inventory parameters defined

[View Source]

Columns

Query Text

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

SELECT ORGANIZATION_ID
,      BUSINESS_GROUP_ID
,      USER_DEFINITION_ENABLE_DATE
,      DISABLE_DATE
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      SET_OF_BOOKS_ID
,      CHART_OF_ACCOUNTS_ID
,      CURRENCY_CODE
,      OPERATING_UNIT
,      LEGAL_ENTITY
FROM APPS.CST_ORGANIZATION_DEFINITIONS;

Dependencies

[top of page]

APPS

GL_LEDGERS

HR_ALL_ORGANIZATION_UNITS

HR_ALL_ORGANIZATION_UNITS_TL

HR_ORGANIZATION_INFORMATION

MTL_PARAMETERS

APPS

BOM_CSTRACTC_XMLP_PKG - show dependent code

BOM_CSTRDACR_XMLP_PKG - show dependent code

BOM_CSTRPCRE_XMLP_PKG - show dependent code

BOM_CSTRWOCR_XMLP_PKG - show dependent code

CSTPACDP - show dependent code

CSTPACWC - show dependent code

CSTPAPBR - show dependent code

CSTPAVCP - show dependent code

CSTPMECS - show dependent code

CSTPMRGL - show dependent code

CSTPOYLD - show dependent code

CSTPSMUT - show dependent code

CST_COMMON_HOOKS - show dependent code

CST_EAMCOST_PUB - show dependent code

CST_ITEMRESOURCECOSTS_GRP - show dependent code

CST_LC_ADJ_INTERFACE_V

CST_MGD_MSTR_BOOK_RPT - show dependent code

CST_PACEAMCOST_GRP - show dependent code

CST_PAC_AEL_GL_RCV_V

CST_PAC_AEL_SL_RCV_V

CST_PENDINGTXNSREPORT_PVT - show dependent code

CST_PERIODIC_ABSORPTION_PROC - show dependent code

CST_PERIODSUMMARY_PVT - show dependent code

CST_PL_IMPORT - show dependent code

CST_PRJMFG_COST_COLLECTOR - show dependent code

CST_RCV_RAE_V

CST_RECEIPTACCRUALPEREND_PVT - show dependent code

CST_REVENUECOGSMATCH_PVT - show dependent code

DPP_ITEMCOST_PVT - show dependent code

EAM_FAILURE_ANALYSIS_PVT - show dependent code

GMF_RCV_ACCOUNTING_PKG - show dependent code

INV_LOGICAL_TRANSACTIONS_PUB - show dependent code

PO_POXRRCVV_XMLP_PKG - show dependent code

RCV_ACCRUALUTILITIES_GRP - show dependent code

RCV_ROI_TRANSACTION - show dependent code

RCV_SEEDEVENTS_PVT - show dependent code

RCV_WSH_INTERFACE_PKG - show dependent code