[Home] [Help]
165: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
166: WHERE BILL_TO_CUSTOMER_ID = NUM_COL1_ORIG_LIST(I)
167: AND BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);
168:
169: --FII_AR_AGING_RECEIVABLES
170: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
171: UPDATE FII_AR_AGING_RECEIVABLES yt
172: SET BILL_TO_CUSTOMER_ID = NUM_COL1_NEW_LIST(I),
173: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
167: AND BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);
168:
169: --FII_AR_AGING_RECEIVABLES
170: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
171: UPDATE FII_AR_AGING_RECEIVABLES yt
172: SET BILL_TO_CUSTOMER_ID = NUM_COL1_NEW_LIST(I),
173: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
174: WHERE BILL_TO_CUSTOMER_ID = NUM_COL1_ORIG_LIST(I)
175: AND BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);