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_TRANSACTION_ATTRS_PVT dependencies on EGO_MTL_CATALOG_GRP_VERS_B

Line 602: FROM EGO_MTL_CATALOG_GRP_VERS_B

598: )
599: IN
600: (SELECT item_catalog_group_id,
601: VERSION_SEQ_ID
602: FROM EGO_MTL_CATALOG_GRP_VERS_B
603: WHERE start_active_date <=
604: (SELECT NVL(start_active_date,SYSDATE)
605: FROM EGO_MTL_CATALOG_GRP_VERS_B
606: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id

Line 605: FROM EGO_MTL_CATALOG_GRP_VERS_B

601: VERSION_SEQ_ID
602: FROM EGO_MTL_CATALOG_GRP_VERS_B
603: WHERE start_active_date <=
604: (SELECT NVL(start_active_date,SYSDATE)
605: FROM EGO_MTL_CATALOG_GRP_VERS_B
606: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
607: AND VERSION_SEQ_ID = p_icc_version_number -- bug 9980051
608: )
609: AND NVL(end_active_date, sysdate) >=

Line 611: FROM EGO_MTL_CATALOG_GRP_VERS_B

607: AND VERSION_SEQ_ID = p_icc_version_number -- bug 9980051
608: )
609: AND NVL(end_active_date, sysdate) >=
610: (SELECT NVL(start_active_date,SYSDATE)
611: FROM EGO_MTL_CATALOG_GRP_VERS_B
612: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
613: AND VERSION_SEQ_ID = p_icc_version_number -- bug 9980051
614: )
615: AND version_seq_id > 0

Line 664: FROM EGO_MTL_CATALOG_GRP_VERS_B

660: )
661: IN
662: (SELECT item_catalog_group_id,
663: VERSION_SEQ_ID
664: FROM EGO_MTL_CATALOG_GRP_VERS_B
665: WHERE
666: (
667: item_catalog_group_id,start_active_date
668: )

Line 672: FROM EGO_MTL_CATALOG_GRP_VERS_B

668: )
669: IN
670: (SELECT item_catalog_group_id,
671: MAX(start_active_date) start_active_date
672: FROM EGO_MTL_CATALOG_GRP_VERS_B
673: WHERE NVL(end_active_date, sysdate) >=
674: (SELECT NVL(start_active_date,SYSDATE)
675: FROM EGO_MTL_CATALOG_GRP_VERS_B
676: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id

Line 675: FROM EGO_MTL_CATALOG_GRP_VERS_B

671: MAX(start_active_date) start_active_date
672: FROM EGO_MTL_CATALOG_GRP_VERS_B
673: WHERE NVL(end_active_date, sysdate) >=
674: (SELECT NVL(start_active_date,SYSDATE)
675: FROM EGO_MTL_CATALOG_GRP_VERS_B
676: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
677: AND VERSION_SEQ_ID = p_icc_version_number -- bug 9980051
678: )
679: AND version_seq_id > 0

Line 683: FROM EGO_MTL_CATALOG_GRP_VERS_B

679: AND version_seq_id > 0
680:
681: AND start_active_date <=
682: (SELECT NVL(start_active_date,SYSDATE)
683: FROM EGO_MTL_CATALOG_GRP_VERS_B
684: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
685: AND VERSION_SEQ_ID = p_icc_version_number -- bug 9980051
686: )
687:

Line 693: FROM EGO_MTL_CATALOG_GRP_VERS_B

689:
690: GROUP BY item_catalog_group_id
691: HAVING MAX(start_active_date)<=
692: (SELECT NVL(start_active_date,SYSDATE)
693: FROM EGO_MTL_CATALOG_GRP_VERS_B
694: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
695: AND VERSION_SEQ_ID = p_icc_version_number -- bug 9980051
696: )
697: )

Line 744: FROM EGO_MTL_CATALOG_GRP_VERS_B

740: )
741: IN
742: (SELECT item_catalog_group_id,
743: VERSION_SEQ_ID
744: FROM EGO_MTL_CATALOG_GRP_VERS_B
745: WHERE
746: (
747: item_catalog_group_id,start_active_date
748: )

Line 752: FROM EGO_MTL_CATALOG_GRP_VERS_B

748: )
749: IN
750: (SELECT item_catalog_group_id,
751: MAX(start_active_date) start_active_date
752: FROM EGO_MTL_CATALOG_GRP_VERS_B
753: WHERE NVL(end_active_date, sysdate) >=
754: (SELECT NVL(start_active_date,SYSDATE)
755: FROM EGO_MTL_CATALOG_GRP_VERS_B
756: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id

Line 755: FROM EGO_MTL_CATALOG_GRP_VERS_B

751: MAX(start_active_date) start_active_date
752: FROM EGO_MTL_CATALOG_GRP_VERS_B
753: WHERE NVL(end_active_date, sysdate) >=
754: (SELECT NVL(start_active_date,SYSDATE)
755: FROM EGO_MTL_CATALOG_GRP_VERS_B
756: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
757: AND VERSION_SEQ_ID = p_icc_version_number -- bug 9980051
758: )
759: AND version_seq_id > 0

Line 764: FROM EGO_MTL_CATALOG_GRP_VERS_B

760:
761:
762: AND start_active_date <=
763: (SELECT NVL(start_active_date,SYSDATE)
764: FROM EGO_MTL_CATALOG_GRP_VERS_B
765: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
766: AND VERSION_SEQ_ID = p_icc_version_number -- bug 9980051
767: )
768:

Line 775: FROM EGO_MTL_CATALOG_GRP_VERS_B

771:
772: GROUP BY item_catalog_group_id
773: HAVING MAX(start_active_date)<=
774: (SELECT NVL(start_active_date,SYSDATE)
775: FROM EGO_MTL_CATALOG_GRP_VERS_B
776: WHERE ITEM_CATALOG_GROUP_ID = p_item_cat_group_id
777: AND VERSION_SEQ_ID = p_icc_version_number -- bug 9980051
778: )
779: )

Line 932: FROM EGO_MTL_CATALOG_GRP_VERS_B

928: )
929: IN
930: (SELECT item_catalog_group_id,
931: VERSION_SEQ_ID
932: FROM EGO_MTL_CATALOG_GRP_VERS_B
933: WHERE start_active_date <=
934: (SELECT NVL(start_active_date,SYSDATE)
935: FROM EGO_MTl_CATALOG_GRP_VERS_B
936: WHERE ITEM_CATALOG_GROUP_ID = CP_ITEM_CAT_GROUP_ID

Line 935: FROM EGO_MTl_CATALOG_GRP_VERS_B

931: VERSION_SEQ_ID
932: FROM EGO_MTL_CATALOG_GRP_VERS_B
933: WHERE start_active_date <=
934: (SELECT NVL(start_active_date,SYSDATE)
935: FROM EGO_MTl_CATALOG_GRP_VERS_B
936: WHERE ITEM_CATALOG_GROUP_ID = CP_ITEM_CAT_GROUP_ID
937: AND VERSION_SEQ_ID = 0
938: )
939: AND NVL(end_active_date, sysdate) >=

Line 941: FROM EGO_MTl_CATALOG_GRP_VERS_B

937: AND VERSION_SEQ_ID = 0
938: )
939: AND NVL(end_active_date, sysdate) >=
940: (SELECT NVL(start_active_date,SYSDATE)
941: FROM EGO_MTl_CATALOG_GRP_VERS_B
942: WHERE ITEM_CATALOG_GROUP_ID = CP_ITEM_CAT_GROUP_ID
943: AND VERSION_SEQ_ID = 0
944: )
945: AND version_seq_id > 0

Line 2213: ' FROM EGO_MTL_CATALOG_GRP_VERS_B ';

2209: ' item_catalog_group_id, ICC_VERSION_NUMBER '||
2210: ' ) '||
2211: ' IN '||
2212: ' ( SELECT item_catalog_group_id,VERSION_SEQ_ID '||
2213: ' FROM EGO_MTL_CATALOG_GRP_VERS_B ';
2214:
2215: IF (P_ICC_VERSION_NUMBER =0 ) THEN
2216: l_dynamic_sql := l_dynamic_sql ||
2217: ' WHERE start_active_date <= :6 '||

Line 2231: ' FROM EGO_MTL_CATALOG_GRP_VERS_B '||

2227: ' item_catalog_group_id,start_active_date '||
2228: ' ) '||
2229: ' IN '||
2230: ' ( SELECT item_catalog_group_id, MAX(start_active_date) start_active_date '||
2231: ' FROM EGO_MTL_CATALOG_GRP_VERS_B '||
2232: ' WHERE creation_date <= :6 '||
2233: ' AND version_seq_id > 0 '||
2234: ' AND start_active_date <= :7 '||
2235: ' GROUP BY item_catalog_group_id '||

Line 2363: ' FROM EGO_MTL_CATALOG_GRP_VERS_B ';

2359: ' item_catalog_group_id, ICC_VERSION_NUMBER '||
2360: ' ) '||
2361: ' IN '||
2362: ' ( SELECT item_catalog_group_id,VERSION_SEQ_ID '||
2363: ' FROM EGO_MTL_CATALOG_GRP_VERS_B ';
2364:
2365: IF (P_ICC_VERSION_NUMBER =0 ) THEN
2366: l_dynamic_sql := l_dynamic_sql ||
2367: ' WHERE start_active_date <= :6 '||

Line 2381: ' FROM EGO_MTL_CATALOG_GRP_VERS_B '||

2377: ' item_catalog_group_id,start_active_date '||
2378: ' ) '||
2379: ' IN '||
2380: ' ( SELECT item_catalog_group_id, MAX(start_active_date) start_active_date '||
2381: ' FROM EGO_MTL_CATALOG_GRP_VERS_B '||
2382: ' WHERE creation_date <= :6 '||
2383: ' AND version_seq_id > 0 '||
2384: ' AND start_active_date <= :7 '||
2385: ' GROUP BY item_catalog_group_id '||

Line 2579: FROM EGO_MTL_CATALOG_GRP_VERS_B

2575: item_catalog_group_id, ICC_VERSION_NUMBER
2576: )
2577: IN
2578: ( SELECT item_catalog_group_id,VERSION_SEQ_ID
2579: FROM EGO_MTL_CATALOG_GRP_VERS_B
2580: WHERE
2581: (
2582: item_catalog_group_id,start_active_date
2583: )

Line 2586: FROM EGO_MTL_CATALOG_GRP_VERS_B

2582: item_catalog_group_id,start_active_date
2583: )
2584: IN
2585: (SELECT item_catalog_group_id,MAX(start_active_date) start_active_date
2586: FROM EGO_MTL_CATALOG_GRP_VERS_B
2587: WHERE creation_date <= v_creation_date
2588: AND version_seq_id > 0
2589: AND start_active_date <= v_start_active_date
2590: GROUP BY item_catalog_group_id

Line 2648: FROM EGO_MTL_CATALOG_GRP_VERS_B

2644: )
2645: IN
2646: ( SELECT item_catalog_group_id,
2647: VERSION_SEQ_ID
2648: FROM EGO_MTL_CATALOG_GRP_VERS_B
2649: WHERE
2650: (
2651: item_catalog_group_id,start_active_date
2652: )

Line 2656: FROM EGO_MTL_CATALOG_GRP_VERS_B

2652: )
2653: IN
2654: (SELECT item_catalog_group_id,
2655: MAX(start_active_date) start_active_date
2656: FROM EGO_MTL_CATALOG_GRP_VERS_B
2657: WHERE creation_date <= v_creation_date
2658: AND version_seq_id > 0
2659: AND start_active_date <= v_start_active_date
2660: GROUP BY item_catalog_group_id

Line 2695: SELECT VERSION_SEQ_ID INTO l_version_seq_id FROM EGO_MTL_CATALOG_GRP_VERS_B

2691: AND ORGANIZATION_ID = p_organization_id AND REVISION_ID = p_revision_id;
2692:
2693: --Finding out which ICC version is effective at a time of item creation.
2694:
2695: SELECT VERSION_SEQ_ID INTO l_version_seq_id FROM EGO_MTL_CATALOG_GRP_VERS_B
2696: WHERE (ITEM_CATALOG_GROUP_ID, start_active_date) IN
2697: (
2698:
2699: SELECT ITEM_CATALOG_GROUP_ID,Max(START_ACTIVE_DATe) START_ACTIVE_DATe

Line 2700: FROM EGO_MTL_CATALOG_GRP_VERS_B

2696: WHERE (ITEM_CATALOG_GROUP_ID, start_active_date) IN
2697: (
2698:
2699: SELECT ITEM_CATALOG_GROUP_ID,Max(START_ACTIVE_DATe) START_ACTIVE_DATe
2700: FROM EGO_MTL_CATALOG_GRP_VERS_B
2701: WHERE CREATION_DATE <= l_creation_date AND
2702: ITEM_CATALOG_GROUP_ID = l_item_catalog_group_id AND
2703: START_ACTIVE_DATE <= l_efectivity_date AND VERSION_SEQ_ID >0
2704: GROUP BY ITEM_CATALOG_GROUP_ID

Line 2710: FROM EGO_MTL_CATALOG_GRP_VERS_B

2706: ) ;
2707: /*bug 8767080
2708: --Finding out start effcetive date and creation date of ICC Version
2709: SELECT START_ACTIVE_DATE,CREATION_DATE INTO l_icc_start_date, l_icc_create_date
2710: FROM EGO_MTL_CATALOG_GRP_VERS_B
2711: WHERE ITEM_CATALOG_GROUP_ID = l_item_catalog_group_id AND VERSION_SEQ_ID = l_version_seq_id;
2712: */
2713: END IF;
2714:

Line 2811: FROM EGO_MTL_CATALOG_GRP_VERS_B

2807: CLOSE get_Item_TA_metadata;
2808: ELSE IF (p_item_catalog_category_id IS NOT NULL AND p_icc_version IS NOT NULL) THEN
2809: /*Finding out start effcetive date and creation date of ICC Version */
2810: SELECT START_ACTIVE_DATE,CREATION_DATE INTO l_icc_start_date, l_icc_create_date
2811: FROM EGO_MTL_CATALOG_GRP_VERS_B
2812: WHERE ITEM_CATALOG_GROUP_ID = p_item_catalog_category_id AND VERSION_SEQ_ID = p_icc_version;
2813:
2814: OPEN GET_ICC_TA_METADATA(
2815: v_ITEM_CATALOG_GROUP_ID => p_item_catalog_category_id,