APPS.OZF_OM_VALIDATION_PVT dependencies on RA_CUSTOMER_TRX_LINES

Line 418: FROM ra_customer_trx_lines

414: CURSOR csr_inv_line_price(cv_customer_trx_line_id IN NUMBER) IS
415: SELECT inventory_item_id
416: , unit_selling_price
417: , uom_code
418: FROM ra_customer_trx_lines
419: WHERE customer_trx_line_id = cv_customer_trx_line_id;
420:
421: --Added for bug 7680032
422: CURSOR csr_om_line_price(cv_customer_trx_line_id NUMBER) IS

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;

Line 1447: FROM ra_customer_trx_lines

1443:
1444: CURSOR csr_inv_line_quantity(cv_invoice_line_id IN NUMBER) IS
1445: SELECT quantity_invoiced
1446: , inventory_item_id
1447: FROM ra_customer_trx_lines
1448: WHERE customer_trx_line_id = cv_invoice_line_id;
1449:
1450: CURSOR csr_ord_line_quantity(cv_order_line_id IN NUMBER) IS
1451: SELECT ordered_quantity