APPS.PO_SERVICES_PVT dependencies on PO_LINES_ALL

Line 36: l_allow_price_override_flag po_lines_all.allow_price_override_flag%TYPE :=

32: -------------------------------------------------------------------------------
33: -------------------------------------------------------------------------------
34: FUNCTION allow_price_override(p_po_line_id NUMBER) RETURN BOOLEAN IS
35:
36: l_allow_price_override_flag po_lines_all.allow_price_override_flag%TYPE :=
37: null;
38:
39: BEGIN
40:

Line 43: FROM po_lines_all

39: BEGIN
40:
41: SELECT allow_price_override_flag
42: INTO l_allow_price_override_flag
43: FROM po_lines_all
44: WHERE po_line_id = p_po_line_id;
45:
46: IF (l_allow_price_override_flag = 'Y') THEN
47: RETURN (TRUE);

Line 504: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;

500: p_po_line_id IN NUMBER
501: )
502: RETURN BOOLEAN
503: IS
504: l_value_basis PO_LINES_ALL.order_type_lookup_code%TYPE;
505:
506: BEGIN
507:
508: IF p_po_line_id is null THEN

Line 514: FROM po_lines_all

510: END IF;
511:
512: SELECT order_type_lookup_code
513: INTO l_value_basis
514: FROM po_lines_all
515: WHERE po_line_id = p_po_line_id;
516:
517: IF ( l_value_basis = 'RATE' )
518: THEN

Line 737: FROM po_lines_all POL,

733: l_count_services_lines := 0;
734:
735: SELECT count(*)
736: INTO l_count_services_lines
737: FROM po_lines_all POL,
738: po_distributions_all POD
739: WHERE POL.po_header_id = p_po_header_id
740: AND POL.order_type_lookup_code IN ('FIXED PRICE', 'RATE')
741: AND POD.po_line_id = POL.po_line_id -- Join between PO Lines and Distributions

Line 796: FROM po_lines_all POL,

792: l_count := 0;
793:
794: SELECT count(*)
795: INTO l_count
796: FROM po_lines_all POL,
797: po_distributions_all POD
798: WHERE POL.po_line_id = p_po_line_id
799: AND POL.order_type_lookup_code = 'FIXED PRICE'
800: AND POL.purchase_basis = 'SERVICES'

Line 858: po_lines_all POL,

854:
855: SELECT count(*)
856: INTO l_count
857: FROM po_line_locations_all POLL,
858: po_lines_all POL,
859: po_distributions_all POD
860: WHERE POLL.line_location_id = p_po_line_location_id
861: AND POL.po_line_id = POLL.po_line_id
862: AND POL.order_type_lookup_code = 'FIXED PRICE'