APPS.PO_MOD_UTIL_PVT dependencies on OKC_K_ART_VARIABLES

Line 479: okc_k_art_variables KAV,

475: KAV.variable_value) as value
476:
477: from okc_k_articles_b KAB ,
478: okc_article_Variables OAV,
479: okc_k_art_variables KAV,
480: okc_bus_variables_b BVB,
481: FND_FLEX_VALUE_SETS FVS
482: where KAB.document_id = p_doc_id
483: and KAB.document_type = p_doc_type

Line 512: from okc_k_art_variables var, okc_k_articles_b kart

508: ARTICLE_VERSION_ID,
509: cat_id,
510: VARIABLE_CODE
511: ) (select kart.document_type, kart.document_id, kart.article_version_id, var.cat_id, var.variable_code
512: from okc_k_art_variables var, okc_k_articles_b kart
513: where var.cat_id = kart.id
514: and var.variable_type = 'S'
515: and kart.document_type = p_mod_doc_type
516: and kart.document_id = p_mod_doc_id);

Line 542: from okc_k_art_variables var, okc_k_articles_b kart

538: ARTICLE_VERSION_ID,
539: cat_id,
540: VARIABLE_CODE
541: ) (select kart.document_type, kart.document_id, kart.article_version_id, var.cat_id, var.variable_code
542: from okc_k_art_variables var, okc_k_articles_b kart
543: where var.cat_id = kart.id
544: and var.variable_type = 'S'
545: and kart.document_type = p_base_doc_type
546: and kart.document_id = p_base_doc_id);

Line 647: -- based on okc_k_art_variables for mod check values for all variables which have changed between mod and base n all of the GT above

643: );
644: -- the values for mod records will go into SGD XML for variable substitution
645: -- select * from OKC_TERMS_UDV_WITH_PROCEDURE_T/OKC_TERMS_CLM_UDV_T/PO_OKC_VARS_GT where document_type = mod and document_id = id;
646:
647: -- based on okc_k_art_variables for mod check values for all variables which have changed between mod and base n all of the GT above
648: -- if there are changed variables then find the clauses using them and report as changed in changed_clauses query of datatemplate
649:
650: end set_contract_variables;
651: /* RTF SGD change end */