DBA Data[Home] [Help]

APPS.OKC_XPRT_XRULE_VALUES_PVT dependencies on OKC_BUS_VARIABLES_B

Line 415: okc_bus_variables_b bvar

411: SELECT 'USER$' || var.variable_code variable_code,
412: NVL(var.variable_value_id,var.variable_value) variable_value -- Added NVL for Bug 5233775
413: FROM okc_k_art_variables var,
414: okc_k_articles_b art, -- Added for Bug 4728565
415: okc_bus_variables_b bvar
416: WHERE art.id = var.cat_id -- Added for Bug 4728565
417: AND art.document_id = p_doc_id -- Added for Bug 4728565
418: AND art.document_type = p_doc_type -- Added for Bug 4728565
419: AND var.variable_code = bvar.variable_code

Line 680: FROM okc_bus_variables_b var

676:
677: CURSOR csr_get_udv_with_proc (p_doc_type VARCHAR2,p_doc_id NUMBER, p_intent VARCHAR2, p_org_id NUMBER) IS
678: SELECT var.variable_code variable_code, --Removed USER$ to resolve Rule firing for UDV with Procedures
679: procedure_name procedure_name
680: FROM okc_bus_variables_b var
681: WHERE var.variable_source = 'P'
682: AND var.variable_code IN
683: (SELECT distinct rcon.object_code variable_code -- LHS of Condition from Template rule
684: FROM okc_xprt_rule_hdrs_all rhdr,