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_EXT_FWK_PUB dependencies on EGO_ATTRS_V

Line 2746: v_source_ag_app_id IN EGO_ATTRS_V.APPLICATION_ID%TYPE

2742: l_msg_data VARCHAR2(1000);
2743:
2744: CURSOR ego_attribute_csr
2745: (
2746: v_source_ag_app_id IN EGO_ATTRS_V.APPLICATION_ID%TYPE
2747: ,v_source_ag_type IN EGO_ATTRS_V.ATTR_GROUP_TYPE%TYPE
2748: ,v_source_ag_name IN EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE
2749: ) IS
2750: SELECT APPLICATION_ID,

Line 2747: ,v_source_ag_type IN EGO_ATTRS_V.ATTR_GROUP_TYPE%TYPE

2743:
2744: CURSOR ego_attribute_csr
2745: (
2746: v_source_ag_app_id IN EGO_ATTRS_V.APPLICATION_ID%TYPE
2747: ,v_source_ag_type IN EGO_ATTRS_V.ATTR_GROUP_TYPE%TYPE
2748: ,v_source_ag_name IN EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE
2749: ) IS
2750: SELECT APPLICATION_ID,
2751: ATTR_GROUP_TYPE,

Line 2748: ,v_source_ag_name IN EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE

2744: CURSOR ego_attribute_csr
2745: (
2746: v_source_ag_app_id IN EGO_ATTRS_V.APPLICATION_ID%TYPE
2747: ,v_source_ag_type IN EGO_ATTRS_V.ATTR_GROUP_TYPE%TYPE
2748: ,v_source_ag_name IN EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE
2749: ) IS
2750: SELECT APPLICATION_ID,
2751: ATTR_GROUP_TYPE,
2752: ATTR_GROUP_NAME,

Line 2769: FROM EGO_ATTRS_V

2765: DISPLAY_CODE,
2766: DATABASE_COLUMN,
2767: UOM_CLASS,
2768: DECODE(DISPLAY_CODE,'D',1,0) DISP_CODE --bugFix:5589398
2769: FROM EGO_ATTRS_V
2770: WHERE APPLICATION_ID = v_source_ag_app_id
2771: AND ATTR_GROUP_TYPE = v_source_ag_type
2772: AND ATTR_GROUP_NAME = v_source_ag_name
2773: ORDER BY DISP_CODE, SEQUENCE;

Line 2775: l_sequence ego_attrs_v.sequence%TYPE;

2771: AND ATTR_GROUP_TYPE = v_source_ag_type
2772: AND ATTR_GROUP_NAME = v_source_ag_name
2773: ORDER BY DISP_CODE, SEQUENCE;
2774:
2775: l_sequence ego_attrs_v.sequence%TYPE;
2776: ego_attribute_rec ego_attribute_csr%ROWTYPE;
2777: l_sequence_numbers VARCHAR2(10000);
2778:
2779: BEGIN

Line 9334: FROM EGO_ATTR_GROUPS_V AGV, EGO_ATTRS_V AV

9330: FROM EGO_ATTR_GROUPS_V WHERE ATTR_GROUP_ID = p_attr_group_id;
9331:
9332: SELECT Count(1)
9333: INTO l_attr_count
9334: FROM EGO_ATTR_GROUPS_V AGV, EGO_ATTRS_V AV
9335: WHERE AGV.APPLICATION_ID = AV.APPLICATION_ID
9336: AND AGV.ATTR_GROUP_TYPE = AV.ATTR_GROUP_TYPE
9337: AND AGV.ATTR_GROUP_NAME = AV.ATTR_GROUP_NAME
9338: AND AGV.ATTR_GROUP_ID = p_attr_group_id;

Line 15631: FROM EGO_ATTRS_V AV

15627: WHERE AGV.APPLICATION_ID = MA.MAPPED_TO_GROUP_PK1
15628: AND AGV.ATTR_GROUP_TYPE = MA.MAPPED_TO_GROUP_PK2
15629: AND AGV.ATTR_GROUP_NAME = MA.MAPPED_TO_GROUP_PK3) ATTR_GROUP_DISP_NAME,
15630: (SELECT AV.SEQUENCE
15631: FROM EGO_ATTRS_V AV
15632: WHERE AV.APPLICATION_ID = MA.MAPPED_TO_GROUP_PK1
15633: AND AV.ATTR_GROUP_TYPE = MA.MAPPED_TO_GROUP_PK2
15634: AND AV.ATTR_GROUP_NAME = MA.MAPPED_TO_GROUP_PK3
15635: AND AV.ATTR_NAME = MA.MAPPED_ATTRIBUTE) SEQUENCE,

Line 15637: FROM EGO_ATTRS_V AV

15633: AND AV.ATTR_GROUP_TYPE = MA.MAPPED_TO_GROUP_PK2
15634: AND AV.ATTR_GROUP_NAME = MA.MAPPED_TO_GROUP_PK3
15635: AND AV.ATTR_NAME = MA.MAPPED_ATTRIBUTE) SEQUENCE,
15636: DECODE((SELECT AV.DISPLAY_CODE
15637: FROM EGO_ATTRS_V AV
15638: WHERE AV.APPLICATION_ID = MA.MAPPED_TO_GROUP_PK1
15639: AND AV.ATTR_GROUP_TYPE = MA.MAPPED_TO_GROUP_PK2
15640: AND AV.ATTR_GROUP_NAME = MA.MAPPED_TO_GROUP_PK3
15641: AND AV.ATTR_NAME = MA.MAPPED_ATTRIBUTE),