APPS.EGO_PAGES_BULKLOAD_PVT dependencies on MTL_ITEM_CATALOG_GROUPS_KFV

Line 559: FROM mtl_item_catalog_groups_kfv icc_kfv

555: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
556:
557: UPDATE ego_pages_interface epi
558: SET classification_name = (SELECT icc_kfv.concatenated_segments
559: FROM mtl_item_catalog_groups_kfv icc_kfv
560: WHERE icc_kfv.item_catalog_group_id = epi.classification_code),
561: last_updated_by = G_USER_ID,
562: last_update_date = SYSDATE,
563: last_update_login = G_LOGIN_ID

Line 619: FROM mtl_item_catalog_groups_kfv icc_kfv

615: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
616:
617: UPDATE ego_page_entries_interface epi
618: SET classification_name = (SELECT icc_kfv.concatenated_segments
619: FROM mtl_item_catalog_groups_kfv icc_kfv
620: WHERE icc_kfv.item_catalog_group_id = epi.classification_code),
621: last_updated_by = G_USER_ID,
622: last_update_date = SYSDATE,
623: last_update_login = G_LOGIN_ID

Line 770: FROM mtl_item_catalog_groups_kfv icc_kfv

766: /*Sets the classification name if the classification code is given*/
767: IF (p_pg_tbl(i).classification_code IS NOT NULL) THEN
768: BEGIN
769: SELECT icc_kfv.concatenated_segments INTO p_pg_tbl(i).classification_name
770: FROM mtl_item_catalog_groups_kfv icc_kfv
771: WHERE icc_kfv.item_catalog_group_id = p_pg_tbl(i).classification_code;
772: EXCEPTION
773: WHEN NO_DATA_FOUND THEN
774: x_return_status := G_RET_STS_ERROR;

Line 865: FROM mtl_item_catalog_groups_kfv icc_kfv

861: /*Sets the classification name if the classification code is given*/
862: IF (p_ent_tbl(i).classification_code IS NOT NULL) THEN
863: BEGIN
864: SELECT icc_kfv.concatenated_segments INTO p_ent_tbl(i).classification_name
865: FROM mtl_item_catalog_groups_kfv icc_kfv
866: WHERE icc_kfv.item_catalog_group_id = p_ent_tbl(i).classification_code;
867: EXCEPTION
868: WHEN NO_DATA_FOUND THEN
869: x_return_status := G_RET_STS_ERROR;