View: PAY_US_ARCH_MAG_COUNTY_SD_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_US_ARCH_MAG_COUNTY_SD_V

View Text

SELECT FAI.CONTEXT1 ASSIGNMENT_ACTION_ID
, FAI.VALUE COUNTY_SD_NAME
, FAIC.CONTEXT JURISDICTION_CODE
FROM FF_ARCHIVE_ITEM_CONTEXTS FAIC
, FF_ARCHIVE_ITEMS FAI
, FF_DATABASE_ITEMS FDI
WHERE FDI.USER_NAME = 'A_COUNTY_SD_NAME'
AND FDI.USER_ENTITY_ID = FAI.USER_ENTITY_ID
AND FAI.ARCHIVE_ITEM_ID = FAIC.ARCHIVE_ITEM_ID

Columns