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.GCS_DATASUB_WF_PKG dependencies on GCS_ENTITIES_ATTR

Line 59: --Bugfix 5843592: Query modified to get the date effective source data details from gcs_entities_attr

55: '<>');
56: END IF;
57:
58: --Bugfix 4969879: Added support for data types data model.
59: --Bugfix 5843592: Query modified to get the date effective source data details from gcs_entities_attr
60:
61: SELECT gdsd.load_id,
62: gdsd.load_name,
63: gdsd.entity_id,

Line 104: gcs_entities_attr gea,

100: p_datasub_info.ds_balance_type_code
101: FROM gcs_data_sub_dtls gdsd,
102: fem_entities_b feb,
103: fem_ledgers_b flb,
104: gcs_entities_attr gea,
105: gcs_data_type_codes_b gdtcb,
106: fem_datasets_attr fda,
107: fem_cal_periods_attr fcpa
108: WHERE gdsd.load_id = p_load_id

Line 485: -- BugFix 5843592 : Use gcs_entities_attr instead of fem_entities_attr

481: IF (p_datasub_info.load_method_code = 'SNAPSHOT') THEN
482: fnd_file.put_line(fnd_file.log, 'Performing a snapshot load');
483: -- Submit Data for All Entities Associated to Balances Rules
484: -- Bugfix 5630225: Added balances_rule_id to the insert statement
485: -- BugFix 5843592 : Use gcs_entities_attr instead of fem_entities_attr
486: INSERT INTO gcs_data_sub_dtls
487: (load_id,
488: load_name,
489: entity_id,

Line 536: gcs_entities_attr gea,

532: gdsd.associated_request_id,
533: gdsd.status_code,
534: gdsd.balances_rule_id
535: FROM gcs_data_sub_dtls gdsd,
536: gcs_entities_attr gea,
537: fem_cal_periods_attr fcpa
538: WHERE gdsd.associated_request_id = FND_GLOBAL.CONC_REQUEST_ID
539: AND gea.entity_id <> p_datasub_info.entity_id
540: AND gea.balances_rule_id = gdsd.balances_rule_id

Line 2549: FROM gcs_entities_attr gea,

2545: -- Bugfix: 5843592, select entity ids
2546:
2547: SELECT gea.entity_id BULK COLLECT
2548: INTO l_entity_list
2549: FROM gcs_entities_attr gea,
2550: fem_entities_b feb,
2551: fem_cal_periods_attr fcpa
2552: WHERE gea.balances_rule_id = l_bal_rule_id
2553: AND gea.source_system_code = 10

Line 2837: gcs_entities_attr gea,

2833: FROM fem_companies_b f,
2834: fem_cctr_orgs_hier fcoh,
2835: fem_cctr_orgs_attr fcoa,
2836: gcs_entity_cctr_orgs geco,
2837: gcs_entities_attr gea,
2838: fem_entities_b feb,
2839: fem_cal_periods_attr fcpa
2840: WHERE feb.entity_id = gea.entity_id
2841: AND geco.entity_id = gea.entity_id

Line 2875: gcs_entities_attr gea,

2871: SELECT DISTINCT geo.entity_id BULK COLLECT
2872: INTO l_entity_list
2873: FROM fem_companies_b fcb,
2874: gcs_entity_organizations geo,
2875: gcs_entities_attr gea,
2876: fem_entities_b feb
2877: WHERE feb.entity_id = gea.entity_id
2878: AND geo.entity_id = gea.entity_id
2879: AND feb.enabled_flag = 'Y'

Line 3372: FROM gcs_entities_attr gea,

3368:
3369: SELECT gdsd.load_id,
3370: gdsd.most_recent_flag
3371: BULK COLLECT INTO l_load_list
3372: FROM gcs_entities_attr gea,
3373: gcs_data_sub_dtls gdsd,
3374: fem_cal_periods_attr fcpa
3375: WHERE gea.ledger_id = l_ledger_id
3376: AND gdsd.cal_period_id = l_cal_period_id

Line 3391: FROM gcs_entities_attr gea,

3387:
3388: SELECT gdsd.load_id,
3389: gdsd.most_recent_flag
3390: BULK COLLECT INTO l_load_list
3391: FROM gcs_entities_attr gea,
3392: gcs_data_sub_dtls gdsd,
3393: fem_cal_periods_attr fcpa
3394: WHERE gea.ledger_id = l_ledger_id
3395: AND gdsd.cal_period_id = l_cal_period_id