APPS.PAP_CMERGE dependencies on PA_DRAFT_INVOICES

Line 892: 'PA_DRAFT_INVOICES_ALL',

888: LAST_UPDATED_BY
889: )
890: (SELECT
891: HZ_CUSTOMER_MERGE_LOG_S.nextval,
892: 'PA_DRAFT_INVOICES_ALL',
893: RACM.CUSTOMER_MERGE_HEADER_ID,
894: PDI.PROJECT_ID,
895: PDI.DRAFT_INVOICE_NUM,
896: PDI.CUSTOMER_ID,

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

901: hz_utility_pub.CREATION_DATE,
902: hz_utility_pub.LAST_UPDATE_LOGIN,
903: hz_utility_pub.LAST_UPDATE_DATE,
904: hz_utility_pub.LAST_UPDATED_BY
905: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
906: CUSTOMER_ID,
907: DUPLICATE_ID
908: FROM RA_CUSTOMER_MERGES
909: WHERE PROCESS_FLAG = 'N'

Line 918: UPDATE pa_draft_invoices PC -- bug 3891382

914: );
915:
916: END IF;
917:
918: UPDATE pa_draft_invoices PC -- bug 3891382
919: SET ( CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
920: FROM RA_CUSTOMER_MERGES RACM
921: WHERE RACM.DUPLICATE_ID = PC.CUSTOMER_ID
922: AND RACM.PROCESS_FLAG = 'N'

Line 952: 'PA_DRAFT_INVOICES_ALL',

948: LAST_UPDATED_BY
949: )
950: (SELECT
951: HZ_CUSTOMER_MERGE_LOG_S.nextval,
952: 'PA_DRAFT_INVOICES_ALL',
953: RACM.CUSTOMER_MERGE_HEADER_ID,
954: PDI.PROJECT_ID,
955: PDI.DRAFT_INVOICE_NUM,
956: PDI.BILL_TO_CUSTOMER_ID,

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

961: hz_utility_pub.CREATION_DATE,
962: hz_utility_pub.LAST_UPDATE_LOGIN,
963: hz_utility_pub.LAST_UPDATE_DATE,
964: hz_utility_pub.LAST_UPDATED_BY
965: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
966: CUSTOMER_ID,
967: DUPLICATE_ID
968: FROM RA_CUSTOMER_MERGES
969: WHERE PROCESS_FLAG = 'N'

Line 978: UPDATE pa_draft_invoices PC -- bug 3891382

974: );
975:
976: END IF;
977:
978: UPDATE pa_draft_invoices PC -- bug 3891382
979: SET ( BILL_TO_CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
980: FROM RA_CUSTOMER_MERGES RACM
981: WHERE RACM.DUPLICATE_ID = PC.BILL_TO_CUSTOMER_ID
982: AND RACM.PROCESS_FLAG = 'N'

Line 1012: 'PA_DRAFT_INVOICES_ALL',

1008: LAST_UPDATED_BY
1009: )
1010: (SELECT
1011: HZ_CUSTOMER_MERGE_LOG_S.nextval,
1012: 'PA_DRAFT_INVOICES_ALL',
1013: RACM.CUSTOMER_MERGE_HEADER_ID,
1014: PDI.PROJECT_ID,
1015: PDI.DRAFT_INVOICE_NUM,
1016: PDI.SHIP_TO_CUSTOMER_ID,

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

1021: hz_utility_pub.CREATION_DATE,
1022: hz_utility_pub.LAST_UPDATE_LOGIN,
1023: hz_utility_pub.LAST_UPDATE_DATE,
1024: hz_utility_pub.LAST_UPDATED_BY
1025: FROM PA_DRAFT_INVOICES PDI,(SELECT DISTINCT CUSTOMER_MERGE_HEADER_ID,
1026: CUSTOMER_ID,
1027: DUPLICATE_ID
1028: FROM RA_CUSTOMER_MERGES
1029: WHERE PROCESS_FLAG = 'N'

Line 1038: UPDATE pa_draft_invoices PC -- bug 3891382

1034: );
1035:
1036: END IF;
1037:
1038: UPDATE pa_draft_invoices PC -- bug 3891382
1039: SET ( SHIP_TO_CUSTOMER_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ID
1040: FROM RA_CUSTOMER_MERGES RACM
1041: WHERE RACM.DUPLICATE_ID = PC.SHIP_TO_CUSTOMER_ID
1042: AND RACM.PROCESS_FLAG = 'N'

Line 1073: 'PA_DRAFT_INVOICES_ALL',

1069: LAST_UPDATED_BY
1070: )
1071: (SELECT
1072: HZ_CUSTOMER_MERGE_LOG_S.nextval,
1073: 'PA_DRAFT_INVOICES_ALL',
1074: RACM.CUSTOMER_MERGE_HEADER_ID,
1075: PDI.PROJECT_ID,
1076: PDI.DRAFT_INVOICE_NUM,
1077: PDI.BILL_TO_ADDRESS_ID,

Line 1086: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM

1082: hz_utility_pub.CREATION_DATE,
1083: hz_utility_pub.LAST_UPDATE_LOGIN,
1084: hz_utility_pub.LAST_UPDATE_DATE,
1085: hz_utility_pub.LAST_UPDATED_BY
1086: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM
1087: WHERE
1088: RACM.DUPLICATE_ADDRESS_ID = PDI.BILL_TO_ADDRESS_ID
1089: AND RACM.PROCESS_FLAG = 'N'
1090: AND RACM.SET_NUMBER = set_no

Line 1096: UPDATE pa_draft_invoices PDI -- bug 3891382

1092: );
1093:
1094: END IF;
1095:
1096: UPDATE pa_draft_invoices PDI -- bug 3891382
1097: SET ( BILL_TO_ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
1098: FROM RA_CUSTOMER_MERGES RACM
1099: WHERE
1100: RACM.DUPLICATE_ADDRESS_ID = PDI.BILL_TO_ADDRESS_ID

Line 1134: 'PA_DRAFT_INVOICES_ALL',

1130: LAST_UPDATED_BY
1131: )
1132: (SELECT
1133: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1134: 'PA_DRAFT_INVOICES_ALL',
1135: RACM.CUSTOMER_MERGE_HEADER_ID,
1136: PDI.PROJECT_ID,
1137: PDI.DRAFT_INVOICE_NUM,
1138: PDI.SHIP_TO_ADDRESS_ID,

Line 1147: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM

1143: hz_utility_pub.CREATION_DATE,
1144: hz_utility_pub.LAST_UPDATE_LOGIN,
1145: hz_utility_pub.LAST_UPDATE_DATE,
1146: hz_utility_pub.LAST_UPDATED_BY
1147: FROM PA_DRAFT_INVOICES PDI,RA_CUSTOMER_MERGES RACM
1148: WHERE
1149: RACM.DUPLICATE_ADDRESS_ID = PDI.SHIP_TO_ADDRESS_ID
1150: AND RACM.PROCESS_FLAG = 'N'
1151: AND RACM.SET_NUMBER = set_no

Line 1157: UPDATE pa_draft_invoices PDI -- bug 3891382

1153: );
1154:
1155: END IF;
1156:
1157: UPDATE pa_draft_invoices PDI -- bug 3891382
1158: SET ( SHIP_TO_ADDRESS_ID ) = ( SELECT DISTINCT RACM.CUSTOMER_ADDRESS_ID
1159: FROM RA_CUSTOMER_MERGES RACM
1160: WHERE
1161: RACM.DUPLICATE_ADDRESS_ID = PDI.SHIP_TO_ADDRESS_ID