DBA Data[Home] [Help]

VIEW: APPS.CSL_MTL_PARAMETERS_V

Source

View Text - Preformatted

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

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