422: CURSOR csr_om_line_price(cv_customer_trx_line_id NUMBER) IS
423: SELECT ra.inventory_item_id
424: , ol.unit_selling_price
425: , ra.uom_code
426: FROM ra_customer_trx_lines_all ra,
427: oe_order_lines_all ol
428: WHERE ra.customer_trx_line_id = cv_customer_trx_line_id
429: AND ra.interface_line_attribute6 = ol.line_id;
430:
1302: WHERE order_number = cv_customer_trx;
1303:
1304: CURSOR csr_inv_line_id(cv_line_id IN NUMBER) IS
1305: SELECT interface_line_attribute6
1306: FROM ra_customer_trx_lines_all
1307: WHERE customer_trx_line_id = cv_line_id;
1308:
1309: l_reference_header varchar(20);
1310: l_total_order_quantity NUMBER;