VIEW: APPS.INVBV_INVENTORY_ORGANIZATIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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