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.OZF_CUST_FACTS_PVT dependencies on AMS_ACT_ACCESS_DENORM

Line 2815: FROM ams_act_access_denorm

2811: AND b.status_code = 'ACTIVE'
2812: AND b.party_id = outer.party_id
2813: AND b.party_id = c.party_id
2814: AND NVL(b.ship_to_site_use_id, DECODE((SELECT count(object_id)
2815: FROM ams_act_access_denorm
2816: WHERE object_type = b.plan_type
2817: AND object_id = b.plan_id
2818: AND resource_id = outer.resource_id), 0, 0, c.ship_to_site_use_id)) = c.ship_to_site_use_id
2819: AND

Line 2830: FROM ams_act_access_denorm

2826: (
2827: b.product_level_type IS NULL
2828: AND b.product_id IS NULL
2829: AND EXISTS (SELECT 'X'
2830: FROM ams_act_access_denorm
2831: WHERE object_type = b.plan_type
2832: AND object_id = b.plan_id
2833: AND resource_id = outer.resource_id)
2834: )

Line 2860: FROM ams_act_access_denorm

2856: AND b.party_id = c.party_id
2857: AND b.bill_to_site_use_id = outer.bill_to_site_use_id
2858: AND b.bill_to_site_use_id = c.bill_to_site_use_id
2859: AND NVL(b.ship_to_site_use_id, DECODE((SELECT count(object_id)
2860: FROM ams_act_access_denorm
2861: WHERE object_type = b.plan_type
2862: AND object_id = b.plan_id
2863: AND resource_id = outer.resource_id), 0, 0, c.ship_to_site_use_id)) = c.ship_to_site_use_id
2864: AND

Line 2875: FROM ams_act_access_denorm

2871: (
2872: b.product_level_type IS NULL
2873: AND b.product_id IS NULL
2874: AND EXISTS (SELECT 'X'
2875: FROM ams_act_access_denorm
2876: WHERE object_type = b.plan_type
2877: AND object_id = b.plan_id
2878: AND resource_id = outer.resource_id)
2879: )

Line 2914: FROM ams_act_access_denorm

2910: or
2911: ( b.product_level_type IS NULL
2912: AND b.product_id IS NULL
2913: AND EXISTS (SELECT 'X'
2914: FROM ams_act_access_denorm
2915: WHERE object_type = b.plan_type
2916: AND object_id = b.plan_id
2917: AND resource_id = outer.resource_id)
2918: )

Line 2942: FROM ams_act_access_denorm

2938: AND b.status_code = 'ACTIVE'
2939: AND b.party_id = outer.party_id
2940: AND b.party_id = c.party_id
2941: AND NVL(b.ship_to_site_use_id, DECODE((SELECT count(object_id)
2942: FROM ams_act_access_denorm
2943: WHERE object_type = b.plan_type
2944: AND object_id = b.plan_id
2945: AND resource_id = outer.resource_id), 0, 0, c.ship_to_site_use_id)) = c.ship_to_site_use_id
2946: AND

Line 2957: FROM ams_act_access_denorm

2953: (
2954: b.product_level_type IS NULL
2955: AND b.product_id IS NULL
2956: AND EXISTS (SELECT 'X'
2957: FROM ams_act_access_denorm
2958: WHERE object_type = b.plan_type
2959: AND object_id = b.plan_id
2960: AND resource_id = outer.resource_id)
2961: )

Line 2987: FROM ams_act_access_denorm

2983: AND b.party_id = c.party_id
2984: AND b.bill_to_site_use_id = outer.bill_to_site_use_id
2985: AND b.bill_to_site_use_id = c.bill_to_site_use_id
2986: AND NVL(b.ship_to_site_use_id, DECODE((SELECT count(object_id)
2987: FROM ams_act_access_denorm
2988: WHERE object_type = b.plan_type
2989: AND object_id = b.plan_id
2990: AND resource_id = outer.resource_id), 0, 0, c.ship_to_site_use_id)) = c.ship_to_site_use_id
2991: AND

Line 3002: FROM ams_act_access_denorm

2998: (
2999: b.product_level_type IS NULL
3000: AND b.product_id IS NULL
3001: AND EXISTS (SELECT 'X'
3002: FROM ams_act_access_denorm
3003: WHERE object_type = b.plan_type
3004: AND object_id = b.plan_id
3005: AND resource_id = outer.resource_id)
3006: )

Line 3042: FROM ams_act_access_denorm

3038: OR
3039: ( b.product_level_type IS NULL
3040: AND b.product_id IS NULL
3041: AND EXISTS (SELECT count(object_id)
3042: FROM ams_act_access_denorm
3043: WHERE object_type = b.plan_type
3044: AND object_id = b.plan_id
3045: AND resource_id = outer.resource_id)
3046: )

Line 3070: FROM ams_act_access_denorm

3066: AND b.status_code = 'ACTIVE'
3067: AND b.party_id = outer.party_id
3068: AND b.party_id = c.party_id
3069: AND NVL(b.ship_to_site_use_id, DECODE((SELECT count(object_id)
3070: FROM ams_act_access_denorm
3071: WHERE object_type = b.plan_type
3072: AND object_id = b.plan_id
3073: AND resource_id = outer.resource_id), 0, 0, c.ship_to_site_use_id)) = c.ship_to_site_use_id
3074: AND

Line 3085: FROM ams_act_access_denorm

3081: (
3082: b.product_level_type IS NULL
3083: AND b.product_id IS NULL
3084: AND EXISTS (SELECT 'X'
3085: FROM ams_act_access_denorm
3086: WHERE object_type = b.plan_type
3087: AND object_id = b.plan_id
3088: AND resource_id = outer.resource_id)
3089: )

Line 3115: FROM ams_act_access_denorm

3111: AND b.party_id = c.party_id
3112: AND b.bill_to_site_use_id = outer.bill_to_site_use_id
3113: AND b.bill_to_site_use_id = c.bill_to_site_use_id
3114: AND NVL(b.ship_to_site_use_id, DECODE((SELECT count(object_id)
3115: FROM ams_act_access_denorm
3116: WHERE object_type = b.plan_type
3117: AND object_id = b.plan_id
3118: AND resource_id = outer.resource_id), 0, 0, c.ship_to_site_use_id)) = c.ship_to_site_use_id
3119: AND

Line 3130: FROM ams_act_access_denorm

3126: (
3127: b.product_level_type IS NULL
3128: AND b.product_id IS NULL
3129: AND EXISTS (SELECT 'X'
3130: FROM ams_act_access_denorm
3131: WHERE object_type = b.plan_type
3132: AND object_id = b.plan_id
3133: AND resource_id = outer.resource_id)
3134: )

Line 3170: FROM ams_act_access_denorm

3166: OR
3167: ( b.product_level_type IS NULL
3168: AND b.product_id IS NULL
3169: AND EXISTS (SELECT 'X'
3170: FROM ams_act_access_denorm
3171: WHERE object_type = b.plan_type
3172: AND object_id = b.plan_id
3173: AND resource_id = outer.resource_id)
3174: )

Line 3195: FROM ams_act_access_denorm

3191: AND b.status_code = 'ACTIVE'
3192: AND b.party_id = c.party_id
3193: AND b.party_id = outer.party_id
3194: AND NVL(b.ship_to_site_use_id, DECODE((SELECT count(object_id)
3195: FROM ams_act_access_denorm
3196: WHERE object_type = b.plan_type
3197: AND object_id = b.plan_id
3198: AND resource_id = outer.resource_id), 0, 0, c.ship_to_site_use_id)) = c.ship_to_site_use_id
3199: AND

Line 3210: FROM ams_act_access_denorm

3206: (
3207: b.product_level_type IS NULL
3208: AND b.product_id IS NULL
3209: AND EXISTS (SELECT 'X'
3210: FROM ams_act_access_denorm
3211: WHERE object_type = b.plan_type
3212: AND object_id = b.plan_id
3213: AND resource_id = outer.resource_id)
3214: )

Line 3237: FROM ams_act_access_denorm

