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.

APPS.AHL_PRD_DF_PVT dependencies on AHL_UNIT_DEFERRALS_VL

Line 890: SELECT 'x' from ahl_unit_deferrals_vl

886: p_df_header_rec IN AHL_PRD_DF_PVT.df_header_rec_type)IS
887:
888: -- check whether any record already exists related to deferral
889: CURSOR deferral_rec_exists_csr(p_unit_effectivity_id IN NUMBER) IS
890: SELECT 'x' from ahl_unit_deferrals_vl
891: WHERE unit_deferral_type = 'DEFERRAL'
892: AND unit_effectivity_id = p_unit_effectivity_id;
893:
894: -- to check whether ue is in production

Line 1494: FROM ahl_unit_deferrals_vl

1490: affect_due_calc_flag, set_due_date, deferral_effective_on,remarks,approver_notes,attribute_category, attribute1,
1491: attribute2, attribute3, attribute4, attribute5, attribute6, attribute7,
1492: attribute8, attribute9, attribute10, attribute11, attribute12,
1493: attribute13, attribute14, attribute15
1494: FROM ahl_unit_deferrals_vl
1495: WHERE object_version_number= p_object_version_number
1496: AND unit_deferral_id = p_unit_deferral_id;
1497:
1498: l_df_header_rec AHL_PRD_DF_PVT.df_header_Rec_type;

Line 5473: ahl_unit_deferrals_vl.attribute_category,ahl_unit_deferrals_vl.attribute1,ahl_unit_deferrals_vl.attribute2,ahl_unit_deferrals_vl.attribute3,

5469: CURSOR df_header_info_csr(p_unit_effectivity_id IN NUMBER) IS
5470: SELECT unit_deferral_id, object_version_number, approval_status_code,FLV.meaning approval_status_meaning,defer_reason_code,skip_mr_flag,
5471: cancel_flag, affect_due_calc_flag, set_due_date, deferral_effective_on,remarks,approver_notes, user_deferral_type, DTYP.meaning user_deferral_mean,
5472: /*manisaga: added attributes for DFF Enablement on 22-Jan-2010--start */
5473: ahl_unit_deferrals_vl.attribute_category,ahl_unit_deferrals_vl.attribute1,ahl_unit_deferrals_vl.attribute2,ahl_unit_deferrals_vl.attribute3,
5474: ahl_unit_deferrals_vl.attribute4,ahl_unit_deferrals_vl.attribute5,ahl_unit_deferrals_vl.attribute6,ahl_unit_deferrals_vl.attribute7,
5475: ahl_unit_deferrals_vl.attribute8,ahl_unit_deferrals_vl.attribute9,ahl_unit_deferrals_vl.attribute10,ahl_unit_deferrals_vl.attribute11,
5476: ahl_unit_deferrals_vl.attribute12,ahl_unit_deferrals_vl.attribute13,ahl_unit_deferrals_vl.attribute14,ahl_unit_deferrals_vl.attribute15
5477: /*manisaga: added attributes for DFF Enablement on 22-Jan-2010--end */

Line 5474: ahl_unit_deferrals_vl.attribute4,ahl_unit_deferrals_vl.attribute5,ahl_unit_deferrals_vl.attribute6,ahl_unit_deferrals_vl.attribute7,

5470: SELECT unit_deferral_id, object_version_number, approval_status_code,FLV.meaning approval_status_meaning,defer_reason_code,skip_mr_flag,
5471: cancel_flag, affect_due_calc_flag, set_due_date, deferral_effective_on,remarks,approver_notes, user_deferral_type, DTYP.meaning user_deferral_mean,
5472: /*manisaga: added attributes for DFF Enablement on 22-Jan-2010--start */
5473: ahl_unit_deferrals_vl.attribute_category,ahl_unit_deferrals_vl.attribute1,ahl_unit_deferrals_vl.attribute2,ahl_unit_deferrals_vl.attribute3,
5474: ahl_unit_deferrals_vl.attribute4,ahl_unit_deferrals_vl.attribute5,ahl_unit_deferrals_vl.attribute6,ahl_unit_deferrals_vl.attribute7,
5475: ahl_unit_deferrals_vl.attribute8,ahl_unit_deferrals_vl.attribute9,ahl_unit_deferrals_vl.attribute10,ahl_unit_deferrals_vl.attribute11,
5476: ahl_unit_deferrals_vl.attribute12,ahl_unit_deferrals_vl.attribute13,ahl_unit_deferrals_vl.attribute14,ahl_unit_deferrals_vl.attribute15
5477: /*manisaga: added attributes for DFF Enablement on 22-Jan-2010--end */
5478:

