APPS.EGO_ITEM_WS_PVT dependencies on EGO_MTL_CATALOG_GRP_VERS_B

Line 1492: FROM EGO_MTL_CATALOG_GRP_VERS_B

1488: ( LEV = 1 AND ICC_VERSION_number =cp_icc_version_number )
1489: OR
1490: ( LEV > 1 AND ( item_catalog_group_id, ICC_VERSION_NUMBER )
1491: IN ( SELECT item_catalog_group_id, VERSION_SEQ_ID
1492: FROM EGO_MTL_CATALOG_GRP_VERS_B
1493: WHERE (item_catalog_group_id,start_active_date )
1494: IN
1495: (SELECT item_catalog_group_id, MAX(start_active_date) start_active_date
1496: FROM EGO_MTL_CATALOG_GRP_VERS_B

Line 1496: FROM EGO_MTL_CATALOG_GRP_VERS_B

1492: FROM EGO_MTL_CATALOG_GRP_VERS_B
1493: WHERE (item_catalog_group_id,start_active_date )
1494: IN
1495: (SELECT item_catalog_group_id, MAX(start_active_date) start_active_date
1496: FROM EGO_MTL_CATALOG_GRP_VERS_B
1497: WHERE creation_date <= cp_creation_date
1498: AND version_seq_id > 0
1499: AND start_active_date <= cp_start_date
1500: GROUP BY item_catalog_group_id

Line 1550: FROM EGO_MTL_CATALOG_GRP_VERS_B

1546: -- Bug 8690445 : Added the Exception Block
1547: BEGIN
1548: --Finding out which ICC version is effective at a time of item creation.
1549: SELECT VERSION_SEQ_ID INTO l_version_seq_id
1550: FROM EGO_MTL_CATALOG_GRP_VERS_B
1551: WHERE (ITEM_CATALOG_GROUP_ID, start_active_date) IN
1552: (
1553: SELECT ITEM_CATALOG_GROUP_ID,Max(START_ACTIVE_DATE) START_ACTIVE_DATE
1554: FROM EGO_MTL_CATALOG_GRP_VERS_B

Line 1554: FROM EGO_MTL_CATALOG_GRP_VERS_B

1550: FROM EGO_MTL_CATALOG_GRP_VERS_B
1551: WHERE (ITEM_CATALOG_GROUP_ID, start_active_date) IN
1552: (
1553: SELECT ITEM_CATALOG_GROUP_ID,Max(START_ACTIVE_DATE) START_ACTIVE_DATE
1554: FROM EGO_MTL_CATALOG_GRP_VERS_B
1555: WHERE CREATION_DATE <= l_item_create_date AND
1556: ITEM_CATALOG_GROUP_ID = l_item_catalog_group_id AND
1557: START_ACTIVE_DATE <= l_item_start_date AND VERSION_SEQ_ID >0
1558: GROUP BY ITEM_CATALOG_GROUP_ID