DBA Data[Home] [Help]

APPS.WSH_INVOICE_UTILITIES dependencies on RA_INTERFACE_LINES_ALL

Line 118: ' From RA_INTERFACE_LINES_ALL L' ||

114: -- the statement
115: --dbms_output.put_line('Position 21');
116: grp_stmt := 'Select ' || select_col || ' group_cols,' ||
117: ' l.interface_line_attribute3, ROWID ' ||
118: ' From RA_INTERFACE_LINES_ALL L' ||
119: ' Where trx_number is NULL' ||
120: ' And request_id = ' || to_char(x_request_id)||
121: ' Order by ' || group_col_clause ||
122: ' , l.interface_line_attribute3, l.org_id' ;

Line 196: Update RA_INTERFACE_LINES_ALL

192: End if;
193:
194: End if;
195:
196: Update RA_INTERFACE_LINES_ALL
197: set trx_number = inv_num
198: where rowid = chartorowid(this_rowid);
199:
200: End Loop;