APPS.PO_PRICE_HELPER dependencies on PO_LINES_ALL

Line 62: -- PO_LINES_ALL.order_type_lookup_code

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';
64:
65: -- RCV_TRANSACTIONS_INTERFACE.transaction_status_code
66: c_PENDING CONSTANT VARCHAR2(10) := 'PENDING';

Line 74: -- PO_LINES_ALL.price_break_lookup_code

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';
76:
77: -------------------------------------------------------------------------------
78: --Start of Comments

Line 408: PO_LINES_ALL LINE

404: , p_line_id_tbl(i)
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

Line 539: , PO_LINES_ALL LINE

535: , l_type_lookup_code_tbl
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

Line 848: , PO_LINES_ALL LINE

844: l_line_id_tbl
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

Line 1077: po_lines_all pl

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
1081: SELECT ph.type_lookup_code,