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 3461: from oe_line_acks

3457: Process_Mode IN VARCHAR2)
3458: IS
3459: CURSOR c1 is
3460: select line_id
3461: from oe_line_acks
3462: where ship_to_org_id in
3463: (select m.duplicate_site_id
3464: from ra_customer_merges m
3465: where m.process_flag = 'N'

Line 3474: from oe_line_acks

3470:
3471:
3472: CURSOR c2 is
3473: select line_id
3474: from oe_line_acks
3475: where invoice_to_org_id in
3476: (select m.duplicate_site_id
3477: from ra_customer_merges m
3478: where m.process_flag = 'N'

Line 3487: from oe_line_acks

3483:
3484:
3485: CURSOR c3 is
3486: select line_id
3487: from oe_line_acks
3488: where deliver_to_org_id in
3489: (select m.duplicate_site_id
3490: from ra_customer_merges m
3491: where m.process_flag = 'N'

Line 3500: from oe_line_acks

3496:
3497:
3498: CURSOR c4 is
3499: select line_id
3500: from oe_line_acks
3501: where intmed_ship_to_org_id in
3502: (select m.duplicate_site_id
3503: from ra_customer_merges m
3504: where m.process_flag = 'N'

Line 3513: from oe_line_acks a, oe_order_lines l

3509:
3510: CURSOR c5 is
3511: --changed for bug 3196900
3512: select a.line_id
3513: from oe_line_acks a, oe_order_lines l
3514: where a.sold_to_org_id in
3515: (select m.duplicate_id
3516: from ra_customer_merges m
3517: where m.process_flag = 'N'

Line 3527: from oe_line_acks

3523: for update nowait;
3524:
3525: CURSOR c6 is
3526: select line_id
3527: from oe_line_acks
3528: where end_customer_site_use_id in
3529: (select m.duplicate_id
3530: from ra_customer_merges m
3531: where m.process_flag = 'N'

Line 3540: from oe_line_acks a,oe_order_lines l

3536:
3537: CURSOR c7 is
3538: --changed for bug 3196900
3539: select a.line_id
3540: from oe_line_acks a,oe_order_lines l
3541: where a.end_customer_id in
3542: (select m.duplicate_id
3543: from ra_customer_merges m
3544: where m.process_flag = 'N'

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

3558:
3559: IF( process_mode = 'LOCK' ) THEN
3560:
3561: arp_message.set_name( 'AR', 'AR_LOCKING_TABLE');
3562: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3563:
3564: open c1;
3565: close c1;
3566:

Line 3609: 'OE_LINE_ACKS',

3605: LAST_UPDATED_BY
3606: )
3607: select
3608: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3609: 'OE_LINE_ACKS',
3610: m.CUSTOMER_MERGE_HEADER_ID,
3611: a.ORIG_SYS_DOCUMENT_REF,
3612: a.ORIG_SYS_LINE_REF,
3613: a.ship_to_org_id,

Line 3622: from oe_line_acks a,

3618: hz_utility_pub.CREATION_DATE,
3619: hz_utility_pub.LAST_UPDATE_LOGIN,
3620: hz_utility_pub.LAST_UPDATE_DATE,
3621: hz_utility_pub.LAST_UPDATED_BY
3622: from oe_line_acks a,
3623: ra_customer_merges m
3624: where m.process_flag = 'N'
3625: and a.ship_to_org_id = m.duplicate_site_id
3626: and m.request_id = req_id

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

3629: end if;
3630:
3631: /* site level update */
3632: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3633: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3634:
3635: UPDATE oe_line_acks a
3636: set ship_to_org_id = (select distinct m.customer_site_id
3637: from ra_customer_merges m

Line 3635: UPDATE oe_line_acks a

3631: /* site level update */
3632: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3633: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3634:
3635: UPDATE oe_line_acks a
3636: set ship_to_org_id = (select distinct m.customer_site_id
3637: from ra_customer_merges m
3638: where a.ship_to_org_id = m.duplicate_site_id
3639: and m.request_id = req_id

Line 3678: 'OE_LINE_ACKS',

3674: LAST_UPDATED_BY
3675: )
3676: select
3677: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3678: 'OE_LINE_ACKS',
3679: m.CUSTOMER_MERGE_HEADER_ID,
3680: a.ORIG_SYS_DOCUMENT_REF,
3681: a.ORIG_SYS_LINE_REF,
3682: a.invoice_to_org_id,

Line 3691: from oe_line_acks a,

3687: hz_utility_pub.CREATION_DATE,
3688: hz_utility_pub.LAST_UPDATE_LOGIN,
3689: hz_utility_pub.LAST_UPDATE_DATE,
3690: hz_utility_pub.LAST_UPDATED_BY
3691: from oe_line_acks a,
3692: ra_customer_merges m
3693: where m.process_flag = 'N'
3694: and a.invoice_to_org_id = m.duplicate_site_id
3695: and m.request_id = req_id

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

3697: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
3698: end if;
3699:
3700: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3701: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3702:
3703: UPDATE oe_line_acks a
3704: set invoice_to_org_id = (select distinct m.customer_site_id
3705: from ra_customer_merges m

Line 3703: UPDATE oe_line_acks a

3699:
3700: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3701: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3702:
3703: UPDATE oe_line_acks a
3704: set invoice_to_org_id = (select distinct m.customer_site_id
3705: from ra_customer_merges m
3706: where a.invoice_to_org_id = m.duplicate_site_id
3707: and m.request_id = req_id

Line 3746: 'OE_LINE_ACKS',

3742: LAST_UPDATED_BY
3743: )
3744: select
3745: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3746: 'OE_LINE_ACKS',
3747: m.CUSTOMER_MERGE_HEADER_ID,
3748: a.ORIG_SYS_DOCUMENT_REF,
3749: a.ORIG_SYS_LINE_REF,
3750: a.deliver_to_org_id,

Line 3759: from oe_line_acks a,

3755: hz_utility_pub.CREATION_DATE,
3756: hz_utility_pub.LAST_UPDATE_LOGIN,
3757: hz_utility_pub.LAST_UPDATE_DATE,
3758: hz_utility_pub.LAST_UPDATED_BY
3759: from oe_line_acks a,
3760: ra_customer_merges m
3761: where m.process_flag = 'N'
3762: and a.deliver_to_org_id = m.duplicate_site_id
3763: and m.request_id = req_id

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

3765: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
3766: end if;
3767:
3768: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3769: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3770:
3771: UPDATE oe_line_acks a
3772: set deliver_to_org_id = (select distinct m.customer_site_id
3773: from ra_customer_merges m

Line 3771: UPDATE oe_line_acks a

3767:
3768: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3769: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3770:
3771: UPDATE oe_line_acks a
3772: set deliver_to_org_id = (select distinct m.customer_site_id
3773: from ra_customer_merges m
3774: where a.deliver_to_org_id = m.duplicate_site_id
3775: and m.request_id = req_id

Line 3814: 'OE_LINE_ACKS',

3810: LAST_UPDATED_BY
3811: )
3812: select
3813: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3814: 'OE_LINE_ACKS',
3815: m.CUSTOMER_MERGE_HEADER_ID,
3816: a.ORIG_SYS_DOCUMENT_REF,
3817: a.ORIG_SYS_LINE_REF,
3818: a.intmed_ship_to_org_id,

Line 3827: from oe_line_acks a,

3823: hz_utility_pub.CREATION_DATE,
3824: hz_utility_pub.LAST_UPDATE_LOGIN,
3825: hz_utility_pub.LAST_UPDATE_DATE,
3826: hz_utility_pub.LAST_UPDATED_BY
3827: from oe_line_acks a,
3828: ra_customer_merges m
3829: where m.process_flag = 'N'
3830: and a.intmed_ship_to_org_id = m.duplicate_site_id
3831: and m.request_id = req_id

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

3833: and NVL(ACKNOWLEDGMENT_FLAG,'N') <> 'Y';
3834: end if;
3835:
3836: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3837: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3838:
3839:
3840: UPDATE oe_line_acks a
3841: set intmed_ship_to_org_id = (select distinct m.customer_site_id

Line 3840: UPDATE oe_line_acks a

3836: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3837: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3838:
3839:
3840: UPDATE oe_line_acks a
3841: set intmed_ship_to_org_id = (select distinct m.customer_site_id
3842: from ra_customer_merges m
3843: where a.intmed_ship_to_org_id = m.duplicate_site_id
3844: and m.request_id = req_id

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

3862: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
3863: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
3864:
3865: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3866: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3867:
3868:
3869: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3870: insert into HZ_CUSTOMER_MERGE_LOG (

Line 3888: 'OE_LINE_ACKS',

3884: LAST_UPDATED_BY
3885: )
3886: select
3887: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3888: 'OE_LINE_ACKS',
3889: m.CUSTOMER_MERGE_HEADER_ID,
3890: a.ORIG_SYS_DOCUMENT_REF,
3891: a.ORIG_SYS_LINE_REF,
3892: a.sold_to_org_id,

Line 3901: from oe_line_acks a,

3897: hz_utility_pub.CREATION_DATE,
3898: hz_utility_pub.LAST_UPDATE_LOGIN,
3899: hz_utility_pub.LAST_UPDATE_DATE,
3900: hz_utility_pub.LAST_UPDATED_BY
3901: from oe_line_acks a,
3902: ra_customer_merges m
3903: where m.process_flag = 'N'
3904: and a.sold_to_org_id = m.duplicate_site_id
3905: and m.request_id = req_id

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

3908: end if;
3909:
3910: /* customer level update */
3911: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3912: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3913:
3914: UPDATE oe_line_acks a
3915: set sold_to_org_id = (select distinct m.customer_id
3916: from ra_customer_merges m

Line 3914: UPDATE oe_line_acks a

3910: /* customer level update */
3911: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3912: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3913:
3914: UPDATE oe_line_acks a
3915: set sold_to_org_id = (select distinct m.customer_id
3916: from ra_customer_merges m
3917: where a.sold_to_org_id = m.duplicate_id
3918: and m.process_flag = 'N'

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

3939: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
3940: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
3941:
3942: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3943: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3944:
3945:
3946: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
3947: insert into HZ_CUSTOMER_MERGE_LOG (

Line 3965: 'OE_LINE_ACKS',

3961: LAST_UPDATED_BY
3962: )
3963: select
3964: HZ_CUSTOMER_MERGE_LOG_s.nextval,
3965: 'OE_LINE_ACKS',
3966: m.CUSTOMER_MERGE_HEADER_ID,
3967: a.ORIG_SYS_DOCUMENT_REF,
3968: a.ORIG_SYS_LINE_REF,
3969: a.end_customer_site_use_id,

Line 3978: from oe_line_acks a,

3974: hz_utility_pub.CREATION_DATE,
3975: hz_utility_pub.LAST_UPDATE_LOGIN,
3976: hz_utility_pub.LAST_UPDATE_DATE,
3977: hz_utility_pub.LAST_UPDATED_BY
3978: from oe_line_acks a,
3979: ra_customer_merges m
3980: where m.process_flag = 'N'
3981: and a.sold_to_org_id = m.duplicate_site_id
3982: and m.request_id = req_id

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

3985: end if;
3986:
3987: /* customer level update */
3988: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3989: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3990:
3991: UPDATE oe_line_acks a
3992: set end_customer_site_use_id = (select distinct m.customer_id
3993: from ra_customer_merges m

Line 3991: UPDATE oe_line_acks a

3987: /* customer level update */
3988: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
3989: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
3990:
3991: UPDATE oe_line_acks a
3992: set end_customer_site_use_id = (select distinct m.customer_id
3993: from ra_customer_merges m
3994: where a.end_customer_site_use_id = m.duplicate_id
3995: and m.process_flag = 'N'

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

4014: arp_message.set_name( 'AR', 'AR_ROWS_UPDATED' );
4015: arp_message.set_token( 'NUM_ROWS', to_char(g_count) );
4016:
4017: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4018: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
4019:
4020:
4021: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
4022: insert into HZ_CUSTOMER_MERGE_LOG (

Line 4040: 'OE_LINE_ACKS',

4036: LAST_UPDATED_BY
4037: )
4038: select
4039: HZ_CUSTOMER_MERGE_LOG_s.nextval,
4040: 'OE_LINE_ACKS',
4041: m.CUSTOMER_MERGE_HEADER_ID,
4042: a.ORIG_SYS_DOCUMENT_REF,
4043: a.ORIG_SYS_LINE_REF,
4044: a.end_customer_id,

Line 4053: from oe_line_acks a,

4049: hz_utility_pub.CREATION_DATE,
4050: hz_utility_pub.LAST_UPDATE_LOGIN,
4051: hz_utility_pub.LAST_UPDATE_DATE,
4052: hz_utility_pub.LAST_UPDATED_BY
4053: from oe_line_acks a,
4054: ra_customer_merges m
4055: where m.process_flag = 'N'
4056: and a.end_customer_id = m.duplicate_id ---replaced duplicate_site_id by duplicate_id bug 13058344
4057: and m.request_id = req_id

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

4060: end if;
4061:
4062: /* customer level update */
4063: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4064: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
4065:
4066: UPDATE oe_line_acks a
4067: set end_customer_id = (select distinct m.customer_id
4068: from ra_customer_merges m

Line 4066: UPDATE oe_line_acks a

4062: /* customer level update */
4063: arp_message.set_name( 'AR', 'AR_UPDATING_TABLE');
4064: arp_message.set_token( 'TABLE_NAME', 'oe_line_acks', FALSE );
4065:
4066: UPDATE oe_line_acks a
4067: set end_customer_id = (select distinct m.customer_id
4068: from ra_customer_merges m
4069: where a.end_customer_id = m.duplicate_id
4070: and m.process_flag = 'N'