[Home] [Help]
1839: WHERE
1840: RSC.CATEGORY = 'SUPPLIER_CONTACT'
1841: AND C.VENDOR_CONTACT_ID = RSC.SOURCE_ID
1842: AND S.VENDOR_SITE_ID = C.VENDOR_SITE_ID
1843: AND S.ORG_ID = sys_context('OKC_CONTEXT', 'ORG_ID')
1844: AND RSC.RESOURCE_ID = to_number(p_object1_id1)
1845: AND '#' = p_object1_id2
1846: UNION ALL
1847: SELECT
1880: WHERE
1881: RSC.CATEGORY = 'OTHER'
1882: AND SRP.RESOURCE_ID = RSC.RESOURCE_ID
1883: AND U.USER_ID = RSC.USER_ID
1884: AND SRP.ORG_ID = sys_context('OKC_CONTEXT', 'ORG_ID')
1885: AND TL.RESOURCE_ID = SRP.RESOURCE_ID -- Bug Fix #5442182
1886: AND TL.LANGUAGE = USERENV('LANG') -- Bug Fix #5442182
1887: AND TL.CATEGORY = RSC.CATEGORY
1888: AND RSC.RESOURCE_ID = to_number(p_object1_id1)
2799: FETCH line_excep_cov_type_cur
2800: INTO l_line_hdr_rec_type.exception_cov_type;
2801: CLOSE line_excep_cov_type_cur;
2802: BEGIN
2803: OKC_CONTEXT.set_okc_org_context;
2804: FOR j in covered_level_cur(p_line_id_arg)
2805: LOOP
2806: l_covered_level_tbl_type(l_covered_level_tbl_indx).line_number := j.LineNumber;
2807: l_covered_level_tbl_type(l_covered_level_tbl_indx).covered_level := j.Coverage;
2846: x_return_status := 'ERROR IN lINE COVERED LEVELS';
2847: END;
2848:
2849: BEGIN
2850: OKC_CONTEXT.set_okc_org_context;
2851: FOR k IN customer_contacts_cur(p_line_id_arg)
2852: LOOP
2853: l_cust_contacts_tbl_type(l_customer_contact_tbl_indx).cust_contacts_role := k.Role;
2854: l_cust_contacts_tbl_type(l_customer_contact_tbl_indx).cust_contacts_start_date := k.StartDate;
3241: AND con.object1_id2 = '#'
3242: AND RSC.CATEGORY = 'SUPPLIER_CONTACT'
3243: AND C.VENDOR_CONTACT_ID = RSC.SOURCE_ID
3244: AND S.VENDOR_SITE_ID = C.VENDOR_SITE_ID
3245: AND S.ORG_ID = sys_context('OKC_CONTEXT', 'ORG_ID')
3246: union all
3247: select
3248: pty.cle_id businessprocessid,
3249: pty.rle_code rlecode,
3306: and con.jtot_object1_code ='okx_resource'
3307: and RSC.CATEGORY = 'OTHER'
3308: AND SRP.RESOURCE_ID = RSC.RESOURCE_ID
3309: AND U.USER_ID = RSC.USER_ID
3310: AND SRP.ORG_ID = sys_context('OKC_CONTEXT', 'ORG_ID')
3311: AND con.object1_id1 = RSC.RESOURCE_ID
3312: AND con.object1_id2 = '#'; */
3313:
3314:
3770: OKX_COUNTERS_V ct
3771: Where
3772: ct.ID1 = to_number(p_covered_prod_id)
3773: and sys.ID1 = cp.INVENTORY_ITEM_ID
3774: and sys.ID2 = okc_context.get_okc_organization_id
3775: and cgrp.COUNTER_GROUP_ID = ct.COUNTER_GROUP_ID
3776: and cgrp.SOURCE_OBJECT_ID = cp.CUSTOMER_PRODUCT_ID
3777: and cgrp.SOURCE_OBJECT_CODE = 'CP'
3778: UNION
3994: AND CT.USAGE_ITEM_ID IS NOT NULL
3995: AND CG.SOURCE_OBJECT_ID = CII.INSTANCE_ID
3996: AND CG.SOURCE_OBJECT_CODE = 'CP'
3997: AND IT.ID1 = CII.INVENTORY_ITEM_ID
3998: AND IT.ORGANIZATION_ID = SYS_CONTEXT('OKC_CONTEXT', 'ORGANIZATION_ID')
3999: AND CT.COUNTER_ID = to_number(p_covered_prod_ID_arg)
4000: UNION
4001: SELECT
4002: CG.NAME || '.' || CT.NAME name ,