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 ,'U' FROM MTL_PARAMETERS B, CSM_MTL_PARAMETERS_ACC ACC WHERE B.ORGANIZATION_ID = ACC.ORGANIZATION_ID AND EXISTS (SELECT 1 FROM ASG_USER WHERE USER_ID=ASG_BASE.GET_USER_ID AND NVL(MULTI_PLATFORM,'N')='N') UNION ALL 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 , DECODE((SELECT count(1) FROM csp_planning_parameters csp WHERE csp.organization_id=B.ORGANIZATION_ID AND nvl(csp.condition_type, 'G') = 'G'),0,'B','G') FROM MTL_PARAMETERS B, CSM_MTL_PARAMETERS_ACC ACC WHERE B.ORGANIZATION_ID = ACC.ORGANIZATION_ID AND EXISTS (SELECT 1 FROM ASG_USER WHERE USER_ID=ASG_BASE.GET_USER_ID AND NVL(MULTI_PLATFORM,'N')='Y') AND EXISTS (SELECT 1 FROM CSM_INTERORG_PARAMETERS_ACC WHERE B.ORGANIZATION_ID IN (FROM_ORGANIZATION_ID ,TO_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
, 'U'
FROM MTL_PARAMETERS B
, CSM_MTL_PARAMETERS_ACC ACC
WHERE B.ORGANIZATION_ID = ACC.ORGANIZATION_ID
AND EXISTS (SELECT 1
FROM ASG_USER
WHERE USER_ID=ASG_BASE.GET_USER_ID
AND NVL(MULTI_PLATFORM
, 'N')='N') UNION ALL 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
, DECODE((SELECT COUNT(1)
FROM CSP_PLANNING_PARAMETERS CSP
WHERE CSP.ORGANIZATION_ID=B.ORGANIZATION_ID
AND NVL(CSP.CONDITION_TYPE
, 'G') = 'G')
, 0
, 'B'
, 'G')
FROM MTL_PARAMETERS B
, CSM_MTL_PARAMETERS_ACC ACC
WHERE B.ORGANIZATION_ID = ACC.ORGANIZATION_ID
AND EXISTS (SELECT 1
FROM ASG_USER
WHERE USER_ID=ASG_BASE.GET_USER_ID
AND NVL(MULTI_PLATFORM
, 'N')='Y')
AND EXISTS (SELECT 1
FROM CSM_INTERORG_PARAMETERS_ACC
WHERE B.ORGANIZATION_ID IN (FROM_ORGANIZATION_ID
, TO_ORGANIZATION_ID))