ZX_ACCT_PTP_RO_V
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: VIEW
Columns
Name |
---|
ENTITY_ID EFFECTIVE_FROM EFFECTIVE_TO REPORTING_CODE_CHAR_VALUE REPORTING_CODE_DATE_VALUE REPORTING_CODE_NUM_VALUE REPORTING_TYPE_ID REPORTING_CODE_ID REPORTING_TYPE_CODE REPORTING_TYPE_NAME REPORTING_TYPE_DATATYPE_CODE REPORTING_DATATYPE_CODE_NAME REPORTING_CODE_NAME |
Query
SQL_Statement |
---|
SELECT RepCodeAssoc.ENTITY_ID, RepCodeAssoc.EFFECTIVE_FROM , RepCodeAssoc.EFFECTIVE_TO , RepCodeAssoc.REPORTING_CODE_CHAR_VALUE , RepCodeAssoc.REPORTING_CODE_DATE_VALUE , RepCodeAssoc.REPORTING_CODE_NUM_VALUE , RepCodeAssoc.REPORTING_TYPE_ID , RepCodeAssoc.REPORTING_CODE_ID , RepTypes.REPORTING_TYPE_CODE , RepTypes.REPORTING_TYPE_NAME , RepTypes.REPORTING_TYPE_DATATYPE_CODE , NVL( (SELECT DatatypeLookups.Meaning FROM fnd_lookups DatatypeLookups WHERE DatatypeLookups.lookup_type = 'ZX_REPORTING_DATA' AND DatatypeLookups.lookup_code = RepTypes.REPORTING_TYPE_DATATYPE_CODE ), (SELECT DatatypeLookups.Meaning FROM fnd_lookups DatatypeLookups WHERE DatatypeLookups.lookup_type = 'ZX_REPORTING_DATA' AND DatatypeLookups.lookup_code = 'YES_NO' )) Reporting_datatype_code_name, DECODE( RepTypes.REPORTING_TYPE_DATATYPE_CODE,'YES_NO', (SELECT DatatypeLookups.Meaning FROM fnd_lookups DatatypeLookups WHERE DatatypeLookups.lookup_type = 'ZX_YES_NO' AND DatatypeLookups.lookup_code = RepCodeAssoc.REPORTING_CODE_CHAR_VALUE ), 'TEXT', (SELECT ZxReportingCodesVl.reporting_code_name FROM ZX_REPORTING_CODES_VL ZxReportingCodesVl WHERE ZxReportingCodesVl.reporting_type_id = RepTypes.reporting_type_id AND ZxReportingCodesVl.REPORTING_CODE_ID = RepCodeAssoc.REPORTING_CODE_ID ), 'NUMERIC_VALUE', (SELECT ZxReportingCodesVl.reporting_code_name FROM ZX_REPORTING_CODES_VL ZxReportingCodesVl WHERE ZxReportingCodesVl.reporting_type_id = RepTypes.reporting_type_id AND ZxReportingCodesVl.REPORTING_CODE_ID = RepCodeAssoc.REPORTING_CODE_ID ) ,NULL) REPORTING_CODE_NAME FROM ZX_REPORT_CODES_ASSOC RepCodeAssoc, ZX_REPORTING_TYPES_VL RepTypes WHERE RepCodeAssoc.REPORTING_TYPE_ID = RepTypes.REPORTING_TYPE_ID AND (RepTypes.LEGAL_MESSAGE_FLAG = 'N' or RepTypes.LEGAL_MESSAGE_FLAG IS NULL) and RepCodeAssoc.entity_code = 'ZX_PARTY_TAX_PROFILE' |