APPS.OE_VALIDATE_HEADER dependencies on OE_ORDER_LINES

Line 479: FROM oe_order_lines

475: L_COMMITMENT_CURR_CODE VARCHAR2(15);
476:
477: CURSOR l_line_csr IS
478: SELECT commitment_id
479: FROM oe_order_lines
480: WHERE header_id = p_header_id
481: AND commitment_id is not null;
482:
483: BEGIN

Line 547: FROM oe_order_lines

543: l_exists VARCHAR2(1) := 'N';
544:
545: CURSOR l_line_csr IS
546: SELECT commitment_id
547: FROM oe_order_lines
548: WHERE header_id = p_header_id
549: AND commitment_id is not null;
550:
551: Cursor cur_customer_relations (p_commitment_id IN NUMBER) is

Line 667: FROM OE_ORDER_LINES

663: WHERE HEADER_ID <> p_header_id
664: AND SOLD_TO_ORG_ID = p_sold_to_org_id
665: AND CUST_PO_NUMBER = p_cust_po_number )
666: OR EXISTS (SELECT 'Y'
667: FROM OE_ORDER_LINES
668: WHERE HEADER_ID <> p_header_id
669: AND SOLD_TO_ORG_ID = p_sold_to_org_id
670: AND CUST_PO_NUMBER = p_cust_po_number );
671: else

Line 964: FROM oe_order_lines_all l

960: CURSOR ib_lines IS
961: SELECT l.line_id,
962: l.ib_current_location,
963: l.ib_installed_at_location
964: FROM oe_order_lines_all l
965: WHERE l.header_id=p_old_header_rec.header_id;
966: --added for bug 3739650
967: l_site_use_code VARCHAR2(30);
968: BEGIN

Line 1226: From Oe_Order_Lines_All

1222: IF l_validate_result = 'N' THEN
1223: Begin
1224: Select 1
1225: into l_temp
1226: From Oe_Order_Lines_All
1227: Where header_id = p_header_rec.header_id
1228: and calculate_price_flag in ('P','N')
1229: and rownum = 1;
1230: