SELECT rct.CUSTOMER_TRX_ID
,rct.TRX_NUMBER
,rctt.CUST_TRX_TYPE_ID
,rct.OLD_TRX_NUMBER
,rctt.NAME
,rctt.DESCRIPTION
,rctt.TYPE
FROM
APPS.RA_CUSTOMER_TRX_ALL rct,
APPS.RA_CUST_TRX_TYPES_ALL rctt
WHERE rct.CUST_TRX_TYPE_ID=rctt.CUST_TRX_TYPE_ID
and rct.LEGAL_ENTITY_ID=&&
and rctt.TYPE='DM';
,rct.TRX_NUMBER
,rctt.CUST_TRX_TYPE_ID
,rct.OLD_TRX_NUMBER
,rctt.NAME
,rctt.DESCRIPTION
,rctt.TYPE
FROM
APPS.RA_CUSTOMER_TRX_ALL rct,
APPS.RA_CUST_TRX_TYPES_ALL rctt
WHERE rct.CUST_TRX_TYPE_ID=rctt.CUST_TRX_TYPE_ID
and rct.LEGAL_ENTITY_ID=&&
and rctt.TYPE='DM';
No comments:
Post a Comment