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.PAP_CMERGE dependencies on STANDARD

Line 589: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

585: AND RACM.PROCESS_FLAG = 'N'
586: AND RACM.SET_NUMBER = set_no
587: AND RACM.CUSTOMER_SITE_CODE = 'BILL_TO' ),
588: LAST_UPDATE_DATE = SYSDATE,
589: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
590: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
591: WHERE
592: PC.BILL_TO_ADDRESS_ID IN ( SELECT DISTINCT RACM.DUPLICATE_ADDRESS_ID
593: FROM RA_CUSTOMER_MERGES RACM

Line 590: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

586: AND RACM.SET_NUMBER = set_no
587: AND RACM.CUSTOMER_SITE_CODE = 'BILL_TO' ),
588: LAST_UPDATE_DATE = SYSDATE,
589: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
590: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
591: WHERE
592: PC.BILL_TO_ADDRESS_ID IN ( SELECT DISTINCT RACM.DUPLICATE_ADDRESS_ID
593: FROM RA_CUSTOMER_MERGES RACM
594: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/

Line 655: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

651: AND RACM.PROCESS_FLAG = 'N'
652: AND RACM.SET_NUMBER = set_no
653: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),
654: LAST_UPDATE_DATE = SYSDATE,
655: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
656: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
657: WHERE
658: PC.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
659: FROM RA_CUSTOMER_MERGES RACM

Line 656: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

652: AND RACM.SET_NUMBER = set_no
653: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),
654: LAST_UPDATE_DATE = SYSDATE,
655: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
656: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
657: WHERE
658: PC.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
659: FROM RA_CUSTOMER_MERGES RACM
660: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/

Line 718: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

714: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id
715: AND RACM.PROCESS_FLAG = 'N'
716: AND RACM.SET_NUMBER = set_no ),
717: LAST_UPDATE_DATE = SYSDATE,
718: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
719: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
720: WHERE
721: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
722: WHERE RACM.DUPLICATE_ID = PC.BILL_TO_CUSTOMER_ID

Line 719: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

715: AND RACM.PROCESS_FLAG = 'N'
716: AND RACM.SET_NUMBER = set_no ),
717: LAST_UPDATE_DATE = SYSDATE,
718: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
719: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
720: WHERE
721: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
722: WHERE RACM.DUPLICATE_ID = PC.BILL_TO_CUSTOMER_ID
723: AND RACM.PROCESS_FLAG = 'N'

Line 777: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

773: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id
774: AND RACM.PROCESS_FLAG = 'N'
775: AND RACM.SET_NUMBER = set_no ),
776: LAST_UPDATE_DATE = SYSDATE,
777: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
778: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
779: WHERE
780: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
781: WHERE RACM.DUPLICATE_ID = PC.SHIP_TO_CUSTOMER_ID

Line 778: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

774: AND RACM.PROCESS_FLAG = 'N'
775: AND RACM.SET_NUMBER = set_no ),
776: LAST_UPDATE_DATE = SYSDATE,
777: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
778: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
779: WHERE
780: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
781: WHERE RACM.DUPLICATE_ID = PC.SHIP_TO_CUSTOMER_ID
782: AND RACM.PROCESS_FLAG = 'N'

Line 840: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

836: WHERE RACM.DUPLICATE_ID = var_customer_id
837: AND RACM.PROCESS_FLAG = 'N'
838: AND RACM.SET_NUMBER = set_no ),
839: LAST_UPDATE_DATE = SYSDATE,
840: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
841: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
842: WHERE
843: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
844: WHERE RACM.DUPLICATE_ID = PC.CUSTOMER_ID

Line 841: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

837: AND RACM.PROCESS_FLAG = 'N'
838: AND RACM.SET_NUMBER = set_no ),
839: LAST_UPDATE_DATE = SYSDATE,
840: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
841: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
842: WHERE
843: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
844: WHERE RACM.DUPLICATE_ID = PC.CUSTOMER_ID
845: AND RACM.PROCESS_FLAG = 'N'

Line 925: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

921: WHERE RACM.DUPLICATE_ID = PC.CUSTOMER_ID
922: AND RACM.PROCESS_FLAG = 'N'
923: AND RACM.SET_NUMBER = set_no ),
924: LAST_UPDATE_DATE = SYSDATE,
925: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
926: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
927: WHERE
928: PC.CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
929: WHERE RACM.PROCESS_FLAG = 'N'

Line 926: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

922: AND RACM.PROCESS_FLAG = 'N'
923: AND RACM.SET_NUMBER = set_no ),
924: LAST_UPDATE_DATE = SYSDATE,
925: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
926: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
927: WHERE
928: PC.CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
929: WHERE RACM.PROCESS_FLAG = 'N'
930: AND RACM.SET_NUMBER = set_no );

Line 985: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

981: WHERE RACM.DUPLICATE_ID = PC.BILL_TO_CUSTOMER_ID
982: AND RACM.PROCESS_FLAG = 'N'
983: AND RACM.SET_NUMBER = set_no ),
984: LAST_UPDATE_DATE = SYSDATE,
985: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
986: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
987: WHERE
988: PC.BILL_TO_CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
989: WHERE RACM.PROCESS_FLAG = 'N'

Line 986: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

982: AND RACM.PROCESS_FLAG = 'N'
983: AND RACM.SET_NUMBER = set_no ),
984: LAST_UPDATE_DATE = SYSDATE,
985: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
986: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
987: WHERE
988: PC.BILL_TO_CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
989: WHERE RACM.PROCESS_FLAG = 'N'
990: AND RACM.SET_NUMBER = set_no );

Line 1045: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

1041: WHERE RACM.DUPLICATE_ID = PC.SHIP_TO_CUSTOMER_ID
1042: AND RACM.PROCESS_FLAG = 'N'
1043: AND RACM.SET_NUMBER = set_no ),
1044: LAST_UPDATE_DATE = SYSDATE,
1045: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1046: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1047: WHERE
1048: PC.SHIP_TO_CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
1049: WHERE RACM.PROCESS_FLAG = 'N'

Line 1046: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

1042: AND RACM.PROCESS_FLAG = 'N'
1043: AND RACM.SET_NUMBER = set_no ),
1044: LAST_UPDATE_DATE = SYSDATE,
1045: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1046: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1047: WHERE
1048: PC.SHIP_TO_CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
1049: WHERE RACM.PROCESS_FLAG = 'N'
1050: AND RACM.SET_NUMBER = set_no );

Line 1105: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

1101: AND RACM.PROCESS_FLAG = 'N'
1102: AND RACM.SET_NUMBER = set_no
1103: AND RACM.CUSTOMER_SITE_CODE = 'BILL_TO' ),
1104: LAST_UPDATE_DATE = SYSDATE,
1105: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1106: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1107: WHERE
1108: PDI.BILL_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1109: FROM RA_CUSTOMER_MERGES RACM

Line 1106: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

1102: AND RACM.SET_NUMBER = set_no
1103: AND RACM.CUSTOMER_SITE_CODE = 'BILL_TO' ),
1104: LAST_UPDATE_DATE = SYSDATE,
1105: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1106: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1107: WHERE
1108: PDI.BILL_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1109: FROM RA_CUSTOMER_MERGES RACM
1110: WHERE RACM.PROCESS_FLAG = 'N'

Line 1166: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

1162: AND RACM.PROCESS_FLAG = 'N'
1163: AND RACM.SET_NUMBER = set_no
1164: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),
1165: LAST_UPDATE_DATE = SYSDATE,
1166: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1167: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1168: WHERE
1169: PDI.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1170: FROM RA_CUSTOMER_MERGES RACM

Line 1167: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

