APPS.CN_CUST_MERGE_PVT dependencies on CN_COMM_LINES_API_ALL

Line 266: FROM CN_COMM_LINES_API_ALL yt, ra_customer_merges m

262: ,yt.COMM_LINES_API_ID
263: ,yt.CUSTOMER_ID
264: ,yt.BILL_TO_ADDRESS_ID
265: ,yt.SHIP_TO_ADDRESS_ID
266: FROM CN_COMM_LINES_API_ALL yt, ra_customer_merges m
267: WHERE (
268: yt.CUSTOMER_ID = m.DUPLICATE_ID
269: OR ((yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID)
270: AND

Line 413: UPDATE CN_COMM_LINES_API_ALL yt SET

409: );
410:
411: END IF;
412: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
413: UPDATE CN_COMM_LINES_API_ALL yt SET
414: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
415: ,BILL_TO_ADDRESS_ID=NUM_COL2_NEW_LIST(I)
416: ,SHIP_TO_ADDRESS_ID=NUM_COL3_NEW_LIST(I)
417: , LAST_UPDATE_DATE=SYSDATE