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 ARP_STANDARD

Line 621: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

617: AND RACM.PROCESS_FLAG = 'N'
618: AND RACM.SET_NUMBER = set_no
619: AND RACM.CUSTOMER_SITE_CODE = 'BILL_TO' ),
620: LAST_UPDATE_DATE = SYSDATE,
621: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
622: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
623: WHERE
624: PC.BILL_TO_ADDRESS_ID IN ( SELECT DISTINCT RACM.DUPLICATE_ADDRESS_ID
625: FROM RA_CUSTOMER_MERGES RACM

Line 622: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

618: AND RACM.SET_NUMBER = set_no
619: AND RACM.CUSTOMER_SITE_CODE = 'BILL_TO' ),
620: LAST_UPDATE_DATE = SYSDATE,
621: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
622: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
623: WHERE
624: PC.BILL_TO_ADDRESS_ID IN ( SELECT DISTINCT RACM.DUPLICATE_ADDRESS_ID
625: FROM RA_CUSTOMER_MERGES RACM
626: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id /*CACR*/

Line 687: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

683: AND RACM.PROCESS_FLAG = 'N'
684: AND RACM.SET_NUMBER = set_no
685: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),
686: LAST_UPDATE_DATE = SYSDATE,
687: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
688: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
689: WHERE
690: PC.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
691: FROM RA_CUSTOMER_MERGES RACM

Line 688: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

684: AND RACM.SET_NUMBER = set_no
685: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),
686: LAST_UPDATE_DATE = SYSDATE,
687: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
688: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
689: WHERE
690: PC.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
691: FROM RA_CUSTOMER_MERGES RACM
692: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id /*CACR*/

Line 750: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

746: WHERE RACM.DUPLICATE_ID = var_bill_to_cust_id
747: AND RACM.PROCESS_FLAG = 'N'
748: AND RACM.SET_NUMBER = set_no ),
749: LAST_UPDATE_DATE = SYSDATE,
750: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
751: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
752: WHERE
753: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
754: WHERE RACM.DUPLICATE_ID = PC.BILL_TO_CUSTOMER_ID

Line 751: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

747: AND RACM.PROCESS_FLAG = 'N'
748: AND RACM.SET_NUMBER = set_no ),
749: LAST_UPDATE_DATE = SYSDATE,
750: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
751: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
752: WHERE
753: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
754: WHERE RACM.DUPLICATE_ID = PC.BILL_TO_CUSTOMER_ID
755: AND RACM.PROCESS_FLAG = 'N'

Line 809: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

805: WHERE RACM.DUPLICATE_ID = var_ship_to_cust_id
806: AND RACM.PROCESS_FLAG = 'N'
807: AND RACM.SET_NUMBER = set_no ),
808: LAST_UPDATE_DATE = SYSDATE,
809: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
810: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
811: WHERE
812: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
813: WHERE RACM.DUPLICATE_ID = PC.SHIP_TO_CUSTOMER_ID

Line 810: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

806: AND RACM.PROCESS_FLAG = 'N'
807: AND RACM.SET_NUMBER = set_no ),
808: LAST_UPDATE_DATE = SYSDATE,
809: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
810: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
811: WHERE
812: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
813: WHERE RACM.DUPLICATE_ID = PC.SHIP_TO_CUSTOMER_ID
814: AND RACM.PROCESS_FLAG = 'N'

Line 872: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

868: WHERE RACM.DUPLICATE_ID = var_customer_id
869: AND RACM.PROCESS_FLAG = 'N'
870: AND RACM.SET_NUMBER = set_no ),
871: LAST_UPDATE_DATE = SYSDATE,
872: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
873: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
874: WHERE
875: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
876: WHERE RACM.DUPLICATE_ID = PC.CUSTOMER_ID

Line 873: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

869: AND RACM.PROCESS_FLAG = 'N'
870: AND RACM.SET_NUMBER = set_no ),
871: LAST_UPDATE_DATE = SYSDATE,
872: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
873: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
874: WHERE
875: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
876: WHERE RACM.DUPLICATE_ID = PC.CUSTOMER_ID
877: AND RACM.PROCESS_FLAG = 'N'

Line 957: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

953: WHERE RACM.DUPLICATE_ID = PC.CUSTOMER_ID
954: AND RACM.PROCESS_FLAG = 'N'
955: AND RACM.SET_NUMBER = set_no ),
956: LAST_UPDATE_DATE = SYSDATE,
957: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
958: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
959: WHERE
960: PC.CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
961: WHERE RACM.PROCESS_FLAG = 'N'

Line 958: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

954: AND RACM.PROCESS_FLAG = 'N'
955: AND RACM.SET_NUMBER = set_no ),
956: LAST_UPDATE_DATE = SYSDATE,
957: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
958: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
959: WHERE
960: PC.CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
961: WHERE RACM.PROCESS_FLAG = 'N'
962: AND RACM.SET_NUMBER = set_no );

Line 1017: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

1013: WHERE RACM.DUPLICATE_ID = PC.BILL_TO_CUSTOMER_ID
1014: AND RACM.PROCESS_FLAG = 'N'
1015: AND RACM.SET_NUMBER = set_no ),
1016: LAST_UPDATE_DATE = SYSDATE,
1017: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1018: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1019: WHERE
1020: PC.BILL_TO_CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
1021: WHERE RACM.PROCESS_FLAG = 'N'

Line 1018: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

1014: AND RACM.PROCESS_FLAG = 'N'
1015: AND RACM.SET_NUMBER = set_no ),
1016: LAST_UPDATE_DATE = SYSDATE,
1017: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1018: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1019: WHERE
1020: PC.BILL_TO_CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
1021: WHERE RACM.PROCESS_FLAG = 'N'
1022: AND RACM.SET_NUMBER = set_no );

Line 1077: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

1073: WHERE RACM.DUPLICATE_ID = PC.SHIP_TO_CUSTOMER_ID
1074: AND RACM.PROCESS_FLAG = 'N'
1075: AND RACM.SET_NUMBER = set_no ),
1076: LAST_UPDATE_DATE = SYSDATE,
1077: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1078: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1079: WHERE
1080: PC.SHIP_TO_CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
1081: WHERE RACM.PROCESS_FLAG = 'N'

Line 1078: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

1074: AND RACM.PROCESS_FLAG = 'N'
1075: AND RACM.SET_NUMBER = set_no ),
1076: LAST_UPDATE_DATE = SYSDATE,
1077: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1078: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1079: WHERE
1080: PC.SHIP_TO_CUSTOMER_ID IN ( SELECT DUPLICATE_ID FROM RA_CUSTOMER_MERGES RACM
1081: WHERE RACM.PROCESS_FLAG = 'N'
1082: AND RACM.SET_NUMBER = set_no );

Line 1139: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

1135: AND RACM.PROCESS_FLAG = 'N'
1136: AND RACM.SET_NUMBER = set_no
1137: AND RACM.CUSTOMER_SITE_CODE = 'BILL_TO' ),
1138: LAST_UPDATE_DATE = SYSDATE,
1139: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1140: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1141: WHERE
1142: (PDI.BILL_TO_CUSTOMER_ID,PDI.BILL_TO_ADDRESS_ID) IN /* for bug 11842127 */
1143: ( SELECT RACM.DUPLICATE_ID,RACM.DUPLICATE_ADDRESS_ID

Line 1140: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

1136: AND RACM.SET_NUMBER = set_no
1137: AND RACM.CUSTOMER_SITE_CODE = 'BILL_TO' ),
1138: LAST_UPDATE_DATE = SYSDATE,
1139: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1140: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1141: WHERE
1142: (PDI.BILL_TO_CUSTOMER_ID,PDI.BILL_TO_ADDRESS_ID) IN /* for bug 11842127 */
1143: ( SELECT RACM.DUPLICATE_ID,RACM.DUPLICATE_ADDRESS_ID
1144: FROM RA_CUSTOMER_MERGES RACM

Line 1203: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

1199: AND RACM.PROCESS_FLAG = 'N'
1200: AND RACM.SET_NUMBER = set_no
1201: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),
1202: LAST_UPDATE_DATE = SYSDATE,
1203: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1204: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1205: WHERE
1206: (PDI.SHIP_TO_CUSTOMER_ID,PDI.SHIP_TO_ADDRESS_ID) IN /* for bug 11842127 */
1207: ( SELECT RACM.DUPLICATE_ID,RACM.DUPLICATE_ADDRESS_ID

Line 1204: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

1200: AND RACM.SET_NUMBER = set_no
1201: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),
1202: LAST_UPDATE_DATE = SYSDATE,
1203: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1204: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1205: WHERE
1206: (PDI.SHIP_TO_CUSTOMER_ID,PDI.SHIP_TO_ADDRESS_ID) IN /* for bug 11842127 */
1207: ( SELECT RACM.DUPLICATE_ID,RACM.DUPLICATE_ADDRESS_ID
1208: FROM RA_CUSTOMER_MERGES RACM

Line 1268: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

1264: AND RACM.PROCESS_FLAG = 'N'
1265: AND RACM.SET_NUMBER = set_no
1266: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),
1267: LAST_UPDATE_DATE = SYSDATE,
1268: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1269: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1270: WHERE
1271: PDII.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1272: FROM RA_CUSTOMER_MERGES RACM

