VIEW: APPS.INVFV_INVENTORY_ORGANIZATIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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