VIEW: APPS.PAY_MX_GRE_SS_ARCHIVER_V

Source

View Text - Preformatted

SELECT hou.organization_id gre_id, houtl.NAME gre_name, hou.business_group_id, 'SUA'|| substr(replace(houtl.name,' ',''),1,3) ||lpad(substr(to_char(hoi.organization_id),1,5),5,'0')||to_char(sysdate,'MMDDYYHHMISS') file_name FROM hr_all_organization_units hou, hr_organization_information hoi, hr_all_organization_units_tl houtl WHERE hoi.organization_id = hou.organization_id AND hoi.org_information_context = 'CLASS' AND hoi.org_information1 = 'HR_LEGAL' AND hoi.org_information2 = 'Y' AND hou.organization_id = houtl.organization_id AND houtl.language = USERENV('LANG') AND pay_mx_soc_sec_archive.arch_exists_without_upgrade (hou.business_group_id) <> 'E' UNION SELECT null, hr_general.decode_lookup('MX_SS_ARCH_UPGRADE','TRAN_DATE_UPG'), hou.business_group_id, 'X'||rownum FROM hr_all_organization_units hou WHERE pay_mx_soc_sec_archive.arch_exists_without_upgrade (hou.business_group_id) = 'E'

View Text - HTML Formatted

SELECT HOU.ORGANIZATION_ID GRE_ID
, HOUTL.NAME GRE_NAME
, HOU.BUSINESS_GROUP_ID
, 'SUA'|| SUBSTR(REPLACE(HOUTL.NAME
, ' '
, '')
, 1
, 3) ||LPAD(SUBSTR(TO_CHAR(HOI.ORGANIZATION_ID)
, 1
, 5)
, 5
, '0')||TO_CHAR(SYSDATE
, 'MMDDYYHHMISS') FILE_NAME
FROM HR_ALL_ORGANIZATION_UNITS HOU
, HR_ORGANIZATION_INFORMATION HOI
, HR_ALL_ORGANIZATION_UNITS_TL HOUTL
WHERE HOI.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND HOI.ORG_INFORMATION_CONTEXT = 'CLASS'
AND HOI.ORG_INFORMATION1 = 'HR_LEGAL'
AND HOI.ORG_INFORMATION2 = 'Y'
AND HOU.ORGANIZATION_ID = HOUTL.ORGANIZATION_ID
AND HOUTL.LANGUAGE = USERENV('LANG')
AND PAY_MX_SOC_SEC_ARCHIVE.ARCH_EXISTS_WITHOUT_UPGRADE (HOU.BUSINESS_GROUP_ID) <> 'E' UNION SELECT NULL
, HR_GENERAL.DECODE_LOOKUP('MX_SS_ARCH_UPGRADE'
, 'TRAN_DATE_UPG')
, HOU.BUSINESS_GROUP_ID
, 'X'||ROWNUM
FROM HR_ALL_ORGANIZATION_UNITS HOU
WHERE PAY_MX_SOC_SEC_ARCHIVE.ARCH_EXISTS_WITHOUT_UPGRADE (HOU.BUSINESS_GROUP_ID) = 'E'