eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OM_VALIDATION_PVT dependencies on OE_ORDER_LINES_ALL

Line 427: oe_order_lines_all ol

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:
431: i NUMBER;

Line 1282: FROM oe_order_lines_all

1278: WHERE customer_trx_id = cv_customer_trx_id;
1279:
1280: CURSOR csr_ord_total_quantity(cv_header_id IN NUMBER) IS
1281: SELECT ordered_quantity
1282: FROM oe_order_lines_all
1283: WHERE header_id = cv_header_id;
1284:
1285: CURSOR csr_ord_return_quantity(cv_header_id IN NUMBER, cv_line_id NUMBER) IS
1286: SELECT sum(nvl(ordered_quantity, 0))

Line 1287: FROM oe_order_lines_all

1283: WHERE header_id = cv_header_id;
1284:
1285: CURSOR csr_ord_return_quantity(cv_header_id IN NUMBER, cv_line_id NUMBER) IS
1286: SELECT sum(nvl(ordered_quantity, 0))
1287: FROM oe_order_lines_all
1288: WHERE reference_header_id = cv_header_id
1289: AND reference_line_id = cv_line_id
1290: AND booked_flag = 'Y'
1291: AND cancelled_flag <> 'Y'