DBA Data[Home] [Help]

APPS.QA_SS_OM dependencies on FND_COMMON_LOOKUPS

Line 98: from QA_RESULTS QR, qa_plans qp, fnd_common_lookups fcl

94: -- Fetch plans matching the so header id criteria
95: -- also get the plan name, description and type(meaning)
96: CURSOR om_plans_cur IS
97: SELECT distinct qr.plan_id, qp.name, qp.description, fcl.meaning
98: from QA_RESULTS QR, qa_plans qp, fnd_common_lookups fcl
99: where QR.So_Header_Id = to_number(Pk1)
100: and qr.plan_id = qp.plan_id
101: and qp.plan_type_code = fcl.lookup_code
102: and fcl.lookup_type = 'COLLECTION_PLAN_TYPE'

Line 156: from QA_RESULTS QR, qa_plans qp, fnd_common_lookups fcl

152: -- Fetch plans matching the so header id and itemid criteria
153: -- also get the plan name, description and type(meaning)
154: CURSOR om_plans_cur IS
155: SELECT distinct qr.plan_id, qp.name, qp.description, fcl.meaning
156: from QA_RESULTS QR, qa_plans qp, fnd_common_lookups fcl
157: where QR.So_Header_Id = to_number(Pk1)
158: AND qr.item_id = to_number(pk3)
159: and qr.plan_id = qp.plan_id
160: and qp.plan_type_code = fcl.lookup_code