Line 1269: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

1265: AND RACM.SET_NUMBER = set_no
1266: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),
1267: LAST_UPDATE_DATE = SYSDATE,
1268: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1269: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1270: WHERE
1271: PDII.SHIP_TO_ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1272: FROM RA_CUSTOMER_MERGES RACM
1273: WHERE RACM.PROCESS_FLAG = 'N'

Line 1339: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

1335: AND RACM.PROCESS_FLAG = 'N'
1336: AND RACM.SET_NUMBER = set_no
1337: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),
1338: LAST_UPDATE_DATE = SYSDATE,
1339: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1340: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1341: WHERE
1342: PT.ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1343: FROM RA_CUSTOMER_MERGES RACM

Line 1340: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

1336: AND RACM.SET_NUMBER = set_no
1337: AND RACM.CUSTOMER_SITE_CODE = 'SHIP_TO' ),
1338: LAST_UPDATE_DATE = SYSDATE,
1339: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1340: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1341: WHERE
1342: PT.ADDRESS_ID IN ( SELECT RACM.DUPLICATE_ADDRESS_ID
1343: FROM RA_CUSTOMER_MERGES RACM
1344: WHERE RACM.PROCESS_FLAG = 'N'

Line 1409: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,

1405: WHERE RACM.DUPLICATE_ID = PI.CUSTOMER_ID
1406: AND RACM.PROCESS_FLAG = 'N'
1407: AND RACM.SET_NUMBER = set_no ),
1408: LAST_UPDATE_DATE = SYSDATE,
1409: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1410: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1411: WHERE
1412: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1413: WHERE RACM.DUPLICATE_ID = PI.CUSTOMER_ID

Line 1410: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN

1406: AND RACM.PROCESS_FLAG = 'N'
1407: AND RACM.SET_NUMBER = set_no ),
1408: LAST_UPDATE_DATE = SYSDATE,
1409: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID,
1410: LAST_UPDATE_LOGIN = ARP_STANDARD.PROFILE.LAST_UPDATE_LOGIN
1411: WHERE
1412: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1413: WHERE RACM.DUPLICATE_ID = PI.CUSTOMER_ID
1414: AND RACM.PROCESS_FLAG = 'N'

Line 1484: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID

1480: WHERE RACM.DUPLICATE_ID = PR.CUSTOMER_ID
1481: AND RACM.PROCESS_FLAG = 'N'
1482: AND RACM.SET_NUMBER = set_no ),
1483: LAST_UPDATE_DATE = SYSDATE,
1484: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID
1485: WHERE
1486: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1487: WHERE RACM.DUPLICATE_ID = PR.CUSTOMER_ID
1488: AND RACM.PROCESS_FLAG = 'N'

Line 1562: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID

1558: WHERE RACM.DUPLICATE_ID = PB.CUSTOMER_ID
1559: AND RACM.PROCESS_FLAG = 'N'
1560: AND RACM.SET_NUMBER = set_no ),
1561: LAST_UPDATE_DATE = SYSDATE,
1562: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID
1563: WHERE
1564: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1565: WHERE RACM.DUPLICATE_ID = PB.CUSTOMER_ID
1566: AND RACM.PROCESS_FLAG = 'N'

Line 1643: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID

1639: WHERE RACM.DUPLICATE_ID = PS.CUSTOMER_ID
1640: AND RACM.PROCESS_FLAG = 'N'
1641: AND RACM.SET_NUMBER = set_no ),
1642: LAST_UPDATE_DATE = SYSDATE,
1643: LAST_UPDATED_BY = ARP_STANDARD.PROFILE.USER_ID
1644: WHERE
1645: EXISTS ( SELECT NULL FROM RA_CUSTOMER_MERGES RACM
1646: WHERE RACM.DUPLICATE_ID = PS.CUSTOMER_ID
1647: AND RACM.PROCESS_FLAG = 'N'