DBA Data[Home] [Help]

VIEW: APPS.CSM_MTL_PARAMETERS_V

Source

View Text - Preformatted

SELECT ACC.ACCESS_ID, B.ORGANIZATION_ID, B.ORGANIZATION_CODE, B.MASTER_ORGANIZATION_ID, B.NEGATIVE_INV_RECEIPT_CODE, B.STOCK_LOCATOR_CONTROL_CODE, B.TIMEZONE_ID FROM MTL_PARAMETERS B, CSM_MTL_PARAMETERS_ACC ACC WHERE B.ORGANIZATION_ID = ACC.ORGANIZATION_ID
View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, B.ORGANIZATION_ID
, B.ORGANIZATION_CODE
, B.MASTER_ORGANIZATION_ID
, B.NEGATIVE_INV_RECEIPT_CODE
, B.STOCK_LOCATOR_CONTROL_CODE
, B.TIMEZONE_ID
FROM MTL_PARAMETERS B
, CSM_MTL_PARAMETERS_ACC ACC
WHERE B.ORGANIZATION_ID = ACC.ORGANIZATION_ID