DBA Data[Home] [Help]

APPS.EGO_ICC_STRUCTURE_PVT dependencies on EGO_MTL_CATALOG_GRP_VERS_B

Line 66: from EGO_MTL_CATALOG_GRP_VERS_B

62: select 1
63: into l_create_header
64: from dual
65: where exists (select 1
66: from EGO_MTL_CATALOG_GRP_VERS_B
67: where item_catalog_group_id = p_item_catalog_grp_id)
68: and not exists (select 1
69: from BOM_STRUCTURES_B
70: where pk1_value = p_item_catalog_grp_id

Line 829: from EGO_MTL_CATALOG_GRP_VERS_B

825: l_effective_version NUMBER := NULL;
826: BEGIN
827: select version_seq_id
828: into l_effective_version
829: from EGO_MTL_CATALOG_GRP_VERS_B
830: where item_catalog_group_id = p_item_catalog_grp_id
831: and version_seq_id <> 0
832: and nvl(p_start_date,sysdate) between start_active_date and nvl(end_active_date,nvl(p_start_date,sysdate+1));
833:

Line 3038: from EGO_MTL_CATALOG_GRP_VERS_B

3034: select 1
3035: into l_create_header
3036: from dual
3037: where exists (select 1
3038: from EGO_MTL_CATALOG_GRP_VERS_B
3039: where item_catalog_group_id = p_item_catalog_grp_id)
3040: and not exists (select 1
3041: from BOM_STRUCTURES_B
3042: where pk1_value = p_item_catalog_grp_id