View: INVFV_INVENTORY_ORGANIZATIONS

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

View Text

SELECT MP.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, MP.MASTER_ORGANIZATION_ID
, MP1.ORGANIZATION_CODE
, HOU1.NAME
, '_LA:MP.PRIMARY_COST_METHOD:MFG_LOOKUPS:MTL_PRIMARY_COST:MEANING'
, MP.COST_ORGANIZATION_ID
, MP2.ORGANIZATION_CODE
, HOU2.NAME
, MP.DEFAULT_MATERIAL_COST_ID
, BR.RESOURCE_CODE
, MP.CALENDAR_EXCEPTION_SET_ID
, BES.EXCEPTION_SET_NAME
, MP.CALENDAR_CODE
, BC.DESCRIPTION
, '_LA:MP.GENERAL_LEDGER_UPDATE_CODE:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, MP.DEFAULT_ATP_RULE_ID
, MAR.RULE_NAME
, MP.DEFAULT_PICKING_RULE_ID
, MPR.PICKING_RULE_NAME
, 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
, '_KF:SQLGL:GL#:GCC11'
, MP.MATERIAL_OVERHEAD_ACCOUNT
, '_KF:SQLGL:GL#:GCC8'
, MP.MATL_OVHD_ABSORPTION_ACCT
, '_KF:SQLGL:GL#:GCC9'
, MP.RESOURCE_ACCOUNT
, '_KF:SQLGL:GL#:GCC7'
, MP.PURCHASE_PRICE_VAR_ACCOUNT
, '_KF:SQLGL:GL#:GCC13'
, MP.AP_ACCRUAL_ACCOUNT
, '_KF:SQLGL:GL#:GCC1'
, MP.OVERHEAD_ACCOUNT
, '_KF:SQLGL:GL#:GCC10'
, MP.OUTSIDE_PROCESSING_ACCOUNT
, '_KF:SQLGL:GL#:GCC12'
, MP.INTRANSIT_INV_ACCOUNT
, '_KF:SQLGL:GL#:GCC6'
, MP.INTERORG_RECEIVABLES_ACCOUNT
, '_KF:SQLGL:GL#:GCC3'
, MP.INTERORG_PRICE_VAR_ACCOUNT
, '_KF:SQLGL:GL#:GCC5'
, MP.INTERORG_PAYABLES_ACCOUNT
, '_KF:SQLGL:GL#:GCC4'
, MP.COST_OF_SALES_ACCOUNT
, '_KF:SQLGL:GL#:GCC2'
, MP.ENCUMBRANCE_ACCOUNT
, '_KF:SQLGL:GL#:GCC14'
, MP.INTERORG_TRANSFER_CR_ACCOUNT
, '_KF:SQLGL:GL#:GCC15'
, '_LA:MP.MATL_INTERORG_TRANSFER_CODE:MFG_LOOKUPS:MTL_INTER_INV_TRANSFER:MEANING'
, MP.INTERORG_TRNSFR_CHARGE_PERCENT
, MP.SOURCE_ORGANIZATION_ID
, MP3.ORGANIZATION_CODE
, HOU3.NAME
, 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
, '_KF:SQLGL:GL#:GCC16'
, MP.AVERAGE_COST_VAR_ACCOUNT
, '_KF:SQLGL:GL#:GCC17'
, MP.SALES_ACCOUNT
, '_KF:SQLGL:GL#:GCC18'
, MP.EXPENSE_ACCOUNT
, '_KF:SQLGL:GL#:GCC19'
, '_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 BOM_CALENDARS BC
, BOM_EXCEPTION_SETS BES
, BOM_RESOURCES BR
, GL_CODE_COMBINATIONS GCC1
, GL_CODE_COMBINATIONS GCC2
, GL_CODE_COMBINATIONS GCC3
, GL_CODE_COMBINATIONS GCC4
, GL_CODE_COMBINATIONS GCC5
, GL_CODE_COMBINATIONS GCC6
, GL_CODE_COMBINATIONS GCC7
, GL_CODE_COMBINATIONS GCC8
, GL_CODE_COMBINATIONS GCC9
, GL_CODE_COMBINATIONS GCC10
, GL_CODE_COMBINATIONS GCC11
, GL_CODE_COMBINATIONS GCC12
, GL_CODE_COMBINATIONS GCC13
, GL_CODE_COMBINATIONS GCC14
, GL_CODE_COMBINATIONS GCC15
, GL_CODE_COMBINATIONS GCC16
, GL_CODE_COMBINATIONS GCC17
, GL_CODE_COMBINATIONS GCC18
, GL_CODE_COMBINATIONS GCC19
, HR_ALL_ORGANIZATION_UNITS HOU
, HR_ALL_ORGANIZATION_UNITS HOU1
, HR_ALL_ORGANIZATION_UNITS HOU2
, HR_ALL_ORGANIZATION_UNITS HOU3
, MTL_PARAMETERS MP1
, MTL_PARAMETERS MP2
, MTL_PARAMETERS MP3
, MTL_ATP_RULES MAR
, MTL_PICKING_RULES MPR
, MTL_PARAMETERS MP
WHERE BC.CALENDAR_CODE (+) = MP.CALENDAR_CODE
AND BES.EXCEPTION_SET_ID (+) = MP.CALENDAR_EXCEPTION_SET_ID
AND BR.RESOURCE_ID (+) = MP.DEFAULT_MATERIAL_COST_ID
AND GCC1.CODE_COMBINATION_ID (+) = MP.AP_ACCRUAL_ACCOUNT
AND GCC2.CODE_COMBINATION_ID (+) = MP.COST_OF_SALES_ACCOUNT
AND GCC3.CODE_COMBINATION_ID (+) = MP.INTERORG_RECEIVABLES_ACCOUNT
AND GCC4.CODE_COMBINATION_ID (+) = MP.INTERORG_PAYABLES_ACCOUNT
AND GCC5.CODE_COMBINATION_ID (+) = MP.INTERORG_PRICE_VAR_ACCOUNT
AND GCC6.CODE_COMBINATION_ID (+) = MP.INTRANSIT_INV_ACCOUNT
AND GCC7.CODE_COMBINATION_ID (+) = MP.RESOURCE_ACCOUNT
AND GCC8.CODE_COMBINATION_ID (+) = MP.MATERIAL_OVERHEAD_ACCOUNT
AND GCC9.CODE_COMBINATION_ID (+) = MP.MATL_OVHD_ABSORPTION_ACCT
AND GCC10.CODE_COMBINATION_ID (+) = MP.OVERHEAD_ACCOUNT
AND GCC11.CODE_COMBINATION_ID (+) = MP.MATERIAL_ACCOUNT
AND GCC12.CODE_COMBINATION_ID (+) = MP.OUTSIDE_PROCESSING_ACCOUNT
AND GCC13.CODE_COMBINATION_ID (+) = MP.PURCHASE_PRICE_VAR_ACCOUNT
AND GCC14.CODE_COMBINATION_ID (+) = MP.ENCUMBRANCE_ACCOUNT
AND GCC15.CODE_COMBINATION_ID (+) = MP.INTERORG_TRANSFER_CR_ACCOUNT
AND GCC16.CODE_COMBINATION_ID (+) = MP.INVOICE_PRICE_VAR_ACCOUNT
AND GCC17.CODE_COMBINATION_ID (+) = MP.AVERAGE_COST_VAR_ACCOUNT
AND GCC18.CODE_COMBINATION_ID (+) = MP.SALES_ACCOUNT
AND GCC19.CODE_COMBINATION_ID (+) = MP.EXPENSE_ACCOUNT
AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MP1.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID
AND MP2.ORGANIZATION_ID = MP.COST_ORGANIZATION_ID
AND HOU2.ORGANIZATION_ID = MP.COST_ORGANIZATION_ID
AND MP3.ORGANIZATION_ID (+) = MP.SOURCE_ORGANIZATION_ID
AND HOU3.ORGANIZATION_ID (+) = MP.SOURCE_ORGANIZATION_ID
AND MAR.RULE_ID (+) = MP.DEFAULT_ATP_RULE_ID
AND MPR.PICKING_RULE_ID (+) = MP.DEFAULT_PICKING_RULE_ID
AND '_SEC:MP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns