DBA Data[Home] [Help]

APPS.OKC_TERMS_UTIL_GRP dependencies on OKC_RESP_PARTIES_VL

Line 3008: okc_resp_parties_vl party,

3004: party.alternate_name authoring_party,
3005: src.meaning contract_source
3006: FROM OKC_TEMPLATE_USAGES tu,
3007: OKC_TERMS_TEMPLATES_ALL t,
3008: okc_resp_parties_vl party,
3009: okc_bus_doc_types_b doc,
3010: fnd_lookups src
3011: WHERE t.template_id(+) = tu.template_id
3012: AND tu.authoring_party_code = party.resp_party_code

Line 3162: okc_resp_parties_vl party,

3158: party.alternate_name authoring_party,
3159: src.meaning contract_source
3160: FROM OKC_TEMPLATE_USAGES tu,
3161: OKC_TERMS_TEMPLATES_ALL t,
3162: okc_resp_parties_vl party,
3163: okc_bus_doc_types_b doc,
3164: fnd_lookups src
3165: WHERE t.template_id(+) = tu.template_id
3166: AND tu.authoring_party_code = party.resp_party_code

Line 3200: okc_resp_parties_vl party,

3196: party.alternate_name authoring_party,
3197: src.meaning contract_source
3198: FROM OKC_TEMPLATE_USAGES_H tu,
3199: OKC_TERMS_TEMPLATES_ALL t,
3200: okc_resp_parties_vl party,
3201: okc_bus_doc_types_b doc,
3202: fnd_lookups src
3203: WHERE t.template_id(+) = tu.template_id
3204: AND tu.authoring_party_code = party.resp_party_code

Line 3581: okc_resp_parties_vl party,

3577: tmpl.description,
3578: okc_util.decode_lookup('OKC_CONTRACT_TERMS_SOURCES','STRUCTURED'),
3579: party.alternate_name
3580: FROM okc_terms_templates_all tmpl,
3581: okc_resp_parties_vl party,
3582: okc_bus_doc_types_b doc
3583: WHERE tmpl.template_id = p_template_id
3584: and party.document_type_class = doc.document_type_class
3585: and party.intent = doc.intent