DBA Data[Home] [Help]

APPS.OZF_OM_VALIDATION_PVT dependencies on RA_CUSTOMER_TRX_LINES

Line 409: FROM ra_customer_trx_lines

405: CURSOR csr_inv_line_price(cv_customer_trx_line_id IN NUMBER) IS
406: SELECT inventory_item_id
407: , unit_selling_price
408: , uom_code
409: FROM ra_customer_trx_lines
410: WHERE customer_trx_line_id = cv_customer_trx_line_id;
411:
412: i NUMBER;
413:

Line 1244: FROM ra_customer_trx_lines_all

1240: WHERE order_number = cv_customer_trx;
1241:
1242: CURSOR csr_inv_line_id(cv_line_id IN NUMBER) IS
1243: SELECT interface_line_attribute6
1244: FROM ra_customer_trx_lines_all
1245: WHERE customer_trx_line_id = cv_line_id;
1246:
1247: l_reference_header varchar(20);
1248: l_total_order_quantity NUMBER;

Line 1385: FROM ra_customer_trx_lines

1381:
1382: CURSOR csr_inv_line_quantity(cv_invoice_line_id IN NUMBER) IS
1383: SELECT quantity_invoiced
1384: , inventory_item_id
1385: FROM ra_customer_trx_lines
1386: WHERE customer_trx_line_id = cv_invoice_line_id;
1387:
1388: CURSOR csr_ord_line_quantity(cv_order_line_id IN NUMBER) IS
1389: SELECT ordered_quantity