3233: AND b.party_id = c.party_id
3234: AND b.bill_to_site_use_id = outer.bill_to_site_use_id
3235: AND b.bill_to_site_use_id = c.bill_to_site_use_id
3236: AND NVL(b.ship_to_site_use_id, DECODE((SELECT count(object_id)
3237: FROM ams_act_access_denorm
3238: WHERE object_type = b.plan_type
3239: AND object_id = b.plan_id
3240: AND resource_id = outer.resource_id), 0, 0, c.ship_to_site_use_id)) = c.ship_to_site_use_id
3241: AND

Line 3252: FROM ams_act_access_denorm

3248: (
3249: b.product_level_type IS NULL
3250: AND b.product_id IS NULL
3251: AND EXISTS (SELECT 'X'
3252: FROM ams_act_access_denorm
3253: WHERE object_type = b.plan_type
3254: AND object_id = b.plan_id
3255: AND resource_id = outer.resource_id)
3256: )

Line 3289: FROM ams_act_access_denorm

3285: OR
3286: ( b.product_level_type IS NULL
3287: AND b.product_id IS NULL
3288: AND EXISTS (SELECT 'X'
3289: FROM ams_act_access_denorm
3290: WHERE object_type = b.plan_type
3291: AND object_id = b.plan_id
3292: AND resource_id = outer.resource_id)
3293: )

Line 3321: FROM ams_act_access_denorm

3317: AND c.product_attribute = DECODE(b.product_level_type, 'FAMILY','PRICING_ATTRIBUTE2','PRICING_ATTRIBUTE1')
3318: AND b.party_id = c.party_id
3319: AND NVL(b.bill_to_site_use_id, c.bill_to_site_use_id) = c.bill_to_site_use_id
3320: AND NVL(b.ship_to_site_use_id, DECODE((SELECT count(object_id)
3321: FROM ams_act_access_denorm
3322: WHERE object_type = b.plan_type
3323: AND object_id = b.plan_id
3324: AND resource_id = outer.resource_id), 0, 0, c.ship_to_site_use_id)) = c.ship_to_site_use_id
3325: )

Line 3351: FROM ams_act_access_denorm

3347: AND c.product_attribute = DECODE(b.product_level_type, 'FAMILY','PRICING_ATTRIBUTE2','PRICING_ATTRIBUTE1')
3348: AND b.party_id = c.party_id
3349: AND NVL(b.bill_to_site_use_id, c.bill_to_site_use_id) = c.bill_to_site_use_id
3350: AND NVL(b.ship_to_site_use_id, DECODE((SELECT count(object_id)
3351: FROM ams_act_access_denorm
3352: WHERE object_type = b.plan_type
3353: AND object_id = b.plan_id
3354: AND resource_id = outer.resource_id), 0, 0, c.ship_to_site_use_id)) = c.ship_to_site_use_id
3355: )

Line 3381: FROM ams_act_access_denorm

3377: AND c.product_attribute = DECODE(b.product_level_type, 'FAMILY','PRICING_ATTRIBUTE2','PRICING_ATTRIBUTE1')
3378: AND b.party_id = c.party_id
3379: AND NVL(b.bill_to_site_use_id, c.bill_to_site_use_id) = c.bill_to_site_use_id
3380: AND NVL(b.ship_to_site_use_id, DECODE((SELECT count(object_id)
3381: FROM ams_act_access_denorm
3382: WHERE object_type = b.plan_type
3383: AND object_id = b.plan_id
3384: AND resource_id = outer.resource_id), 0, 0, c.ship_to_site_use_id)) = c.ship_to_site_use_id
3385: )

Line 3408: FROM ams_act_access_denorm

3404: AND c.product_attribute = DECODE(b.product_level_type, 'FAMILY','PRICING_ATTRIBUTE2','PRICING_ATTRIBUTE1')
3405: AND b.party_id = c.party_id
3406: AND NVL(b.bill_to_site_use_id, c.bill_to_site_use_id) = c.bill_to_site_use_id
3407: AND NVL(b.ship_to_site_use_id, DECODE((SELECT count(object_id)
3408: FROM ams_act_access_denorm
3409: WHERE object_type = b.plan_type
3410: AND object_id = b.plan_id
3411: AND resource_id = outer.resource_id), 0, 0, c.ship_to_site_use_id)) = c.ship_to_site_use_id
3412: )