APPS.OKS_MASS_UPDATE_PVT dependencies on OKC_K_ACCESSES

Line 55: --| OKC_K_ACCESSES_V | X | | | | | |

51: --| OKS_INSTANCE_K_DTLS_TEMP | X | X | | | | |
52: --+---------------------------------+---+---+---+---+---+----------------------+
53: --| OKS_K_SALES_CREDITS_V | X | | | | | |
54: --+---------------------------------+---+---+---+---+---+----------------------+
55: --| OKC_K_ACCESSES_V | X | | | | | |
56: --+---------------------------------+---+---+---+---+---+----------------------+
57: --| OKC_CLASSES_B | X | | | | | |
58: --+---------------------------------+---+---+---+---+---+----------------------+
59: --| OKC_DATATYPES | | | | | |X |

Line 73: --| OKC_K_ACCESSES | | X | | | | |

69: --| OKX_CUST_SITE_USES_V | X | | | | | |
70: --+---------------------------------+---+---+---+---+---+----------------------+
71: --| OKS_K_HEADERS_B | X | X | | | | |
72: --+---------------------------------+---+---+---+---+---+----------------------+
73: --| OKC_K_ACCESSES | | X | | | | |
74: --+---------------------------------+---+---+---+---+---+----------------------+
75: --| OKS_K_SALES_CREDITS | | X | | | | |
76: --+---------------------------------+---+---+---+---+---+----------------------+
77: --| CS_CTR_ASSOCIATIONS | X | | | | | |

Line 1899: FROM okc_k_accesses_v ac,

1895: SELECT DISTINCT (temp.new_contract_id),
1896: ac.GROUP_ID,
1897: ac.resource_id,
1898: ac.access_level
1899: FROM okc_k_accesses_v ac,
1900: oks_instance_k_dtls_temp temp
1901: WHERE chr_id = temp.contract_id
1902: AND temp.new_contract_id IS NOT NULL;-- cgopinee bugfix for bug11075156;
1903:

Line 3115: INSERT INTO okc_k_accesses

3111:
3112: IF hdr_id.COUNT > 0
3113: THEN
3114: FORALL i IN 1 .. hdr_id.COUNT
3115: INSERT INTO okc_k_accesses
3116: (ID,
3117: chr_id,
3118: GROUP_ID,
3119: resource_id,