SELECT COLLECTOR_ID, DESCRIPTION, EMPLOYEE_ID, INACTIVE_DATE, NAME, STATUS, TELEPHONE_NUMBER, ALIAS FROM AR_COLLECTORS UNION ALL SELECT -1 COLLECTOR_ID, FND_MESSAGE.get_string('FII', 'FII_AR_UNID_CUSTOMER') DESCRIPTION, NULL EMPLOYEE_ID, NULL INACTIVE_DATE, FND_MESSAGE.get_string('FII', 'FII_AR_UNID_CUSTOMER') NAME, 'A' STATUS, NULL TELEPHONE_NUMBER, NULL ALIAS FROM DUAL
SELECT COLLECTOR_ID
, DESCRIPTION
, EMPLOYEE_ID
, INACTIVE_DATE
, NAME
, STATUS
, TELEPHONE_NUMBER
, ALIAS
FROM AR_COLLECTORS UNION ALL SELECT -1 COLLECTOR_ID
, FND_MESSAGE.GET_STRING('FII'
, 'FII_AR_UNID_CUSTOMER') DESCRIPTION
, NULL EMPLOYEE_ID
, NULL INACTIVE_DATE
, FND_MESSAGE.GET_STRING('FII'
, 'FII_AR_UNID_CUSTOMER') NAME
, 'A' STATUS
, NULL TELEPHONE_NUMBER
, NULL ALIAS
FROM DUAL
|
|
|