Line 5475: ahl_unit_deferrals_vl.attribute8,ahl_unit_deferrals_vl.attribute9,ahl_unit_deferrals_vl.attribute10,ahl_unit_deferrals_vl.attribute11,

5471: cancel_flag, affect_due_calc_flag, set_due_date, deferral_effective_on,remarks,approver_notes, user_deferral_type, DTYP.meaning user_deferral_mean,
5472: /*manisaga: added attributes for DFF Enablement on 22-Jan-2010--start */
5473: ahl_unit_deferrals_vl.attribute_category,ahl_unit_deferrals_vl.attribute1,ahl_unit_deferrals_vl.attribute2,ahl_unit_deferrals_vl.attribute3,
5474: ahl_unit_deferrals_vl.attribute4,ahl_unit_deferrals_vl.attribute5,ahl_unit_deferrals_vl.attribute6,ahl_unit_deferrals_vl.attribute7,
5475: ahl_unit_deferrals_vl.attribute8,ahl_unit_deferrals_vl.attribute9,ahl_unit_deferrals_vl.attribute10,ahl_unit_deferrals_vl.attribute11,
5476: ahl_unit_deferrals_vl.attribute12,ahl_unit_deferrals_vl.attribute13,ahl_unit_deferrals_vl.attribute14,ahl_unit_deferrals_vl.attribute15
5477: /*manisaga: added attributes for DFF Enablement on 22-Jan-2010--end */
5478:
5479: FROM ahl_unit_deferrals_vl,fnd_lookup_values_vl FLV, fnd_lookup_values_vl DTYP

Line 5476: ahl_unit_deferrals_vl.attribute12,ahl_unit_deferrals_vl.attribute13,ahl_unit_deferrals_vl.attribute14,ahl_unit_deferrals_vl.attribute15

5472: /*manisaga: added attributes for DFF Enablement on 22-Jan-2010--start */
5473: ahl_unit_deferrals_vl.attribute_category,ahl_unit_deferrals_vl.attribute1,ahl_unit_deferrals_vl.attribute2,ahl_unit_deferrals_vl.attribute3,
5474: ahl_unit_deferrals_vl.attribute4,ahl_unit_deferrals_vl.attribute5,ahl_unit_deferrals_vl.attribute6,ahl_unit_deferrals_vl.attribute7,
5475: ahl_unit_deferrals_vl.attribute8,ahl_unit_deferrals_vl.attribute9,ahl_unit_deferrals_vl.attribute10,ahl_unit_deferrals_vl.attribute11,
5476: ahl_unit_deferrals_vl.attribute12,ahl_unit_deferrals_vl.attribute13,ahl_unit_deferrals_vl.attribute14,ahl_unit_deferrals_vl.attribute15
5477: /*manisaga: added attributes for DFF Enablement on 22-Jan-2010--end */
5478:
5479: FROM ahl_unit_deferrals_vl,fnd_lookup_values_vl FLV, fnd_lookup_values_vl DTYP
5480: WHERE unit_deferral_type = 'DEFERRAL'

Line 5479: FROM ahl_unit_deferrals_vl,fnd_lookup_values_vl FLV, fnd_lookup_values_vl DTYP

5475: ahl_unit_deferrals_vl.attribute8,ahl_unit_deferrals_vl.attribute9,ahl_unit_deferrals_vl.attribute10,ahl_unit_deferrals_vl.attribute11,
5476: ahl_unit_deferrals_vl.attribute12,ahl_unit_deferrals_vl.attribute13,ahl_unit_deferrals_vl.attribute14,ahl_unit_deferrals_vl.attribute15
5477: /*manisaga: added attributes for DFF Enablement on 22-Jan-2010--end */
5478:
5479: FROM ahl_unit_deferrals_vl,fnd_lookup_values_vl FLV, fnd_lookup_values_vl DTYP
5480: WHERE unit_deferral_type = 'DEFERRAL'
5481: AND unit_effectivity_id = p_unit_effectivity_id
5482: AND FLV.lookup_code = approval_status_code
5483: AND FLV.lookup_type = 'AHL_PRD_DF_APPR_STATUS_TYPES'