1163: AND RACM.SET_NUMBER = set_no
1164: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),
1165: LAST_UPDATE_DATE = SYSDATE,
1166: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1167: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1168: WHERE
1169: PDI.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1170: FROM RA_CUSTOMER_MERGES RACM
1171: WHERE RACM.PROCESS_FLAG = 'N'

Line 1230: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

1226: AND RACM.PROCESS_FLAG = 'N'
1227: AND RACM.SET_NUMBER = set_no
1228: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),
1229: LAST_UPDATE_DATE = SYSDATE,
1230: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1231: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1232: WHERE
1233: PDII.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1234: FROM RA_CUSTOMER_MERGES RACM

Line 1231: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

1227: AND RACM.SET_NUMBER = set_no
1228: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),
1229: LAST_UPDATE_DATE = SYSDATE,
1230: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1231: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1232: WHERE
1233: PDII.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1234: FROM RA_CUSTOMER_MERGES RACM
1235: WHERE RACM.PROCESS_FLAG = 'N'

Line 1301: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

1297: AND RACM.PROCESS_FLAG = 'N'
1298: AND RACM.SET_NUMBER = set_no
1299: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),
1300: LAST_UPDATE_DATE = SYSDATE,
1301: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1302: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1303: WHERE
1304: PT.ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1305: FROM RA_CUSTOMER_MERGES RACM

Line 1302: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

1298: AND RACM.SET_NUMBER = set_no
1299: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),
1300: LAST_UPDATE_DATE = SYSDATE,
1301: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1302: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1303: WHERE
1304: PT.ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1305: FROM RA_CUSTOMER_MERGES RACM
1306: WHERE RACM.PROCESS_FLAG = 'N'

Line 1371: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

1367: WHERE RACM.DUPLICATE_ID = PI.CUSTOMER_ID
1368: AND RACM.PROCESS_FLAG = 'N'
1369: AND RACM.SET_NUMBER = set_no ),
1370: LAST_UPDATE_DATE = SYSDATE,
1371: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1372: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1373: WHERE
1374: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1375: WHERE RACM.DUPLICATE_ID = PI.CUSTOMER_ID

Line 1372: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

1368: AND RACM.PROCESS_FLAG = 'N'
1369: AND RACM.SET_NUMBER = set_no ),
1370: LAST_UPDATE_DATE = SYSDATE,
1371: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1372: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1373: WHERE
1374: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1375: WHERE RACM.DUPLICATE_ID = PI.CUSTOMER_ID
1376: AND RACM.PROCESS_FLAG = 'N'

Line 1446: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID

1442: WHERE RACM.DUPLICATE_ID = PR.CUSTOMER_ID
1443: AND RACM.PROCESS_FLAG = 'N'
1444: AND RACM.SET_NUMBER = set_no ),
1445: LAST_UPDATE_DATE = SYSDATE,
1446: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID
1447: WHERE
1448: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1449: WHERE RACM.DUPLICATE_ID = PR.CUSTOMER_ID
1450: AND RACM.PROCESS_FLAG = 'N'

Line 1524: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID

1520: WHERE RACM.DUPLICATE_ID = PB.CUSTOMER_ID
1521: AND RACM.PROCESS_FLAG = 'N'
1522: AND RACM.SET_NUMBER = set_no ),
1523: LAST_UPDATE_DATE = SYSDATE,
1524: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID
1525: WHERE
1526: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1527: WHERE RACM.DUPLICATE_ID = PB.CUSTOMER_ID
1528: AND RACM.PROCESS_FLAG = 'N'

Line 1605: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID

1601: WHERE RACM.DUPLICATE_ID = PS.CUSTOMER_ID
1602: AND RACM.PROCESS_FLAG = 'N'
1603: AND RACM.SET_NUMBER = set_no ),
1604: LAST_UPDATE_DATE = SYSDATE,
1605: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID
1606: WHERE
1607: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1608: WHERE RACM.DUPLICATE_ID = PS.CUSTOMER_ID
1609: AND RACM.PROCESS_FLAG = 'N'