DBA Data[Home] [Help]

APPS.PO_PRICE_HELPER dependencies on STANDARD

Line 56: c_STANDARD CONSTANT VARCHAR2(10) := 'STANDARD';

52:
53: c_UNIT_PRICE CONSTANT VARCHAR2(30) := 'UNIT_PRICE';
54:
55: -- PO_HEADERS_ALL.type_lookup_code
56: c_STANDARD CONSTANT VARCHAR2(10) := 'STANDARD';
57:
58: -- PO_LINES_ALL.order_type_lookup_code
59: c_RATE CONSTANT VARCHAR2(5) := 'RATE';
60:

Line 380: AND HEADER.type_lookup_code = c_STANDARD

376: , PO_HEADERS_ALL HEADER
377: WHERE
378: LINE.po_line_id = p_line_id_tbl(i)
379: AND HEADER.po_header_id = LINE.po_header_id
380: AND HEADER.type_lookup_code = c_STANDARD
381: AND LINE.order_type_lookup_code <> c_RATE
382: AND EXISTS
383: ( SELECT NULL
384: FROM PO_DISTRIBUTIONS_ALL DIST

Line 519: AND HEADER.type_lookup_code = c_STANDARD

515: WHERE
516: SES.key = l_data_key
517: AND LINE.po_line_id = SES.num1
518: AND HEADER.po_header_id = LINE.po_header_id
519: AND HEADER.type_lookup_code = c_STANDARD
520: AND PARAMS.org_id = HEADER.org_id
521: ;
522:
523: d_position := 100;

Line 850: AND HEADER.type_lookup_code = c_STANDARD

846: WHERE
847: SES.key = l_data_key
848: AND LINE.po_line_id = SES.num1
849: AND HEADER.po_header_id = LINE.po_header_id
850: AND HEADER.type_lookup_code = c_STANDARD
851: AND HEADER.authorization_status <> c_INCOMPLETE
852: AND (SES.char1 IS NULL OR SES.char1 = c_NON_CUMULATIVE)
853: ;
854: