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.OE_CUST_MERGE dependencies on OE_LINE_ACKS

Line 2922: from oe_line_acks

2918: Process_Mode IN VARCHAR2)
2919: IS
2920: CURSOR c1 is
2921: select line_id
2922: from oe_line_acks
2923: where ship_to_org_id in
2924: (select m.duplicate_site_id
2925: from ra_customer_merges m
2926: where m.process_flag = 'N'

Line 2935: from oe_line_acks

2931:
2932:
2933: CURSOR c2 is
2934: select line_id
2935: from oe_line_acks
2936: where invoice_to_org_id in
2937: (select m.duplicate_site_id
2938: from ra_customer_merges m
2939: where m.process_flag = 'N'

Line 2948: from oe_line_acks

2944:
2945:
2946: CURSOR c3 is
2947: select line_id
2948: from oe_line_acks
2949: where deliver_to_org_id in
2950: (select m.duplicate_site_id
2951: from ra_customer_merges m
2952: where m.process_flag = 'N'

Line 2961: from oe_line_acks

2957:
2958:
2959: CURSOR c4 is
2960: select line_id
2961: from oe_line_acks
2962: where intmed_ship_to_org_id in
2963: (select m.duplicate_site_id
2964: from ra_customer_merges m
2965: where m.process_flag = 'N'

Line 2974: from oe_line_acks a, oe_order_lines l

2970:
2971: CURSOR c5 is
2972: --changed for bug 3196900
2973: select a.line_id
2974: from oe_line_acks a, oe_order_lines l
2975: where a.sold_to_org_id in
2976: (select m.duplicate_id
2977: from ra_customer_merges m
2978: where m.process_flag = 'N'

Line 2988: from oe_line_acks

2984: for update nowait;
2985:
2986: CURSOR c6 is
2987: select line_id
2988: from oe_line_acks
2989: where end_customer_site_use_id in
2990: (select m.duplicate_id
2991: from ra_customer_merges m
2992: where m.process_flag = 'N'

Line 3001: from oe_line_acks a,oe_order_lines l

2997:
2998: CURSOR c7 is
2999: --changed for bug 3196900
3000: select a.line_id
3001: from oe_line_acks a,oe_order_lines l
3002: where a.end_customer_id in
3003: (select m.duplicate_id
3004: from ra_customer_merges m
3005: where m.process_flag = 'N'

Line 3023: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );

3019:
3020: IF( process_mode = 'LOCK' ) THEN
3021:
3022: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
3023: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3024:
3025: open c1;
3026: close c1;
3027:

Line 3070: 'OE_LINE_ACKS',

3066: LAST_UPDATED_BY
3067: )
3068: select
3069: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3070: 'OE_LINE_ACKS',
3071: m.CUSTOMER_MERGE_HEADER_ID,
3072: a.ORIG_SYS_DOCUMENT_REF,
3073: a.ORIG_SYS_LINE_REF,
3074: a.ship_to_org_id,

Line 3083: from oe_line_acks a,

3079: hz_utility_pub.CREATION_DATE,
3080: hz_utility_pub.LAST_UPDATE_LOGIN,
3081: hz_utility_pub.LAST_UPDATE_DATE,
3082: hz_utility_pub.LAST_UPDATED_BY
3083: from oe_line_acks a,
3084: ra_customer_merges m
3085: where m.process_flag = 'N'
3086: and a.ship_to_org_id = m.duplicate_site_id
3087: and m.request_id = req_id

Line 3094: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );

3090: end if;
3091:
3092: /* site level update */
3093: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3094: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3095:
3096: UPDATE oe_line_acks a
3097: set ship_to_org_id = (select distinct m.customer_site_id
3098: from ra_customer_merges m

Line 3096: UPDATE oe_line_acks a

3092: /* site level update */
3093: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3094: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3095:
3096: UPDATE oe_line_acks a
3097: set ship_to_org_id = (select distinct m.customer_site_id
3098: from ra_customer_merges m
3099: where a.ship_to_org_id = m.duplicate_site_id
3100: and m.request_id = req_id

Line 3139: 'OE_LINE_ACKS',

3135: LAST_UPDATED_BY
3136: )
3137: select
3138: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3139: 'OE_LINE_ACKS',
3140: m.CUSTOMER_MERGE_HEADER_ID,
3141: a.ORIG_SYS_DOCUMENT_REF,
3142: a.ORIG_SYS_LINE_REF,
3143: a.invoice_to_org_id,

Line 3152: from oe_line_acks a,

3148: hz_utility_pub.CREATION_DATE,
3149: hz_utility_pub.LAST_UPDATE_LOGIN,
3150: hz_utility_pub.LAST_UPDATE_DATE,
3151: hz_utility_pub.LAST_UPDATED_BY
3152: from oe_line_acks a,
3153: ra_customer_merges m
3154: where m.process_flag = 'N'
3155: and a.invoice_to_org_id = m.duplicate_site_id
3156: and m.request_id = req_id

Line 3162: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );

3158: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
3159: end if;
3160:
3161: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3162: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3163:
3164: UPDATE oe_line_acks a
3165: set invoice_to_org_id = (select distinct m.customer_site_id
3166: from ra_customer_merges m

Line 3164: UPDATE oe_line_acks a

3160:
3161: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3162: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3163:
3164: UPDATE oe_line_acks a
3165: set invoice_to_org_id = (select distinct m.customer_site_id
3166: from ra_customer_merges m
3167: where a.invoice_to_org_id = m.duplicate_site_id
3168: and m.request_id = req_id

Line 3207: 'OE_LINE_ACKS',

3203: LAST_UPDATED_BY
3204: )
3205: select
3206: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3207: 'OE_LINE_ACKS',
3208: m.CUSTOMER_MERGE_HEADER_ID,
3209: a.ORIG_SYS_DOCUMENT_REF,
3210: a.ORIG_SYS_LINE_REF,
3211: a.deliver_to_org_id,

Line 3220: from oe_line_acks a,

3216: hz_utility_pub.CREATION_DATE,
3217: hz_utility_pub.LAST_UPDATE_LOGIN,
3218: hz_utility_pub.LAST_UPDATE_DATE,
3219: hz_utility_pub.LAST_UPDATED_BY
3220: from oe_line_acks a,
3221: ra_customer_merges m
3222: where m.process_flag = 'N'
3223: and a.deliver_to_org_id = m.duplicate_site_id
3224: and m.request_id = req_id

Line 3230: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );

3226: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
3227: end if;
3228:
3229: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3230: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3231:
3232: UPDATE oe_line_acks a
3233: set deliver_to_org_id = (select distinct m.customer_site_id
3234: from ra_customer_merges m

Line 3232: UPDATE oe_line_acks a

3228:
3229: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3230: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3231:
3232: UPDATE oe_line_acks a
3233: set deliver_to_org_id = (select distinct m.customer_site_id
3234: from ra_customer_merges m
3235: where a.deliver_to_org_id = m.duplicate_site_id
3236: and m.request_id = req_id

Line 3275: 'OE_LINE_ACKS',

3271: LAST_UPDATED_BY
3272: )
3273: select
3274: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3275: 'OE_LINE_ACKS',
3276: m.CUSTOMER_MERGE_HEADER_ID,
3277: a.ORIG_SYS_DOCUMENT_REF,
3278: a.ORIG_SYS_LINE_REF,
3279: a.intmed_ship_to_org_id,

Line 3288: from oe_line_acks a,

3284: hz_utility_pub.CREATION_DATE,
3285: hz_utility_pub.LAST_UPDATE_LOGIN,
3286: hz_utility_pub.LAST_UPDATE_DATE,
3287: hz_utility_pub.LAST_UPDATED_BY
3288: from oe_line_acks a,
3289: ra_customer_merges m
3290: where m.process_flag = 'N'
3291: and a.intmed_ship_to_org_id = m.duplicate_site_id
3292: and m.request_id = req_id

Line 3298: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );

3294: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
3295: end if;
3296:
3297: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3298: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3299:
3300:
3301: UPDATE oe_line_acks a
3302: set intmed_ship_to_org_id = (select distinct m.customer_site_id

Line 3301: UPDATE oe_line_acks a

3297: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3298: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3299:
3300:
3301: UPDATE oe_line_acks a
3302: set intmed_ship_to_org_id = (select distinct m.customer_site_id
3303: from ra_customer_merges m
3304: where a.intmed_ship_to_org_id = m.duplicate_site_id
3305: and m.request_id = req_id

Line 3327: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );

3323: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
3324: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
3325:
3326: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3327: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3328:
3329:
3330: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3331: insert into HZ_CUSTOMER_MERGE_LOG (

Line 3349: 'OE_LINE_ACKS',

3345: LAST_UPDATED_BY
3346: )
3347: select
3348: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3349: 'OE_LINE_ACKS',
3350: m.CUSTOMER_MERGE_HEADER_ID,
3351: a.ORIG_SYS_DOCUMENT_REF,
3352: a.ORIG_SYS_LINE_REF,
3353: a.sold_to_org_id,

Line 3362: from oe_line_acks a,

3358: hz_utility_pub.CREATION_DATE,
3359: hz_utility_pub.LAST_UPDATE_LOGIN,
3360: hz_utility_pub.LAST_UPDATE_DATE,
3361: hz_utility_pub.LAST_UPDATED_BY
3362: from oe_line_acks a,
3363: ra_customer_merges m
3364: where m.process_flag = 'N'
3365: and a.sold_to_org_id = m.duplicate_site_id
3366: and m.request_id = req_id

Line 3373: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );

3369: end if;
3370:
3371: /* customer level update */
3372: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3373: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3374:
3375: UPDATE oe_line_acks a
3376: set sold_to_org_id = (select distinct m.customer_id
3377: from ra_customer_merges m

Line 3375: UPDATE oe_line_acks a

3371: /* customer level update */
3372: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3373: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3374:
3375: UPDATE oe_line_acks a
3376: set sold_to_org_id = (select distinct m.customer_id
3377: from ra_customer_merges m
3378: where a.sold_to_org_id = m.duplicate_id
3379: and m.process_flag = 'N'

Line 3404: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );

3400: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
3401: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
3402:
3403: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3404: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3405:
3406:
3407: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3408: insert into HZ_CUSTOMER_MERGE_LOG (

Line 3426: 'OE_LINE_ACKS',

3422: LAST_UPDATED_BY
3423: )
3424: select
3425: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3426: 'OE_LINE_ACKS',
3427: m.CUSTOMER_MERGE_HEADER_ID,
3428: a.ORIG_SYS_DOCUMENT_REF,
3429: a.ORIG_SYS_LINE_REF,
3430: a.end_customer_site_use_id,

Line 3439: from oe_line_acks a,

3435: hz_utility_pub.CREATION_DATE,
3436: hz_utility_pub.LAST_UPDATE_LOGIN,
3437: hz_utility_pub.LAST_UPDATE_DATE,
3438: hz_utility_pub.LAST_UPDATED_BY
3439: from oe_line_acks a,
3440: ra_customer_merges m
3441: where m.process_flag = 'N'
3442: and a.sold_to_org_id = m.duplicate_site_id
3443: and m.request_id = req_id

Line 3450: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );

3446: end if;
3447:
3448: /* customer level update */
3449: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3450: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3451:
3452: UPDATE oe_line_acks a
3453: set end_customer_site_use_id = (select distinct m.customer_id
3454: from ra_customer_merges m

Line 3452: UPDATE oe_line_acks a

3448: /* customer level update */
3449: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3450: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3451:
3452: UPDATE oe_line_acks a
3453: set end_customer_site_use_id = (select distinct m.customer_id
3454: from ra_customer_merges m
3455: where a.end_customer_site_use_id = m.duplicate_id
3456: and m.process_flag = 'N'

Line 3479: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );

3475: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
3476: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
3477:
3478: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3479: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3480:
3481:
3482: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3483: insert into HZ_CUSTOMER_MERGE_LOG (

Line 3501: 'OE_LINE_ACKS',

3497: LAST_UPDATED_BY
3498: )
3499: select
3500: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3501: 'OE_LINE_ACKS',
3502: m.CUSTOMER_MERGE_HEADER_ID,
3503: a.ORIG_SYS_DOCUMENT_REF,
3504: a.ORIG_SYS_LINE_REF,
3505: a.end_customer_id,

Line 3514: from oe_line_acks a,

3510: hz_utility_pub.CREATION_DATE,
3511: hz_utility_pub.LAST_UPDATE_LOGIN,
3512: hz_utility_pub.LAST_UPDATE_DATE,
3513: hz_utility_pub.LAST_UPDATED_BY
3514: from oe_line_acks a,
3515: ra_customer_merges m
3516: where m.process_flag = 'N'
3517: and a.end_customer_id = m.duplicate_site_id
3518: and m.request_id = req_id

Line 3525: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );

3521: end if;
3522:
3523: /* customer level update */
3524: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3525: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3526:
3527: UPDATE oe_line_acks a
3528: set end_customer_id = (select distinct m.customer_id
3529: from ra_customer_merges m

Line 3527: UPDATE oe_line_acks a

3523: /* customer level update */
3524: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3525: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3526:
3527: UPDATE oe_line_acks a
3528: set end_customer_id = (select distinct m.customer_id
3529: from ra_customer_merges m
3530: where a.end_customer_id = m.duplicate_id
3531: and m.process_flag = 'N'