eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_QP_FORM_PRICING_ATTR dependencies on QP_LOOKUPS

Line 1580: ( p_lookup_code IN QP_LOOKUPS.lookup_code%type

1576:
1577:
1578:
1579: FUNCTION Get_MEANING
1580: ( p_lookup_code IN QP_LOOKUPS.lookup_code%type
1581: , p_lookup_type IN QP_LOOKUPS.lookup_type%type
1582: )
1583: RETURN QP_LOOKUPS.Meaning%Type IS
1584: l_Meaning QP_LOOKUPS.Meaning%Type;

Line 1581: , p_lookup_type IN QP_LOOKUPS.lookup_type%type

1577:
1578:
1579: FUNCTION Get_MEANING
1580: ( p_lookup_code IN QP_LOOKUPS.lookup_code%type
1581: , p_lookup_type IN QP_LOOKUPS.lookup_type%type
1582: )
1583: RETURN QP_LOOKUPS.Meaning%Type IS
1584: l_Meaning QP_LOOKUPS.Meaning%Type;
1585: BEGIN

Line 1583: RETURN QP_LOOKUPS.Meaning%Type IS

1579: FUNCTION Get_MEANING
1580: ( p_lookup_code IN QP_LOOKUPS.lookup_code%type
1581: , p_lookup_type IN QP_LOOKUPS.lookup_type%type
1582: )
1583: RETURN QP_LOOKUPS.Meaning%Type IS
1584: l_Meaning QP_LOOKUPS.Meaning%Type;
1585: BEGIN
1586:
1587: select meaning into l_Meaning from qp_lookups where

Line 1584: l_Meaning QP_LOOKUPS.Meaning%Type;

1580: ( p_lookup_code IN QP_LOOKUPS.lookup_code%type
1581: , p_lookup_type IN QP_LOOKUPS.lookup_type%type
1582: )
1583: RETURN QP_LOOKUPS.Meaning%Type IS
1584: l_Meaning QP_LOOKUPS.Meaning%Type;
1585: BEGIN
1586:
1587: select meaning into l_Meaning from qp_lookups where
1588: lookup_code = p_lookup_code and lookup_type = p_lookup_type ;

Line 1587: select meaning into l_Meaning from qp_lookups where

1583: RETURN QP_LOOKUPS.Meaning%Type IS
1584: l_Meaning QP_LOOKUPS.Meaning%Type;
1585: BEGIN
1586:
1587: select meaning into l_Meaning from qp_lookups where
1588: lookup_code = p_lookup_code and lookup_type = p_lookup_type ;
1589:
1590: RETURN l_Meaning;
1591:

Line 1631: , p_Charge_Subtype_code IN QP_LOOKUPS.lookup_code%type

1627:
1628: FUNCTION Get_Charge_name
1629: ( p_list_header_id IN qp_list_headers_b.list_header_id%type
1630: , p_Charge_Type_code IN QP_CHARGE_LOOKUP.lookup_code%type
1631: , p_Charge_Subtype_code IN QP_LOOKUPS.lookup_code%type
1632: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type
1633: )
1634: RETURN QP_LOOKUPS.Meaning%Type IS
1635: l_Charge_Name QP_LOOKUPS.Meaning%Type;

Line 1634: RETURN QP_LOOKUPS.Meaning%Type IS

1630: , p_Charge_Type_code IN QP_CHARGE_LOOKUP.lookup_code%type
1631: , p_Charge_Subtype_code IN QP_LOOKUPS.lookup_code%type
1632: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type
1633: )
1634: RETURN QP_LOOKUPS.Meaning%Type IS
1635: l_Charge_Name QP_LOOKUPS.Meaning%Type;
1636: l_profile_source_system_code qp_list_headers_b.source_system_code%type := fnd_profile.value('QP_SOURCE_SYSTEM_CODE');
1637: l_profile_pte_code qp_list_headers_b.pte_code%type := fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY');
1638: l_source_system_code qp_list_headers_b.source_system_code%type;

Line 1635: l_Charge_Name QP_LOOKUPS.Meaning%Type;

1631: , p_Charge_Subtype_code IN QP_LOOKUPS.lookup_code%type
1632: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type
1633: )
1634: RETURN QP_LOOKUPS.Meaning%Type IS
1635: l_Charge_Name QP_LOOKUPS.Meaning%Type;
1636: l_profile_source_system_code qp_list_headers_b.source_system_code%type := fnd_profile.value('QP_SOURCE_SYSTEM_CODE');
1637: l_profile_pte_code qp_list_headers_b.pte_code%type := fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY');
1638: l_source_system_code qp_list_headers_b.source_system_code%type;
1639: l_pte_code qp_list_headers_b.pte_code%type;

Line 1669: FROM fnd_lookup_values LKP1, QP_LOOKUPS LKP2

