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.AS_OPP_LINE_PVT dependencies on AMS_P_SOURCE_CODES_V

Line 3400: FROM ams_p_source_codes_v

3396: -- Jean changed here based on campaign LOV and offer LOV enhancement
3397:
3398: CURSOR C_SOURCE_PROMOTION_ID_Exists (c_Source_Code_ID VARCHAR2) IS
3399: SELECT 'X'
3400: FROM ams_p_source_codes_v
3401: WHERE source_code_id = c_Source_Code_ID
3402: --AND status in ('ACTIVE', 'ONHOLD', 'COMPLETED')
3403: -- Fix for Bug 3093911 (Base Enh No: 2824485).
3404: -- Condition changed to include One Off Events.

Line 3474: FROM ams_p_source_codes_v a

3470: -- Jean changed here for offer, campaign enhancement
3471:
3472: CURSOR C_OFFER_ID_Exists (c_OFFER_ID VARCHAR2) IS
3473: SELECT 'X'
3474: FROM ams_p_source_codes_v a
3475: WHERE a.source_type = 'OFFR'
3476: AND sysdate between nvl(a.start_date, sysdate-1)
3477: and nvl(a.end_date, sysdate+1)
3478: --AND a.status = 'ACTIVE'