DBA Data[Home] [Help]

APPS.PO_PRICE_HELPER dependencies on PO_HEADERS_ALL

Line 55: -- PO_HEADERS_ALL.type_lookup_code

51: c_ENTITY_TYPE_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_ENTITY_TYPE_LINE;
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';

Line 67: -- PO_HEADERS_ALL.authorization_status

63:
64: -- Retroactive update mode
65: c_ALL_RELEASES CONSTANT VARCHAR2(30) := 'ALL_RELEASES';
66:
67: -- PO_HEADERS_ALL.authorization_status
68: c_INCOMPLETE CONSTANT VARCHAR2(30) := 'INCOMPLETE';
69:
70: -- PO_LINES_ALL.price_break_lookup_code
71: c_NON_CUMULATIVE CONSTANT VARCHAR2(30) := 'NON CUMULATIVE';

Line 376: , PO_HEADERS_ALL HEADER

372: , c_UNIT_PRICE
373: , NULL -- TODO: Get message from PM.
374: FROM
375: PO_LINES_ALL LINE
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

Line 513: , PO_HEADERS_ALL HEADER

509: , l_expense_accrual_code_tbl
510: FROM
511: PO_SESSION_GT SES
512: , PO_LINES_ALL LINE
513: , PO_HEADERS_ALL HEADER
514: , PO_SYSTEM_PARAMETERS_ALL PARAMS
515: WHERE
516: SES.key = l_data_key
517: AND LINE.po_line_id = SES.num1

Line 845: , PO_HEADERS_ALL HEADER

841: , l_price_break_lookup_code_tbl
842: FROM
843: PO_SESSION_GT SES
844: , PO_LINES_ALL LINE
845: , PO_HEADERS_ALL HEADER
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