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_ODI_PUB dependencies on EGO_PUB_WS_FLAT_RECS_S

Line 7534: EGO_PUB_WS_FLAT_RECS_S.NEXTVAL ,

7530: )
7531: (SELECT p_session_id ,
7532: p_odi_session_id ,
7533: 'TransactionAttribute' ,
7534: EGO_PUB_WS_FLAT_RECS_S.NEXTVAL ,
7535: j.sequence_id ,
7536: 1 ,
7537: l_icc_ta_metadata_tbl(i).attrid ,
7538: j.icc_id ,

Line 7575: SELECT ego_pub_ws_flat_recs.sequence_id,

7571: p_ODISession_Id IN NUMBER)
7572: IS
7573:
7574: CURSOR Table_VS_List IS -- Get all the TableInfo entity type records from Flat table for given Session Id and ODI Session Id
7575: SELECT ego_pub_ws_flat_recs.sequence_id,
7576: ego_validation_table_info_v.flex_value_set_id,
7577: ego_validation_table_info_v.additional_where_clause
7578:
7579: FROM ego_pub_ws_flat_recs,

Line 7583: AND ego_pub_ws_flat_recs.session_id = p_Session_Id

7579: FROM ego_pub_ws_flat_recs,
7580: ego_validation_table_info_v
7581:
7582: WHERE ego_pub_ws_flat_recs.pk1_value = ego_validation_table_info_v.flex_value_set_id
7583: AND ego_pub_ws_flat_recs.session_id = p_Session_Id
7584: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id
7585: AND ego_pub_ws_flat_recs.entity_type = 'TableInfo';
7586:
7587: TempLong LONG; -- Temporary variable

Line 7609: ego_pub_ws_flat_recs_s.nextval,

7605: )
7606: SELECT p_Session_Id,
7607: p_ODISession_Id,
7608: 'TableInfo',
7609: ego_pub_ws_flat_recs_s.nextval,
7610: ego_pub_ws_flat_recs.sequence_id,
7611: ego_validation_table_info_v.flex_value_set_id,
7612: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),
7613: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),

Line 7610: ego_pub_ws_flat_recs.sequence_id,

7606: SELECT p_Session_Id,
7607: p_ODISession_Id,
7608: 'TableInfo',
7609: ego_pub_ws_flat_recs_s.nextval,
7610: ego_pub_ws_flat_recs.sequence_id,
7611: ego_validation_table_info_v.flex_value_set_id,
7612: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),
7613: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),
7614: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),

Line 7630: ego_pub_ws_flat_recs.session_id = p_Session_Id

7626: FROM ego_pub_ws_flat_recs,
7627: ego_validation_table_info_v
7628: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id
7629: AND (
7630: ego_pub_ws_flat_recs.session_id = p_Session_Id
7631: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id
7632: AND ego_pub_ws_flat_recs.entity_type = 'ValueSet'
7633: AND ego_pub_ws_flat_recs.pk2_value IS NULL
7634: AND ego_pub_ws_flat_recs.ref1_value = 'F'

Line 7653: ego_pub_ws_flat_recs_s.nextval,

7649: )
7650: SELECT p_Session_Id,
7651: p_ODISession_Id,
7652: 'WhereClause',
7653: ego_pub_ws_flat_recs_s.nextval,
7654: ego_pub_ws_flat_recs.sequence_id,
7655: ego_validation_table_info_v.flex_value_set_id,
7656: To_Lob(ego_validation_table_info_v.additional_where_clause),
7657: SYSDATE

Line 7654: ego_pub_ws_flat_recs.sequence_id,

7650: SELECT p_Session_Id,
7651: p_ODISession_Id,
7652: 'WhereClause',
7653: ego_pub_ws_flat_recs_s.nextval,
7654: ego_pub_ws_flat_recs.sequence_id,
7655: ego_validation_table_info_v.flex_value_set_id,
7656: To_Lob(ego_validation_table_info_v.additional_where_clause),
7657: SYSDATE
7658: FROM ego_pub_ws_flat_recs,

Line 7662: ego_pub_ws_flat_recs.session_id = p_Session_Id

7658: FROM ego_pub_ws_flat_recs,
7659: ego_validation_table_info_v
7660: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id
7661: AND (
7662: ego_pub_ws_flat_recs.session_id = p_Session_Id
7663: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id
7664: AND ego_pub_ws_flat_recs.entity_type = 'TableInfo'
7665: );*/
7666:

Line 7689: ego_pub_ws_flat_recs_s.nextval, -- Sequence Id for record

7685: (
7686: p_Session_Id ,
7687: p_ODISession_Id ,
7688: 'WhereClause' ,
7689: ego_pub_ws_flat_recs_s.nextval, -- Sequence Id for record
7690: rec.sequence_id , -- Parent record Sequence Id
7691: rec.flex_value_set_id , -- VlaueSet Id
7692: TempLong , -- enclosed WhereClause value
7693: SYSDATE

Line 7707: SELECT ego_pub_ws_flat_recs.sequence_id,

7703: p_ODISession_Id IN NUMBER)
7704: IS
7705:
7706: CURSOR Table_VS_List IS -- Get all the 'TableInfo' entity type records from Flat table for given Session Id and ODI Session Id
7707: SELECT ego_pub_ws_flat_recs.sequence_id,
7708: ego_validation_table_info_v.flex_value_set_id,
7709: ego_validation_table_info_v.additional_where_clause
7710:
7711: FROM ego_pub_ws_flat_recs,

Line 7715: AND ego_pub_ws_flat_recs.session_id = p_Session_Id

7711: FROM ego_pub_ws_flat_recs,
7712: ego_validation_table_info_v
7713:
7714: WHERE ego_pub_ws_flat_recs.pk1_value = ego_validation_table_info_v.flex_value_set_id
7715: AND ego_pub_ws_flat_recs.session_id = p_Session_Id
7716: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id
7717: AND ego_pub_ws_flat_recs.entity_type = 'TableInfo';
7718:
7719: TempLong LONG; -- Temporary variable

Line 7741: ego_pub_ws_flat_recs_s.nextval,

7737: )
7738: SELECT p_Session_Id,
7739: p_ODISession_Id,
7740: 'TableInfo',
7741: ego_pub_ws_flat_recs_s.nextval,
7742: ego_pub_ws_flat_recs.sequence_id,
7743: ego_validation_table_info_v.flex_value_set_id,
7744: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),
7745: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),

Line 7742: ego_pub_ws_flat_recs.sequence_id,

7738: SELECT p_Session_Id,
7739: p_ODISession_Id,
7740: 'TableInfo',
7741: ego_pub_ws_flat_recs_s.nextval,
7742: ego_pub_ws_flat_recs.sequence_id,
7743: ego_validation_table_info_v.flex_value_set_id,
7744: XMLCONCAT( XMLELEMENT("AppName",ego_validation_table_info_v.table_application_name),
7745: XMLELEMENT("AppId",ego_validation_table_info_v.table_application_id),
7746: XMLELEMENT("TableName",ego_validation_table_info_v.application_table_name),

Line 7762: ego_pub_ws_flat_recs.session_id = p_Session_Id

7758: FROM ego_pub_ws_flat_recs,
7759: ego_validation_table_info_v
7760: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id
7761: AND (
7762: ego_pub_ws_flat_recs.session_id = p_Session_Id
7763: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id
7764: AND ego_pub_ws_flat_recs.entity_type = 'Valueset'
7765: AND ego_pub_ws_flat_recs.ref1_value = 'UDA'
7766: AND ego_pub_ws_flat_recs.ref2_value = 'F'

Line 7785: ego_pub_ws_flat_recs_s.nextval,

7781: )
7782: SELECT p_Session_Id,
7783: p_ODISession_Id,
7784: 'WhereClause',
7785: ego_pub_ws_flat_recs_s.nextval,
7786: ego_pub_ws_flat_recs.sequence_id,
7787: ego_validation_table_info_v.flex_value_set_id,
7788: To_Lob(ego_validation_table_info_v.additional_where_clause),
7789: SYSDATE

Line 7786: ego_pub_ws_flat_recs.sequence_id,

7782: SELECT p_Session_Id,
7783: p_ODISession_Id,
7784: 'WhereClause',
7785: ego_pub_ws_flat_recs_s.nextval,
7786: ego_pub_ws_flat_recs.sequence_id,
7787: ego_validation_table_info_v.flex_value_set_id,
7788: To_Lob(ego_validation_table_info_v.additional_where_clause),
7789: SYSDATE
7790: FROM ego_pub_ws_flat_recs,

Line 7794: ego_pub_ws_flat_recs.session_id = p_Session_Id

7790: FROM ego_pub_ws_flat_recs,
7791: ego_validation_table_info_v
7792: WHERE ego_pub_ws_flat_recs.pk1_value=ego_validation_table_info_v.flex_value_set_id
7793: AND (
7794: ego_pub_ws_flat_recs.session_id = p_Session_Id
7795: AND ego_pub_ws_flat_recs.odi_session_id = p_ODISession_Id
7796: AND ego_pub_ws_flat_recs.entity_type = 'TableInfo'
7797: );*/
7798:

Line 7821: ego_pub_ws_flat_recs_s.nextval, -- Sequence Id for record

7817: (
7818: p_Session_Id ,
7819: p_ODISession_Id ,
7820: 'WhereClause' ,
7821: ego_pub_ws_flat_recs_s.nextval, -- Sequence Id for record
7822: rec.sequence_id , -- Parent record Sequence Id
7823: rec.flex_value_set_id , -- VlaueSet Id
7824: TempLong , -- enclosed WhereClause value
7825: SYSDATE