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 669: FROM OE_ORDER_LINES

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

Line 696: FROM OE_ORDER_LINES

692: SELECT 'Y'
693: INTO l_duplicate_exists
694: FROM DUAL
695: WHERE EXISTS (SELECT 'Y'
696: FROM OE_ORDER_LINES
697: WHERE HEADER_ID <> p_header_id
698: AND SOLD_TO_ORG_ID = p_sold_to_org_id
699: AND CUST_PO_NUMBER = p_cust_po_number );
700: END IF;

Line 995: FROM oe_order_lines_all l

991: CURSOR ib_lines IS
992: SELECT l.line_id,
993: l.ib_current_location,
994: l.ib_installed_at_location
995: FROM oe_order_lines_all l
996: WHERE l.header_id=p_old_header_rec.header_id;
997: --added for bug 3739650
998: l_site_use_code VARCHAR2(30);
999: BEGIN

Line 1294: From Oe_Order_Lines_All

1290: IF l_validate_result = 'N' THEN
1291: Begin
1292: Select 1
1293: into l_temp
1294: From Oe_Order_Lines_All
1295: Where header_id = p_header_rec.header_id
1296: and calculate_price_flag in ('P','N')
1297: and rownum = 1;
1298: