eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_TA_BULKLOAD_PVT dependencies on EGO_MTL_CATALOG_GRP_VERS_B

Line 2514: FROM ego_mtl_catalog_grp_vers_b vers

2510: p_version_seq_id IN NUMBER) RETURN DATE IS
2511:
2512: CURSOR c IS
2513: SELECT nvl(vers.start_active_date,SYSDATE)
2514: FROM ego_mtl_catalog_grp_vers_b vers
2515: WHERE vers.item_catalog_group_id = p_item_catalog_group_id
2516: AND vers.version_seq_id = p_version_seq_id;
2517:
2518: l_ret ego_mtl_catalog_grp_vers_b.start_active_date%TYPE;

Line 2518: l_ret ego_mtl_catalog_grp_vers_b.start_active_date%TYPE;

2514: FROM ego_mtl_catalog_grp_vers_b vers
2515: WHERE vers.item_catalog_group_id = p_item_catalog_group_id
2516: AND vers.version_seq_id = p_version_seq_id;
2517:
2518: l_ret ego_mtl_catalog_grp_vers_b.start_active_date%TYPE;
2519:
2520: BEGIN
2521: OPEN c;
2522: FETCH c INTO l_ret;

Line 2565: FROM ego_mtl_catalog_grp_vers_b cat_vers

2561:
2562: CURSOR c IS
2563: SELECT version_seq_id
2564: FROM (SELECT version_seq_id
2565: FROM ego_mtl_catalog_grp_vers_b cat_vers
2566: WHERE cat_vers.item_catalog_group_id = p_item_catalog_group_id
2567: AND cat_vers.start_active_date <= p_active_date
2568: AND (cat_vers.end_active_date IS NULL
2569: OR cat_vers.end_active_date >= p_active_date)

Line 2573: l_ret ego_mtl_catalog_grp_vers_b.version_seq_id%TYPE;

2569: OR cat_vers.end_active_date >= p_active_date)
2570: ORDER BY version_seq_id DESC)
2571: WHERE rownum = 1;
2572:
2573: l_ret ego_mtl_catalog_grp_vers_b.version_seq_id%TYPE;
2574: BEGIN
2575: OPEN c;
2576: FETCH c INTO l_ret;
2577: CLOSE c;

Line 2593: l_start_date ego_mtl_catalog_grp_vers_b.start_active_date%TYPE;

2589: p_attr_name IN VARCHAR2,
2590: x_attr_id OUT NOCOPY NUMBER,
2591: x_association_id OUT NOCOPY NUMBER) RETURN BOOLEAN IS
2592:
2593: l_start_date ego_mtl_catalog_grp_vers_b.start_active_date%TYPE;
2594: l_latest_vers ego_mtl_catalog_grp_vers_b.version_seq_id%TYPE;
2595: l_attr_id ego_trans_attr_vers_b.attr_id%TYPE;
2596: l_association_id ego_trans_attr_vers_b.association_id%TYPE;
2597: l_proc_name CONSTANT VARCHAR2(30) := 'IS_INHERITED_ATTRIBUTE';

Line 2594: l_latest_vers ego_mtl_catalog_grp_vers_b.version_seq_id%TYPE;

2590: x_attr_id OUT NOCOPY NUMBER,
2591: x_association_id OUT NOCOPY NUMBER) RETURN BOOLEAN IS
2592:
2593: l_start_date ego_mtl_catalog_grp_vers_b.start_active_date%TYPE;
2594: l_latest_vers ego_mtl_catalog_grp_vers_b.version_seq_id%TYPE;
2595: l_attr_id ego_trans_attr_vers_b.attr_id%TYPE;
2596: l_association_id ego_trans_attr_vers_b.association_id%TYPE;
2597: l_proc_name CONSTANT VARCHAR2(30) := 'IS_INHERITED_ATTRIBUTE';
2598:

Line 3136: FROM EGO_MTL_CATALOG_GRP_VERS_B

