DBA Data[Home] [Help]

APPS.PO_PRICE_HELPER dependencies on PO_LINES_ALL

Line 58: -- PO_LINES_ALL.order_type_lookup_code

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

Line 70: -- PO_LINES_ALL.price_break_lookup_code

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';
72:
73: -------------------------------------------------------------------------------
74: --Start of Comments

Line 375: PO_LINES_ALL LINE

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

Line 512: , PO_LINES_ALL LINE

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

Line 844: , PO_LINES_ALL LINE

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