View: INVBV_INVENTORY_ORGANIZATIONS

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.INVBV_INVENTORY_ORGANIZATIONS

View Text

SELECT MP.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, MP.MASTER_ORGANIZATION_ID
, '_LA:MP.PRIMARY_COST_METHOD:MFG_LOOKUPS:MTL_PRIMARY_COST:MEANING'
, MP.COST_ORGANIZATION_ID
, MP.DEFAULT_MATERIAL_COST_ID
, MP.CALENDAR_EXCEPTION_SET_ID
, MP.CALENDAR_CODE
, '_LA:MP.GENERAL_LEDGER_UPDATE_CODE:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, MP.DEFAULT_ATP_RULE_ID
, MP.DEFAULT_PICKING_RULE_ID
, MP.DEFAULT_LOCATOR_ORDER_VALUE
, MP.DEFAULT_SUBINV_ORDER_VALUE
, '_LA:MP.NEGATIVE_INV_RECEIPT_CODE:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:MP.STOCK_LOCATOR_CONTROL_CODE:MFG_LOOKUPS:MTL_LOCATION_CONTROL:MEANING'
, MP.MATERIAL_ACCOUNT
, MP.MATERIAL_OVERHEAD_ACCOUNT
, MP.MATL_OVHD_ABSORPTION_ACCT
, MP.RESOURCE_ACCOUNT
, MP.PURCHASE_PRICE_VAR_ACCOUNT
, MP.AP_ACCRUAL_ACCOUNT
, MP.OVERHEAD_ACCOUNT
, MP.OUTSIDE_PROCESSING_ACCOUNT
, MP.INTRANSIT_INV_ACCOUNT
, MP.INTERORG_RECEIVABLES_ACCOUNT
, MP.INTERORG_PRICE_VAR_ACCOUNT
, MP.INTERORG_PAYABLES_ACCOUNT
, MP.COST_OF_SALES_ACCOUNT
, MP.ENCUMBRANCE_ACCOUNT
, MP.INTERORG_TRANSFER_CR_ACCOUNT
, '_LA:MP.MATL_INTERORG_TRANSFER_CODE:MFG_LOOKUPS:MTL_INTER_INV_TRANSFER:MEANING'
, MP.INTERORG_TRNSFR_CHARGE_PERCENT
, MP.SOURCE_ORGANIZATION_ID
, MP.SOURCE_SUBINVENTORY
, '_LA:MP.SOURCE_TYPE:MFG_LOOKUPS:MTL_SOURCE_TYPES:MEANING'
, '_LA:MP.SERIAL_NUMBER_TYPE:MFG_LOOKUPS:MTL_SERIAL_NUMBER_TYPE:MEANING'
, MP.AUTO_SERIAL_ALPHA_PREFIX
, MP.START_AUTO_SERIAL_NUMBER
, MP.AUTO_LOT_ALPHA_PREFIX
, '_LA:MP.LOT_NUMBER_UNIQUENESS:MFG_LOOKUPS:MTL_LOT_UNIQUENESS:MEANING'
, '_LA:MP.LOT_NUMBER_GENERATION:MFG_LOOKUPS:MTL_LOT_GENERATION:MEANING'
, '_LA:MP.LOT_NUMBER_ZERO_PADDING:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, MP.LOT_NUMBER_LENGTH
, MP.STARTING_REVISION
, '_LA:MP.DEFAULT_DEMAND_CLASS:FND_COMMON_LOOKUPS:DEMAND_CLASS:MEANING'
, '_LA:MP.ENCUMBRANCE_REVERSAL_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:MP.MAINTAIN_FIFO_QTY_STACK_TYPE:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, MP.INVOICE_PRICE_VAR_ACCOUNT
, MP.AVERAGE_COST_VAR_ACCOUNT
, MP.SALES_ACCOUNT
, MP.EXPENSE_ACCOUNT
, '_LA:MP.SERIAL_NUMBER_GENERATION:MFG_LOOKUPS:MTL_SERIAL_GENERATION:MEANING'
, MP.REQUEST_ID
, MP.PROGRAM_APPLICATION_ID
, MP.PROGRAM_ID
, MP.PROGRAM_UPDATE_DATE
, MP.MAT_OVHD_COST_TYPE_ID
, MP.PROJECT_REFERENCE_ENABLED
, MP.PM_COST_COLLECTION_ENABLED
, MP.PROJECT_CONTROL_LEVEL
, MP.AVG_RATES_COST_TYPE_ID
, MP.CREATED_BY
, MP.CREATION_DATE
, MP.LAST_UPDATED_BY
, MP.LAST_UPDATE_DATE
FROM MTL_PARAMETERS MP
WHERE '_SEC:MP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns