APPS.OZF_OM_VALIDATION_PVT dependencies on OE_ORDER_LINES

Line 481: FROM oe_order_lines

477: CURSOR csr_ord_line_price(cv_order_line_id IN NUMBER) IS
478: SELECT inventory_item_id
479: , unit_selling_price
480: , order_quantity_uom
481: FROM oe_order_lines
482: WHERE line_id = cv_order_line_id;
483:
484: i NUMBER;
485:

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'

Line 1391: FROM oe_order_lines

1387:
1388: CURSOR csr_ord_line_quantity(cv_order_line_id IN NUMBER) IS
1389: SELECT ordered_quantity
1390: , inventory_item_id
1391: FROM oe_order_lines
1392: WHERE line_id = cv_order_line_id;
1393:
1394: CURSOR csr_product_name(cv_item_id IN NUMBER, cv_org_id IN NUMBER) IS
1395: SELECT description