DBA Data[Home] [Help]

APPS.OZF_OM_VALIDATION_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 426: FROM ra_customer_trx_lines_all ra,

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:

Line 1306: FROM ra_customer_trx_lines_all

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;