5638:
5639: --Bug 3326337 Removed the hard coding for entity names
5640: /* Commentedout for 11510 GSI Issue on copying attachments
5641: If(FND_ATTACHMENT_UTIL_PKG.function_name = 'OKSAUDET') THEN
5642: l_entity_name := 'OKC_K_HEADERS_V';
5643: l_from_entity_name := 'OKC_K_HEADERS_V';
5644: l_to_entity_name := 'OKC_K_HEADERS_V';
5645: ELSE */
5646: l_entity_name := 'OKC_K_HEADERS_B';
5639: --Bug 3326337 Removed the hard coding for entity names
5640: /* Commentedout for 11510 GSI Issue on copying attachments
5641: If(FND_ATTACHMENT_UTIL_PKG.function_name = 'OKSAUDET') THEN
5642: l_entity_name := 'OKC_K_HEADERS_V';
5643: l_from_entity_name := 'OKC_K_HEADERS_V';
5644: l_to_entity_name := 'OKC_K_HEADERS_V';
5645: ELSE */
5646: l_entity_name := 'OKC_K_HEADERS_B';
5647: l_from_entity_name := 'OKC_K_HEADERS_B';
5640: /* Commentedout for 11510 GSI Issue on copying attachments
5641: If(FND_ATTACHMENT_UTIL_PKG.function_name = 'OKSAUDET') THEN
5642: l_entity_name := 'OKC_K_HEADERS_V';
5643: l_from_entity_name := 'OKC_K_HEADERS_V';
5644: l_to_entity_name := 'OKC_K_HEADERS_V';
5645: ELSE */
5646: l_entity_name := 'OKC_K_HEADERS_B';
5647: l_from_entity_name := 'OKC_K_HEADERS_B';
5648: l_to_entity_name := 'OKC_K_HEADERS_B';
8315: RENEWAL_END_DATE,
8316: SHIP_TO_SITE_USE_ID,
8317: PAYMENT_TERM_ID
8318:
8319: FROM OKC_K_HEADERS_V
8320: WHERE id = p_chr_id
8321: AND G_COPY_HISTORY_YN = 'N'
8322: UNION ALL
8323: SELECT ID,