1665: where conditions of the qp_charge_lookup view definition) to get rid of
1666: non-mergable view, bug 4865226 */
1667: SELECT nvl(DECODE(lkp1.lookup_type,'FREIGHT_COST_TYPE',lkp1.meaning,lkp2.meaning),lkp1.meaning)
1668: INTO l_Charge_Name
1669: FROM fnd_lookup_values LKP1, QP_LOOKUPS LKP2
1670: WHERE lkp1.language = userenv('LANG')
1671: and lkp1.security_group_id = 0
1672: and ((lkp1.view_application_id = 661 and
1673: lkp1.lookup_type = 'FREIGHT_CHARGES_TYPE')

Line 1845: RETURN QP_LOOKUPS.Meaning%Type IS

1841: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
1842: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type
1843: , p_rebate_transaction_type_code IN QP_LIST_LINES.REBATE_TRANSACTION_TYPE_CODE%type
1844: )
1845: RETURN QP_LOOKUPS.Meaning%Type IS
1846: l_Rebate_Txn_Type QP_LOOKUPS.Meaning%Type;
1847: BEGIN
1848:
1849: select decode(p_modifier_type_code, p_list_line_type_code,

Line 1846: l_Rebate_Txn_Type QP_LOOKUPS.Meaning%Type;

1842: , p_list_line_type_code IN QP_LIST_LINES.list_line_type_code%type
1843: , p_rebate_transaction_type_code IN QP_LIST_LINES.REBATE_TRANSACTION_TYPE_CODE%type
1844: )
1845: RETURN QP_LOOKUPS.Meaning%Type IS
1846: l_Rebate_Txn_Type QP_LOOKUPS.Meaning%Type;
1847: BEGIN
1848:
1849: select decode(p_modifier_type_code, p_list_line_type_code,
1850: qlook.meaning, Null) into

Line 1851: l_Rebate_Txn_Type from QP_LOOKUPS qlook where

1847: BEGIN
1848:
1849: select decode(p_modifier_type_code, p_list_line_type_code,
1850: qlook.meaning, Null) into
1851: l_Rebate_Txn_Type from QP_LOOKUPS qlook where
1852: qlook.lookup_type = 'REBATE_TRANSACTION_TYPE_CODE' and
1853: qlook.lookup_code = p_rebate_transaction_type_code;
1854:
1855: /*

Line 1858: l_Rebate_Txn_Type from QP_LIST_LINES ql, QP_LOOKUPS qlook where

1854:
1855: /*
1856: select decode(p_modifier_type_code, ql.list_line_type_code,
1857: qlook.meaning, Null) into
1858: l_Rebate_Txn_Type from QP_LIST_LINES ql, QP_LOOKUPS qlook where
1859: ql.list_line_id = p_list_line_id and
1860: qlook.lookup_code = ql.rebate_transaction_type_code;
1861: */
1862:

Line 2300: RETURN QP_LOOKUPS.Meaning%Type IS

2296: ( p_list_line_id IN QP_LIST_LINES.list_line_id%type
2297: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2298: , p_break_line_type_code IN QP_LIST_LINES.list_line_type_code%type
2299: )
2300: RETURN QP_LOOKUPS.Meaning%Type IS
2301: l_Break_Line_Type QP_LOOKUPS.Meaning%Type;
2302: BEGIN
2303:
2304: IF p_modifier_type_code = 'PBH' then

Line 2301: l_Break_Line_Type QP_LOOKUPS.Meaning%Type;

2297: , p_modifier_type_code IN QP_LIST_LINES.list_line_type_code%type
2298: , p_break_line_type_code IN QP_LIST_LINES.list_line_type_code%type
2299: )
2300: RETURN QP_LOOKUPS.Meaning%Type IS
2301: l_Break_Line_Type QP_LOOKUPS.Meaning%Type;
2302: BEGIN
2303:
2304: IF p_modifier_type_code = 'PBH' then
2305:

Line 2307: from qp_lookups qlook

2303:
2304: IF p_modifier_type_code = 'PBH' then
2305:
2306: select qlook.Meaning into l_Break_Line_Type
2307: from qp_lookups qlook
2308: where qlook.lookup_type = 'LIST_LINE_TYPE_CODE' and
2309: qlook.lookup_code = p_break_line_type_code;
2310:
2311:

Line 2314: from QP_LIST_LINES ql, qp_lookups qlook

2310:
2311:
2312: /*
2313: select qlook.Meaning into l_Break_Line_Type
2314: from QP_LIST_LINES ql, qp_lookups qlook
2315: where qlook.lookup_code = ql.list_line_type_code and
2316: ql.list_line_id = (select to_rltd_modifier_id from
2317: qp_rltd_modifiers where from_rltd_modifier_id = p_list_line_id and
2318: rownum < 2);