APPS.PO_PRICE_HELPER dependencies on PO_LINES

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 566: PO_LINES_SV4.get_ship_quantity_info(

562: -- and an error will only be reported if it becomed Y.
563: l_prevent_price_update_flag := 'N';
564:
565: d_position := 200;
566: PO_LINES_SV4.get_ship_quantity_info(
567: x_po_line_id => l_line_id_tbl(i)
568: , x_expense_accrual_code => l_expense_accrual_code_tbl(i)
569: , x_po_header_id => l_header_id_tbl(i)
570: , x_type_lookup_code => l_type_lookup_code_tbl(i)

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 1005: l_source_document_header_id PO_LINES.po_header_id%TYPE;

1001: d_position NUMBER := 0;
1002:
1003: l_doc_sub_type VARCHAR2(30);
1004: l_source_document_type PO_HEADERS.type_lookup_code%TYPE;
1005: l_source_document_header_id PO_LINES.po_header_id%TYPE;
1006: l_pricing_date PO_LINE_LOCATIONS.need_by_date%TYPE;
1007: l_rate PO_HEADERS.rate%TYPE;
1008: l_rate_type PO_HEADERS.rate_type%TYPE;
1009:

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,