DBA Data[Home] [Help]

APPS.OKI_DBI_LOAD_CLEB_PVT dependencies on QP_LOOKUPS

Line 2830: qp_lookups qpl,

2826: , ( select /*+ no_merge */ cii.instance_id
2827: , qpl.meaning agreement_type_code
2828: , oat.name agreement_name
2829: from oe_agreements_tl oat,
2830: qp_lookups qpl,
2831: oe_agreements_b oab,
2832: csi_item_instances cii
2833: where oab.agreement_id = oat.agreement_id
2834: and cii.last_oe_agreement_id = oab.agreement_id(+)

Line 5221: qp_lookups qpl,

5217: , ( select /*+ no_merge */ oab.agreement_id
5218: , qpl.meaning agreement_type_code
5219: , oat.name agreement_name
5220: from oe_agreements_tl oat,
5221: qp_lookups qpl,
5222: oe_agreements_b oab
5223: where oab.agreement_id = oat.agreement_id
5224: and oat.language = userenv('LANG')
5225: and qpl.lookup_type(+) = 'QP_AGREEMENT_TYPE'