[Home] [Help] [Dependency Information]

VIEW: APPS.INVFV_INVENTORY_ORGANIZATIONS

Object Details

Object Name:	INVFV_INVENTORY_ORGANIZATIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	INV.INVFV_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, etc., for each organization

[View Source]

Columns

Query Text

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

SELECT ORGANIZATION_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      MASTER_ORGANIZATION_ID
,      MASTER_ORGANIZATION_CODE
,      MASTER_ORGANIZATION_NAME
,      _LA:PRIMARY_COST_METHOD
,      COST_ORGANIZATION_ID
,      COST_ORGANIZATION_CODE
,      COST_ORGANIZATION_NAME
,      DEFAULT_MATERIAL_COST_ID
,      DEFAULT_MATERIAL_COST_CODE
,      CALENDAR_EXCEPTION_SET_ID
,      CALENDAR_EXCEPTION_SET_NAME
,      CALENDAR_CODE
,      CALENDAR_DESCRIPTION
,      _LA:GL_UPDATE_CODE
,      DEFAULT_ATP_RULE_ID
,      DEFAULT_ATP_RULE_NAME
,      DEFAULT_PICKING_RULE_ID
,      DEFAULT_PICKING_RULE_NAME
,      DEFAULT_LOCATOR_ORDER_VALUE
,      DEFAULT_SUBINV_ORDER_VALUE
,      _LA:NEG_INV_RECEIPT_CODE
,      _LA:STOCK_LOC_CONTROL_CODE
,      MATERIAL_ACCOUNT
,      _KF:ACC_NO:MATERIAL:_CO
,      MATERIAL_OVERHEAD_ACCOUNT
,      _KF:ACC_NO:MTL_OVERHEAD:_CO
,      MATL_OVHD_ABSORPTION_ACCT
,      _KF:ACC_NO:MTLOVHD_ABSRB:_CO
,      RESOURCE_ACCOUNT
,      _KF:ACC_NO:RESOURCE:_CO
,      PURCHASE_PRICE_VAR_ACCOUNT
,      _KF:ACC_NO:PUR_PRICE:_CO
,      AP_ACCRUAL_ACCOUNT
,      _KF:ACC_NO:AP_ACCRUAL:_CO
,      OVERHEAD_ACCOUNT
,      _KF:ACC_NO:OVERHEAD:_CO
,      OUTSIDE_PROCESSING_ACCOUNT
,      _KF:ACC_NO:OUTSIDE_PROCS:_CO
,      INTRANSIT_INV_ACCOUNT
,      _KF:ACC_NO:INTRANSIT_INV:_CO
,      INTERORG_RECEIVABLES_ACCOUNT
,      _KF:ACC_NO:INTRORG_RCVBL:_CO
,      INTERORG_PRICE_VAR_ACCOUNT
,      _KF:ACC_NO:INTORG_PRCVAR:_CO
,      INTERORG_PAYABLES_ACCOUNT
,      _KF:ACC_NO:INTRORG_PAY:_CO
,      COST_OF_SALES_ACCOUNT
,      _KF:ACC_NO:COST_OF_SALES:_CO
,      ENCUMBRANCE_ACCOUNT
,      _KF:ACC_NO:ENCUMBRANCE:_CO
,      INTERORG_TRANSFER_CR_ACCOUNT
,      _KF:ACC_NO:INTRORGXFR_CR:_CO
,      _LA:MTL_INTERORG_XFR_CODE
,      INTERORG_TRNSFR_CHARGE_PERCENT
,      SOURCE_ORGANIZATION_ID
,      SOURCE_ORGANIZATION_CODE
,      SOURCE_ORGANIZATION_NAME
,      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
,      _KF:ACC_NO:INVOIC_PRCVAR:_CO
,      AVERAGE_COST_VAR_ACCOUNT
,      _KF:ACC_NO:AVG_COST_VAR:_CO
,      SALES_ACCOUNT
,      _KF:ACC_NO:SALES:_CO
,      EXPENSE_ACCOUNT
,      _KF:ACC_NO:EXPENSE:_CO
,      _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.INVFV_INVENTORY_ORGANIZATIONS;

Dependencies

[top of page]

APPS

BOM_CALENDARS

BOM_EXCEPTION_SETS

BOM_RESOURCES

GL_CODE_COMBINATIONS

HR_ALL_ORGANIZATION_UNITS

MTL_ATP_RULES

MTL_PARAMETERS

MTL_PICKING_RULES

APPS.INVFV_INVENTORY_ORGANIZATIONS is not referenced by any database object