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]

VIEW: APPS.INVBV_INVENTORY_ORGANIZATIONS

Object Details

Object Name:	INVBV_INVENTORY_ORGANIZATIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.INVBV_INVENTORY_ORGANIZATIONS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This shows a set of default options such as general ledger accounts, locator, lot and serial controls, inter-organization options, costing methods, and so on, for each organization.

[View Source]

Columns

Name	Datatype	Length	Mandatory
ORGANIZATION_ID	NUMBER		Yes
ORGANIZATION_CODE	VARCHAR2	(3)
MASTER_ORGANIZATION_ID	NUMBER		Yes
_LA:PRIMARY_COST_METHOD	CHAR	(63)
COST_ORGANIZATION_ID	NUMBER		Yes
DEFAULT_MATERIAL_COST_ID	NUMBER
CALENDAR_EXCEPTION_SET_ID	NUMBER
CALENDAR_CODE	VARCHAR2	(10)
_LA:GL_UPDATE_CODE	CHAR	(64)
DEFAULT_ATP_RULE_ID	NUMBER
DEFAULT_PICKING_RULE_ID	NUMBER
DEFAULT_LOCATOR_ORDER_VALUE	NUMBER
DEFAULT_SUBINV_ORDER_VALUE	NUMBER
_LA:NEG_INV_RECEIPT_CODE	CHAR	(63)
_LA:STOCK_LOC_CONTROL_CODE	CHAR	(74)
MATERIAL_ACCOUNT	NUMBER
MATERIAL_OVERHEAD_ACCOUNT	NUMBER
MATL_OVHD_ABSORPTION_ACCT	NUMBER
RESOURCE_ACCOUNT	NUMBER
PURCHASE_PRICE_VAR_ACCOUNT	NUMBER
AP_ACCRUAL_ACCOUNT	NUMBER
OVERHEAD_ACCOUNT	NUMBER
OUTSIDE_PROCESSING_ACCOUNT	NUMBER
INTRANSIT_INV_ACCOUNT	NUMBER
INTERORG_RECEIVABLES_ACCOUNT	NUMBER
INTERORG_PRICE_VAR_ACCOUNT	NUMBER
INTERORG_PAYABLES_ACCOUNT	NUMBER
COST_OF_SALES_ACCOUNT	NUMBER
ENCUMBRANCE_ACCOUNT	NUMBER
INTERORG_TRANSFER_CR_ACCOUNT	NUMBER
_LA:MTL_INTERORG_XFR_CODE	CHAR	(77)
INTERORG_TRNSFR_CHARGE_PERCENT	NUMBER
SOURCE_ORGANIZATION_ID	NUMBER
SOURCE_SUBINVENTORY	VARCHAR2	(10)
_LA:SOURCE_TYPE	CHAR	(55)
_LA:SERIAL_NUMBER_TYPE	CHAR	(68)
AUTO_SERIAL_ALPHA_PREFIX	VARCHAR2	(30)
START_AUTO_SERIAL_NUMBER	VARCHAR2	(30)
AUTO_LOT_ALPHA_PREFIX	VARCHAR2	(30)
_LA:LOT_NUMBER_UNIQUENESS	CHAR	(67)
_LA:LOT_NUMBER_GENERATION	CHAR	(67)
_LA:LOT_NUMBER_ZERO_PADDING	CHAR	(61)
LOT_NUMBER_LENGTH	NUMBER
STARTING_REVISION	VARCHAR2	(3)	Yes
_LA:DEFAULT_DEMAND_CLASS	CHAR	(67)
_LA:ENCUMBRANCE_REVERSL_FLAG	CHAR	(63)
_LA:MNT_FIFO_QTY_STACK_TYPE	CHAR	(66)
INVOICE_PRICE_VAR_ACCOUNT	NUMBER
AVERAGE_COST_VAR_ACCOUNT	NUMBER
SALES_ACCOUNT	NUMBER
EXPENSE_ACCOUNT	NUMBER
_LA:SERIAL_NUMBER_GENERATION	CHAR	(73)
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
MAT_OVHD_COST_TYPE_ID	NUMBER
PROJECT_REFERENCE_ENABLED	NUMBER
PM_COST_COLLECTION_ENABLED	NUMBER
PROJECT_CONTROL_LEVEL	NUMBER
AVG_RATES_COST_TYPE_ID	NUMBER
CREATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes

