DBA Data[Home] [Help]

APPS.QP_QP_FORM_PRICING_ATTR dependencies on FND_LOOKUP_VALUES

Line 1664: /* LKP1 rewritten from qp_charge_lookup to fnd_lookup_values (plus additional

1660: ELSIF ( l_pte_code <> 'PO' and l_source_system_code <> 'PO' ) OR ( l_profile_source_system_code <> 'PO' and
1661: l_profile_pte_code <> 'PO') THEN
1662:
1663: /* changes made in select statement by dhgupta for bug 2047030 */
1664: /* LKP1 rewritten from qp_charge_lookup to fnd_lookup_values (plus additional
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

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')