[Home] [Help]
181: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
182: WHERE BILL_TO_CUSTOMER_ID = NUM_COL1_ORIG_LIST(I)
183: AND BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);
184:
185: --FII_AR_AGING_DISPUTES
186: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
187: UPDATE FII_AR_AGING_DISPUTES yt
188: SET BILL_TO_CUSTOMER_ID = NUM_COL1_NEW_LIST(I),
189: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
183: AND BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);
184:
185: --FII_AR_AGING_DISPUTES
186: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
187: UPDATE FII_AR_AGING_DISPUTES yt
188: SET BILL_TO_CUSTOMER_ID = NUM_COL1_NEW_LIST(I),
189: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
190: WHERE BILL_TO_CUSTOMER_ID = NUM_COL1_ORIG_LIST(I)
191: AND BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);