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 1220: FROM oe_order_lines_all

1216: WHERE customer_trx_id = cv_customer_trx_id;
1217:
1218: CURSOR csr_ord_total_quantity(cv_header_id IN NUMBER) IS
1219: SELECT ordered_quantity
1220: FROM oe_order_lines_all
1221: WHERE header_id = cv_header_id;
1222:
1223: CURSOR csr_ord_return_quantity(cv_header_id IN NUMBER, cv_line_id NUMBER) IS
1224: SELECT sum(nvl(ordered_quantity, 0))

Line 1225: FROM oe_order_lines_all

1221: WHERE header_id = cv_header_id;
1222:
1223: CURSOR csr_ord_return_quantity(cv_header_id IN NUMBER, cv_line_id NUMBER) IS
1224: SELECT sum(nvl(ordered_quantity, 0))
1225: FROM oe_order_lines_all
1226: WHERE reference_header_id = cv_header_id
1227: AND reference_line_id = cv_line_id
1228: AND booked_flag = 'Y'
1229: AND cancelled_flag <> 'Y'