VIEW: APPS.MSD_SR_LOC_ORG_V

Source

View Text - Preformatted

SELECT to_char( hcs.site_use_id ) LEVEL_VALUE_PK, 8 ORG_LEVEL_ID, to_char( nvl( hcs.org_id, msd_sr_util.get_null_pk ) ) ORG_LEVEL_VALUE_PK FROM HZ_CUST_SITE_USES_ALL hcs, HZ_CUST_ACCOUNTS hca, HZ_CUST_ACCT_SITES_ALL hcl, (SELECT parameter_value FROM msd_setup_parameters WHERE parameter_name = 'MSD_CUSTOMER_ATTRIBUTE') filtercust WHERE hcl.cust_acct_site_id = hcs.cust_acct_site_id AND hcl.cust_account_id = hca.cust_account_id AND hcs.site_use_code = 'SHIP_TO' AND decode(nvl(lower(filtercust.parameter_value), '1'), '1', '1', 'attribute1', hca.attribute1, 'attribute2', hca.attribute2, 'attribute3', hca.attribute3, 'attribute4', hca.attribute4, 'attribute5', hca.attribute5, 'attribute6', hca.attribute6, 'attribute7', hca.attribute7, 'attribute8', hca.attribute8, 'attribute9', hca.attribute9, 'attribute10', hca.attribute10, 'attribute11', hca.attribute11, 'attribute12', hca.attribute12, 'attribute13', hca.attribute13, 'attribute14', hca.attribute14, 'attribute15', hca.attribute15, '2') = '1' UNION SELECT to_char(msd_sr_util.get_null_pk), 8, to_char(-777) FROM dual UNION SELECT to_char(hcs.site_use_id) LEVEL_VALUE_PK, 7, to_char(pla.organization_id) FROM HZ_CUST_SITE_USES_ALL hcs, HZ_CUST_ACCOUNTS hca, HZ_CUST_ACCT_SITES_ALL hcl, po_location_associations_all pla, (SELECT parameter_value FROM msd_setup_parameters WHERE parameter_name = 'MSD_CUSTOMER_ATTRIBUTE') filtercust WHERE hcl.cust_acct_site_id = hcs.cust_acct_site_id AND hcl.cust_account_id = hca.cust_account_id AND hcs.site_use_code = 'SHIP_TO' AND hcs.cust_acct_site_id = pla.address_id AND hcs.site_use_id = pla.site_use_id AND pla.organization_id is not null AND decode(nvl(lower(filtercust.parameter_value), '1'), '1', '1', 'attribute1', hca.attribute1, 'attribute2', hca.attribute2, 'attribute3', hca.attribute3, 'attribute4', hca.attribute4, 'attribute5', hca.attribute5, 'attribute6', hca.attribute6, 'attribute7', hca.attribute7, 'attribute8', hca.attribute8, 'attribute9', hca.attribute9, 'attribute10', hca.attribute10, 'attribute11', hca.attribute11, 'attribute12', hca.attribute12, 'attribute13', hca.attribute13, 'attribute14', hca.attribute14, 'attribute15', hca.attribute15, '2') = '1'

View Text - HTML Formatted