Query Text

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


SELECT ORGANIZATION_ID
,      ORGANIZATION_CODE
,      MASTER_ORGANIZATION_ID
,      _LA:PRIMARY_COST_METHOD
,      COST_ORGANIZATION_ID
,      DEFAULT_MATERIAL_COST_ID
,      CALENDAR_EXCEPTION_SET_ID
,      CALENDAR_CODE
,      _LA:GL_UPDATE_CODE
,      DEFAULT_ATP_RULE_ID
,      DEFAULT_PICKING_RULE_ID
,      DEFAULT_LOCATOR_ORDER_VALUE
,      DEFAULT_SUBINV_ORDER_VALUE
,      _LA:NEG_INV_RECEIPT_CODE
,      _LA:STOCK_LOC_CONTROL_CODE
,      MATERIAL_ACCOUNT
,      MATERIAL_OVERHEAD_ACCOUNT
,      MATL_OVHD_ABSORPTION_ACCT
,      RESOURCE_ACCOUNT
,      PURCHASE_PRICE_VAR_ACCOUNT
,      AP_ACCRUAL_ACCOUNT
,      OVERHEAD_ACCOUNT
,      OUTSIDE_PROCESSING_ACCOUNT
,      INTRANSIT_INV_ACCOUNT
,      INTERORG_RECEIVABLES_ACCOUNT
,      INTERORG_PRICE_VAR_ACCOUNT
,      INTERORG_PAYABLES_ACCOUNT
,      COST_OF_SALES_ACCOUNT
,      ENCUMBRANCE_ACCOUNT
,      INTERORG_TRANSFER_CR_ACCOUNT
,      _LA:MTL_INTERORG_XFR_CODE
,      INTERORG_TRNSFR_CHARGE_PERCENT
,      SOURCE_ORGANIZATION_ID
,      SOURCE_SUBINVENTORY
,      _LA:SOURCE_TYPE
,      _LA:SERIAL_NUMBER_TYPE
,      AUTO_SERIAL_ALPHA_PREFIX
,      START_AUTO_SERIAL_NUMBER
,      AUTO_LOT_ALPHA_PREFIX
,      _LA:LOT_NUMBER_UNIQUENESS
,      _LA:LOT_NUMBER_GENERATION
,      _LA:LOT_NUMBER_ZERO_PADDING
,      LOT_NUMBER_LENGTH
,      STARTING_REVISION
,      _LA:DEFAULT_DEMAND_CLASS
,      _LA:ENCUMBRANCE_REVERSL_FLAG
,      _LA:MNT_FIFO_QTY_STACK_TYPE
,      INVOICE_PRICE_VAR_ACCOUNT
,      AVERAGE_COST_VAR_ACCOUNT
,      SALES_ACCOUNT
,      EXPENSE_ACCOUNT
,      _LA:SERIAL_NUMBER_GENERATION
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      MAT_OVHD_COST_TYPE_ID
,      PROJECT_REFERENCE_ENABLED
,      PM_COST_COLLECTION_ENABLED
,      PROJECT_CONTROL_LEVEL
,      AVG_RATES_COST_TYPE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.INVBV_INVENTORY_ORGANIZATIONS;

Dependencies

[top of page]

APPS.INVBV_INVENTORY_ORGANIZATIONS references the following:

APPS: MTL_PARAMETERS

APPS.INVBV_INVENTORY_ORGANIZATIONS is not referenced by any database object