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 PA_DRAFT_INVOICES

Line 924: 'PA_DRAFT_INVOICES_ALL',

920: LAST_UPDATED_BY
921: )
922: (SELECT
923: HZ_CUSTOMER_MERGE_LOG_S.nextval,
924: 'PA_DRAFT_INVOICES_ALL',
925: RACM.CUSTOMER_MERGE_HEADER_ID,
926: PDI.PROJECT_ID,
927: PDI.DRAFT_INVOICE_NUM,
928: PDI.CUSTOMER_ID,

Line 937: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

933: hz_utility_pub.CREATION_DATE,
934: hz_utility_pub.LAST_UPDATE_LOGIN,
935: hz_utility_pub.LAST_UPDATE_DATE,
936: hz_utility_pub.LAST_UPDATED_BY
937: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
938: CUSTOMER_ID,
939: DUPLICATE_ID
940: FROM RA_CUSTOMER_MERGES
941: WHERE PROCESS_FLAG = 'N'

Line 950: UPDATE pa_draft_invoices PC -- bug 3891382

946: );
947:
948: END IF;
949:
950: UPDATE pa_draft_invoices PC -- bug 3891382
951: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
952: FROM RA_CUSTOMER_MERGES RACM
953: WHERE RACM.DUPLICATE_ID = PC.CUSTOMER_ID
954: AND RACM.PROCESS_FLAG = 'N'

Line 984: 'PA_DRAFT_INVOICES_ALL',

980: LAST_UPDATED_BY
981: )
982: (SELECT
983: HZ_CUSTOMER_MERGE_LOG_S.nextval,
984: 'PA_DRAFT_INVOICES_ALL',
985: RACM.CUSTOMER_MERGE_HEADER_ID,
986: PDI.PROJECT_ID,
987: PDI.DRAFT_INVOICE_NUM,
988: PDI.BILL_TO_CUSTOMER_ID,

Line 997: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

993: hz_utility_pub.CREATION_DATE,
994: hz_utility_pub.LAST_UPDATE_LOGIN,
995: hz_utility_pub.LAST_UPDATE_DATE,
996: hz_utility_pub.LAST_UPDATED_BY
997: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
998: CUSTOMER_ID,
999: DUPLICATE_ID
1000: FROM RA_CUSTOMER_MERGES
1001: WHERE PROCESS_FLAG = 'N'

Line 1010: UPDATE pa_draft_invoices PC -- bug 3891382

1006: );
1007:
1008: END IF;
1009:
1010: UPDATE pa_draft_invoices PC -- bug 3891382
1011: SET ( BILL_TO_CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1012: FROM RA_CUSTOMER_MERGES RACM
1013: WHERE RACM.DUPLICATE_ID = PC.BILL_TO_CUSTOMER_ID
1014: AND RACM.PROCESS_FLAG = 'N'

Line 1044: 'PA_DRAFT_INVOICES_ALL',

1040: LAST_UPDATED_BY
1041: )
1042: (SELECT
1043: HZ_CUSTOMER_MERGE_LOG_S.nextval,
1044: 'PA_DRAFT_INVOICES_ALL',
1045: RACM.CUSTOMER_MERGE_HEADER_ID,
1046: PDI.PROJECT_ID,
1047: PDI.DRAFT_INVOICE_NUM,
1048: PDI.SHIP_TO_CUSTOMER_ID,

Line 1057: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,

1053: hz_utility_pub.CREATION_DATE,
1054: hz_utility_pub.LAST_UPDATE_LOGIN,
1055: hz_utility_pub.LAST_UPDATE_DATE,
1056: hz_utility_pub.LAST_UPDATED_BY
1057: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1058: CUSTOMER_ID,
1059: DUPLICATE_ID
1060: FROM RA_CUSTOMER_MERGES
1061: WHERE PROCESS_FLAG = 'N'

Line 1070: UPDATE pa_draft_invoices PC -- bug 3891382

1066: );
1067:
1068: END IF;
1069:
1070: UPDATE pa_draft_invoices PC -- bug 3891382
1071: SET ( SHIP_TO_CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1072: FROM RA_CUSTOMER_MERGES RACM
1073: WHERE RACM.DUPLICATE_ID = PC.SHIP_TO_CUSTOMER_ID
1074: AND RACM.PROCESS_FLAG = 'N'

Line 1105: 'PA_DRAFT_INVOICES_ALL',

1101: LAST_UPDATED_BY
1102: )
1103: (SELECT
1104: HZ_CUSTOMER_MERGE_LOG_S.nextval,
1105: 'PA_DRAFT_INVOICES_ALL',
1106: RACM.CUSTOMER_MERGE_HEADER_ID,
1107: PDI.PROJECT_ID,
1108: PDI.DRAFT_INVOICE_NUM,
1109: PDI.BILL_TO_ADDRESS_ID,

Line 1118: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM

1114: hz_utility_pub.CREATION_DATE,
1115: hz_utility_pub.LAST_UPDATE_LOGIN,
1116: hz_utility_pub.LAST_UPDATE_DATE,
1117: hz_utility_pub.LAST_UPDATED_BY
1118: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM
1119: WHERE
1120: RACM.DUPLICATE_ADDRESS_ID = PDI.BILL_TO_ADDRESS_ID
1121: AND RACM.DUPLICATE_ID = PDI.BILL_TO_CUSTOMER_ID /* for bug 11842127 */
1122: AND RACM.PROCESS_FLAG = 'N'

Line 1129: UPDATE pa_draft_invoices PDI -- bug 3891382

1125: );
1126:
1127: END IF;
1128:
1129: UPDATE pa_draft_invoices PDI -- bug 3891382
1130: SET ( BILL_TO_ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
1131: FROM RA_CUSTOMER_MERGES RACM
1132: WHERE
1133: RACM.DUPLICATE_ADDRESS_ID = PDI.BILL_TO_ADDRESS_ID

Line 1169: 'PA_DRAFT_INVOICES_ALL',

1165: LAST_UPDATED_BY
1166: )
1167: (SELECT
1168: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1169: 'PA_DRAFT_INVOICES_ALL',
1170: RACM.CUSTOMER_MERGE_HEADER_ID,
1171: PDI.PROJECT_ID,
1172: PDI.DRAFT_INVOICE_NUM,
1173: PDI.SHIP_TO_ADDRESS_ID,

Line 1182: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM

1178: hz_utility_pub.CREATION_DATE,
1179: hz_utility_pub.LAST_UPDATE_LOGIN,
1180: hz_utility_pub.LAST_UPDATE_DATE,
1181: hz_utility_pub.LAST_UPDATED_BY
1182: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM
1183: WHERE
1184: RACM.DUPLICATE_ADDRESS_ID = PDI.SHIP_TO_ADDRESS_ID
1185: AND RACM.DUPLICATE_ID = PDI.SHIP_TO_CUSTOMER_ID /* for bug 11842127 */
1186: AND RACM.PROCESS_FLAG = 'N'

Line 1193: UPDATE pa_draft_invoices PDI -- bug 3891382

1189: );
1190:
1191: END IF;
1192:
1193: UPDATE pa_draft_invoices PDI -- bug 3891382
1194: SET ( SHIP_TO_ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
1195: FROM RA_CUSTOMER_MERGES RACM
1196: WHERE
1197: RACM.DUPLICATE_ADDRESS_ID = PDI.SHIP_TO_ADDRESS_ID