SELECT TO_CHAR( HCS.SITE_USE_ID ) LEVEL_VALUE_PK
, 8 ORG_LEVEL_ID
, TO_CHAR( NVL( HCS.ORG_ID
, MSD_SR_UTIL.GET_NULL_PK ) ) ORG_LEVEL_VALUE_PK
FROM HZ_CUST_SITE_USES_ALL HCS
, HZ_CUST_ACCOUNTS HCA
, HZ_CUST_ACCT_SITES_ALL HCL
, (SELECT PARAMETER_VALUE
FROM MSD_SETUP_PARAMETERS
WHERE PARAMETER_NAME = 'MSD_CUSTOMER_ATTRIBUTE') FILTERCUST
WHERE HCL.CUST_ACCT_SITE_ID = HCS.CUST_ACCT_SITE_ID
AND HCL.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID
AND HCS.SITE_USE_CODE = 'SHIP_TO'
AND DECODE(NVL(LOWER(FILTERCUST.PARAMETER_VALUE)
, '1')
, '1'
, '1'
, 'ATTRIBUTE1'
, HCA.ATTRIBUTE1
, 'ATTRIBUTE2'
, HCA.ATTRIBUTE2
, 'ATTRIBUTE3'
, HCA.ATTRIBUTE3
, 'ATTRIBUTE4'
, HCA.ATTRIBUTE4
, 'ATTRIBUTE5'
, HCA.ATTRIBUTE5
, 'ATTRIBUTE6'
, HCA.ATTRIBUTE6
, 'ATTRIBUTE7'
, HCA.ATTRIBUTE7
, 'ATTRIBUTE8'
, HCA.ATTRIBUTE8
, 'ATTRIBUTE9'
, HCA.ATTRIBUTE9
, 'ATTRIBUTE10'
, HCA.ATTRIBUTE10
, 'ATTRIBUTE11'
, HCA.ATTRIBUTE11
, 'ATTRIBUTE12'
, HCA.ATTRIBUTE12
, 'ATTRIBUTE13'
, HCA.ATTRIBUTE13
, 'ATTRIBUTE14'
, HCA.ATTRIBUTE14
, 'ATTRIBUTE15'
, HCA.ATTRIBUTE15
, '2') = '1' UNION SELECT TO_CHAR(MSD_SR_UTIL.GET_NULL_PK)
, 8
, TO_CHAR(-777)
FROM DUAL UNION SELECT TO_CHAR(HCS.SITE_USE_ID) LEVEL_VALUE_PK
, 7
, TO_CHAR(PLA.ORGANIZATION_ID)
FROM HZ_CUST_SITE_USES_ALL HCS
, HZ_CUST_ACCOUNTS HCA
, HZ_CUST_ACCT_SITES_ALL HCL
, PO_LOCATION_ASSOCIATIONS_ALL PLA
, (SELECT PARAMETER_VALUE
FROM MSD_SETUP_PARAMETERS
WHERE PARAMETER_NAME = 'MSD_CUSTOMER_ATTRIBUTE') FILTERCUST
WHERE HCL.CUST_ACCT_SITE_ID = HCS.CUST_ACCT_SITE_ID
AND HCL.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID
AND HCS.SITE_USE_CODE = 'SHIP_TO'
AND HCS.CUST_ACCT_SITE_ID = PLA.ADDRESS_ID
AND HCS.SITE_USE_ID = PLA.SITE_USE_ID
AND PLA.ORGANIZATION_ID IS NOT NULL
AND DECODE(NVL(LOWER(FILTERCUST.PARAMETER_VALUE)
, '1')
, '1'
, '1'
, 'ATTRIBUTE1'
, HCA.ATTRIBUTE1
, 'ATTRIBUTE2'
, HCA.ATTRIBUTE2
, 'ATTRIBUTE3'
, HCA.ATTRIBUTE3
, 'ATTRIBUTE4'
, HCA.ATTRIBUTE4
, 'ATTRIBUTE5'
, HCA.ATTRIBUTE5
, 'ATTRIBUTE6'
, HCA.ATTRIBUTE6
, 'ATTRIBUTE7'
, HCA.ATTRIBUTE7
, 'ATTRIBUTE8'
, HCA.ATTRIBUTE8
, 'ATTRIBUTE9'
, HCA.ATTRIBUTE9
, 'ATTRIBUTE10'
, HCA.ATTRIBUTE10
, 'ATTRIBUTE11'
, HCA.ATTRIBUTE11
, 'ATTRIBUTE12'
, HCA.ATTRIBUTE12
, 'ATTRIBUTE13'
, HCA.ATTRIBUTE13
, 'ATTRIBUTE14'
, HCA.ATTRIBUTE14
, 'ATTRIBUTE15'
, HCA.ATTRIBUTE15
, '2') = '1'