APPS.PO_PRICE_HELPER dependencies on PO_HEADERS_ALL

Line 59: -- PO_HEADERS_ALL.type_lookup_code

55: c_ENTITY_TYPE_LINE CONSTANT VARCHAR2(30) := PO_VALIDATIONS.c_ENTITY_TYPE_LINE;
56:
57: c_UNIT_PRICE CONSTANT VARCHAR2(30) := 'UNIT_PRICE';
58:
59: -- PO_HEADERS_ALL.type_lookup_code
60: c_STANDARD CONSTANT VARCHAR2(10) := 'STANDARD';
61:
62: -- PO_LINES_ALL.order_type_lookup_code
63: c_RATE CONSTANT VARCHAR2(5) := 'RATE';

Line 71: -- PO_HEADERS_ALL.authorization_status

67:
68: -- Retroactive update mode
69: c_ALL_RELEASES CONSTANT VARCHAR2(30) := 'ALL_RELEASES';
70:
71: -- PO_HEADERS_ALL.authorization_status
72: c_INCOMPLETE CONSTANT VARCHAR2(30) := 'INCOMPLETE';
73:
74: -- PO_LINES_ALL.price_break_lookup_code
75: c_NON_CUMULATIVE CONSTANT VARCHAR2(30) := 'NON CUMULATIVE';

Line 409: , PO_HEADERS_ALL HEADER

405: , c_UNIT_PRICE
406: , NULL -- TODO: Get message from PM.
407: FROM
408: PO_LINES_ALL LINE
409: , PO_HEADERS_ALL HEADER
410: WHERE
411: LINE.po_line_id = p_line_id_tbl(i)
412: AND HEADER.po_header_id = LINE.po_header_id
413: AND HEADER.type_lookup_code = c_STANDARD

Line 540: , PO_HEADERS_ALL HEADER

536: , l_expense_accrual_code_tbl
537: FROM
538: PO_SESSION_GT SES
539: , PO_LINES_ALL LINE
540: , PO_HEADERS_ALL HEADER
541: , PO_SYSTEM_PARAMETERS_ALL PARAMS
542: WHERE
543: SES.key = l_data_key
544: AND LINE.po_line_id = SES.num1

Line 849: , PO_HEADERS_ALL HEADER

845: , l_price_break_lookup_code_tbl
846: FROM
847: PO_SESSION_GT SES
848: , PO_LINES_ALL LINE
849: , PO_HEADERS_ALL HEADER
850: WHERE
851: SES.key = l_data_key
852: AND LINE.po_line_id = SES.num1
853: AND HEADER.po_header_id = LINE.po_header_id

Line 1076: FROM po_headers_all ph,

1072: SELECT ph.type_lookup_code,
1073: pl.po_header_id
1074: INTO l_source_document_type,
1075: l_source_document_header_id
1076: FROM po_headers_all ph,
1077: po_lines_all pl
1078: WHERE ph.po_header_id = pl.po_header_id
1079: AND pl.po_line_id = p_po_line_id;
1080: ELSIF (p_contract_id IS NOT NULL) THEN

Line 1085: FROM po_headers_all ph

1081: SELECT ph.type_lookup_code,
1082: ph.po_header_id
1083: INTO l_source_document_type,
1084: l_source_document_header_id
1085: FROM po_headers_all ph
1086: WHERE ph.po_header_id = p_contract_id;
1087: ELSE
1088: l_source_document_type := NULL;
1089: l_source_document_header_id := NULL;