eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.JL_JLCOFAAR_XMLP_PKG dependencies on JL_CO_FA_ASSET_APPRS

Line 124: JL_CO_FA_ASSET_APPRS ASP,

120: COUNT(*)
121: INTO X
122: FROM
123: JL_CO_FA_APPRAISALS AP,
124: JL_CO_FA_ASSET_APPRS ASP,
125: FND_LOOKUPS FLH,
126: FND_LOOKUPS FLD
127: WHERE AP.APPRAISAL_ID = P_APPRAISAL_ID
128: AND ASP.APPRAISAL_ID = AP.APPRAISAL_ID

Line 160: JL_CO_FA_ASSET_APPRS ASP,

156: COUNT(*)
157: INTO X
158: FROM
159: JL_CO_FA_APPRAISALS AP,
160: JL_CO_FA_ASSET_APPRS ASP,
161: FND_LOOKUPS FLH,
162: FND_LOOKUPS FLD
163: WHERE AP.APPRAISAL_ID = P_APPRAISAL_ID
164: AND ASP.APPRAISAL_ID = AP.APPRAISAL_ID