3132: )
3133: IN
3134: (SELECT item_catalog_group_id,
3135: VERSION_SEQ_ID
3136: FROM EGO_MTL_CATALOG_GRP_VERS_B
3137: WHERE start_active_date <=
3138: (SELECT NVL(start_active_date,SYSDATE)
3139: FROM EGO_MTL_CATALOG_GRP_VERS_B
3140: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id

Line 3139: FROM EGO_MTL_CATALOG_GRP_VERS_B

3135: VERSION_SEQ_ID
3136: FROM EGO_MTL_CATALOG_GRP_VERS_B
3137: WHERE start_active_date <=
3138: (SELECT NVL(start_active_date,SYSDATE)
3139: FROM EGO_MTL_CATALOG_GRP_VERS_B
3140: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
3141: AND VERSION_SEQ_ID = p_icc_version_number
3142: )
3143: AND NVL(end_active_date, sysdate) >=

Line 3145: FROM EGO_MTL_CATALOG_GRP_VERS_B

3141: AND VERSION_SEQ_ID = p_icc_version_number
3142: )
3143: AND NVL(end_active_date, sysdate) >=
3144: (SELECT NVL(start_active_date,SYSDATE)
3145: FROM EGO_MTL_CATALOG_GRP_VERS_B
3146: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
3147: AND VERSION_SEQ_ID = p_icc_version_number
3148: )
3149: AND version_seq_id > 0

Line 3198: FROM EGO_MTL_CATALOG_GRP_VERS_B

3194: )
3195: IN
3196: (SELECT item_catalog_group_id,
3197: VERSION_SEQ_ID
3198: FROM EGO_MTL_CATALOG_GRP_VERS_B
3199: WHERE
3200: (
3201: item_catalog_group_id,start_active_date
3202: )

Line 3206: FROM EGO_MTL_CATALOG_GRP_VERS_B

3202: )
3203: IN
3204: (SELECT item_catalog_group_id,
3205: MAX(start_active_date) start_active_date
3206: FROM EGO_MTL_CATALOG_GRP_VERS_B
3207: WHERE NVL(end_active_date, sysdate) >=
3208: (SELECT NVL(start_active_date,SYSDATE)
3209: FROM EGO_MTL_CATALOG_GRP_VERS_B
3210: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id

Line 3209: FROM EGO_MTL_CATALOG_GRP_VERS_B

3205: MAX(start_active_date) start_active_date
3206: FROM EGO_MTL_CATALOG_GRP_VERS_B
3207: WHERE NVL(end_active_date, sysdate) >=
3208: (SELECT NVL(start_active_date,SYSDATE)
3209: FROM EGO_MTL_CATALOG_GRP_VERS_B
3210: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
3211: AND VERSION_SEQ_ID = p_icc_version_number
3212: )
3213: AND version_seq_id > 0

Line 3217: FROM EGO_MTL_CATALOG_GRP_VERS_B

3213: AND version_seq_id > 0
3214:
3215: AND start_active_date <=
3216: (SELECT NVL(start_active_date,SYSDATE)
3217: FROM EGO_MTL_CATALOG_GRP_VERS_B
3218: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
3219: AND VERSION_SEQ_ID = p_icc_version_number
3220: )
3221:

Line 3227: FROM EGO_MTL_CATALOG_GRP_VERS_B

3223:
3224: GROUP BY item_catalog_group_id
3225: HAVING MAX(start_active_date)<=
3226: (SELECT NVL(start_active_date,SYSDATE)
3227: FROM EGO_MTL_CATALOG_GRP_VERS_B
3228: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
3229: AND VERSION_SEQ_ID = p_icc_version_number
3230: )
3231: )

Line 3278: FROM EGO_MTL_CATALOG_GRP_VERS_B

3274: )
3275: IN
3276: (SELECT item_catalog_group_id,
3277: VERSION_SEQ_ID
3278: FROM EGO_MTL_CATALOG_GRP_VERS_B
3279: WHERE
3280: (
3281: item_catalog_group_id,start_active_date
3282: )

Line 3286: FROM EGO_MTL_CATALOG_GRP_VERS_B

3282: )
3283: IN
3284: (SELECT item_catalog_group_id,
3285: MAX(start_active_date) start_active_date
3286: FROM EGO_MTL_CATALOG_GRP_VERS_B
3287: WHERE NVL(end_active_date, sysdate) >=
3288: (SELECT NVL(start_active_date,SYSDATE)
3289: FROM EGO_MTL_CATALOG_GRP_VERS_B
3290: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id

Line 3289: FROM EGO_MTL_CATALOG_GRP_VERS_B

3285: MAX(start_active_date) start_active_date
3286: FROM EGO_MTL_CATALOG_GRP_VERS_B
3287: WHERE NVL(end_active_date, sysdate) >=
3288: (SELECT NVL(start_active_date,SYSDATE)
3289: FROM EGO_MTL_CATALOG_GRP_VERS_B
3290: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
3291: AND VERSION_SEQ_ID = p_icc_version_number
3292: )
3293: AND version_seq_id > 0

Line 3298: FROM EGO_MTL_CATALOG_GRP_VERS_B

3294:
3295:
3296: AND start_active_date <=
3297: (SELECT NVL(start_active_date,SYSDATE)
3298: FROM EGO_MTL_CATALOG_GRP_VERS_B
3299: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
3300: AND VERSION_SEQ_ID = p_icc_version_number
3301: )
3302:

Line 3309: FROM EGO_MTL_CATALOG_GRP_VERS_B

3305:
3306: GROUP BY item_catalog_group_id
3307: HAVING MAX(start_active_date)<=
3308: (SELECT NVL(start_active_date,SYSDATE)
3309: FROM EGO_MTL_CATALOG_GRP_VERS_B
3310: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
3311: AND VERSION_SEQ_ID = p_icc_version_number
3312: )
3313: )