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_INTERCO_DYNAMIC_PKG dependencies on GCS_INTERCO_ELM_TRX

Line 34: -- Insert all eligible elimination lines from GCS_INTERCO_ELM_TRX

30: RETURN BOOLEAN IS
31:
32: l_api_name VARCHAR2(30) := 'INSR_INTERCO_LINES';
33:
34: -- Insert all eligible elimination lines from GCS_INTERCO_ELM_TRX
35: -- GCS_ENTRY-LINES.
36: BEGIN
37:
38: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 96: SELECT /*+ ORDERED FULL(GIHG) INDEX(GIET GCS_INTERCO_ELM_TRX_U1)

92: , USER_DIM8_ID, USER_DIM9_ID, USER_DIM10_ID
93: , YTD_CREDIT_BALANCE_E , YTD_DEBIT_BALANCE_E
94: , DESCRIPTION, YTD_BALANCE_E, RECEIVABLES_ORG_ID,
95: PAYABLES_ORG_ID )
96: SELECT /*+ ORDERED FULL(GIHG) INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
97: INDEX(GIM GCS_INTERCO_MEMBERS_U1) USE_NL(GIET GIM)
98: INDEX(GCR GCS_CONS_RELATIONSHIPS_N1)
99: INDEX (FB FEM_BALANCES_P)
100: USE_NL(GCR FB)*/

Line 117: GCS_INTERCO_ELM_TRX giet,

113: DECODE(MAX(gim.line_item_group), 2,
114: giet.company_cost_center_org_id,
115: giet.Intercompany_id)
116: FROM GCS_INTERCO_HDR_GT gihg,
117: GCS_INTERCO_ELM_TRX giet,
118: GCS_INTERCO_MEMBERS gim,
119: GCS_CONS_RELATIONSHIPS gcr,
120: FEM_BALANCES fb
121: WHERE giet.cal_period_id = p_cal_period_id

Line 184: SELECT /*+ ORDERED FULL(GIHG) INDEX(GIET GCS_INTERCO_ELM_TRX_U1)

180: , USER_DIM8_ID, USER_DIM9_ID, USER_DIM10_ID
181: , YTD_CREDIT_BALANCE_E , YTD_DEBIT_BALANCE_E
182: , DESCRIPTION, YTD_BALANCE_E, RECEIVABLES_ORG_ID,
183: PAYABLES_ORG_ID )
184: SELECT /*+ ORDERED FULL(GIHG) INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
185: INDEX(GIM GCS_INTERCO_MEMBERS_U1) USE_NL(GIET GIM)
186: INDEX(GCR GCS_CONS_RELATIONSHIPS_N1)
187: INDEX (FB FEM_BALANCES_P)
188: USE_NL(GCR FB)*/

Line 205: GCS_INTERCO_ELM_TRX giet,

201: DECODE(MAX(gim.line_item_group), 2,
202: giet.company_cost_center_org_id,
203: giet.Intercompany_id)
204: FROM GCS_INTERCO_HDR_GT gihg,
205: GCS_INTERCO_ELM_TRX giet,
206: GCS_INTERCO_MEMBERS gim,
207: GCS_CONS_RELATIONSHIPS gcr,
208: FEM_BALANCES fb
209: WHERE giet.cal_period_id = p_cal_period_id

Line 276: SELECT /*+ ORDERED FULL(GIHG) INDEX(GIET GCS_INTERCO_ELM_TRX_U1)

272: , USER_DIM8_ID, USER_DIM9_ID, USER_DIM10_ID
273: , YTD_CREDIT_BALANCE_E , YTD_DEBIT_BALANCE_E
274: , DESCRIPTION ,YTD_BALANCE_E, RECEIVABLES_ORG_ID,
275: PAYABLES_ORG_ID)
276: SELECT /*+ ORDERED FULL(GIHG) INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
277: INDEX(GIM GCS_INTERCO_MEMBERS_U1) USE_NL(GIET GIM)
278: INDEX(GCR GCS_CONS_RELATIONSHIPS_N1)
279: INDEX (FB FEM_BALANCES_P)
280: USE_NL(GCR FB)*/

Line 297: GCS_INTERCO_ELM_TRX giet,

293: DECODE(MAX(gim.line_item_group), 2,
294: giet.company_cost_center_org_id,
295: giet.Intercompany_id)
296: FROM GCS_INTERCO_HDR_GT gihg,
297: GCS_INTERCO_ELM_TRX giet,
298: GCS_INTERCO_MEMBERS gim,
299: GCS_CONS_RELATIONSHIPS gcr,
300: FEM_BALANCES fb
301: WHERE giet.cal_period_id = p_cal_period_id

Line 367: SELECT /*+ ORDERED FULL(GIHG) INDEX(GIET GCS_INTERCO_ELM_TRX_U1)

363: , USER_DIM8_ID, USER_DIM9_ID, USER_DIM10_ID
364: , YTD_CREDIT_BALANCE_E , YTD_DEBIT_BALANCE_E
365: , DESCRIPTION ,YTD_BALANCE_E, RECEIVABLES_ORG_ID,
366: PAYABLES_ORG_ID)
367: SELECT /*+ ORDERED FULL(GIHG) INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
368: INDEX(GIM GCS_INTERCO_MEMBERS_U1) USE_NL(GIET GIM)
369: INDEX(GCR GCS_CONS_RELATIONSHIPS_N1)
370: INDEX (FB FEM_BALANCES_P)
371: USE_NL(GCR FB)*/

Line 388: GCS_INTERCO_ELM_TRX giet,

384: DECODE(MAX(gim.line_item_group), 2,
385: giet.company_cost_center_org_id,
386: giet.Intercompany_id)
387: FROM GCS_INTERCO_HDR_GT gihg,
388: GCS_INTERCO_ELM_TRX giet,
389: GCS_INTERCO_MEMBERS gim,
390: GCS_CONS_RELATIONSHIPS gcr,
391: FEM_BALANCES fb
392: WHERE giet.cal_period_id = p_cal_period_id

Line 461: INDEX(GIET GCS_INTERCO_ELM_TRX_U1)

457: , YTD_CREDIT_BALANCE_E , YTD_DEBIT_BALANCE_E
458: , DESCRIPTION, YTD_BALANCE_E, RECEIVABLES_ORG_ID,
459: PAYABLES_ORG_ID)
460: SELECT /*+ ORDERED FULL(GIHG)
461: INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
462: INDEX(GIM GCS_INTERCO_MEMBERS_U1)
463: INDEX (FB FEM_BALANCES_P)
464: USE_NL(GIET FB)*/
465: gihg.entry_id, giet.company_cost_center_org_id

Line 481: GCS_INTERCO_ELM_TRX giet,

477: DECODE(MAX(gim.line_item_group), 2,
478: giet.company_cost_center_org_id,
479: giet.Intercompany_id)
480: FROM GCS_INTERCO_HDR_GT gihg,
481: GCS_INTERCO_ELM_TRX giet,
482: GCS_INTERCO_MEMBERS gim,
483: FEM_BALANCES fb
484: WHERE giet.cal_period_id = p_cal_period_id
485: AND giet.hierarchy_id = p_hierarchy_id

Line 503: FROM GCS_INTERCO_ELM_TRX giet3,

499: AND fb.ledger_id = P_fem_ledger_id
500: AND fb.source_system_code = 70
501:
502: AND NOT EXISTS (SELECT 1
503: FROM GCS_INTERCO_ELM_TRX giet3,
504: GCS_INTERCO_MEMBERS gim2
505: WHERE giet3.hierarchy_id = p_hierarchy_id
506: AND giet3.cal_period_id = p_cal_period_id
507: AND giet3.src_entity_id = giet3.target_entity_id

Line 559: INDEX(GIET GCS_INTERCO_ELM_TRX_U1)

555: , YTD_CREDIT_BALANCE_E , YTD_DEBIT_BALANCE_E
556: , DESCRIPTION , YTD_BALANCE_E,RECEIVABLES_ORG_ID,
557: PAYABLES_ORG_ID )
558: SELECT /*+ ORDERED FULL(GIHG)
559: INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
560: INDEX(GIM GCS_INTERCO_MEMBERS_U1)
561: INDEX (FB FEM_BALANCES_P)
562: USE_NL(GIET FB)*/
563: gihg.entry_id, giet.company_cost_center_org_id

Line 579: GCS_INTERCO_ELM_TRX giet,

575: DECODE(MAX(gim.line_item_group), 2,
576: giet.company_cost_center_org_id,
577: giet.Intercompany_id)
578: FROM GCS_INTERCO_HDR_GT gihg,
579: GCS_INTERCO_ELM_TRX giet,
580: GCS_INTERCO_MEMBERS gim,
581: FEM_BALANCES fb
582: WHERE giet.cal_period_id = p_cal_period_id
583: AND giet.hierarchy_id = p_hierarchy_id

Line 601: FROM GCS_INTERCO_ELM_TRX giet3,

597: AND fb.ledger_id = P_fem_ledger_id
598: AND fb.source_system_code = 70
599:
600: AND NOT EXISTS (SELECT 1
601: FROM GCS_INTERCO_ELM_TRX giet3,
602: GCS_INTERCO_MEMBERS gim2
603: WHERE giet3.hierarchy_id = p_hierarchy_id
604: AND giet3.cal_period_id = p_cal_period_id
605: AND giet3.src_entity_id = giet3.target_entity_id

Line 982: -- into GCS_INTERCO_ELM_TRX after dataprep operation.

978: -- Procedure
979: -- Insert_Interco_Trx
980: -- Purpose
981: -- Inserts eligible elimination transactions
982: -- into GCS_INTERCO_ELM_TRX after dataprep operation.
983: -- This procedure will be called from the Datapre package.
984: -- Arguments
985: -- P_entry_id Entry_id (created by dataprep) for the
986: -- monetary currency

Line 1177: || ' organization into GCS_INTERCO_ELM_TRX'

1173: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1174: fnd_log.STRING (fnd_log.level_procedure,
1175: g_pkg_name || '.' || l_api_name,
1176: 'Inserting intercompany transactions for matching by'
1177: || ' organization into GCS_INTERCO_ELM_TRX'
1178: || ' - LOB REPORTING ENABLED ');
1179: END IF;
1180: Insert INTO gcs_interco_elm_trx
1181: (hierarchy_id, cal_period_id, company_cost_center_org_id,

Line 1180: Insert INTO gcs_interco_elm_trx

1176: 'Inserting intercompany transactions for matching by'
1177: || ' organization into GCS_INTERCO_ELM_TRX'
1178: || ' - LOB REPORTING ENABLED ');
1179: END IF;
1180: Insert INTO gcs_interco_elm_trx
1181: (hierarchy_id, cal_period_id, company_cost_center_org_id,
1182: src_entity_id, src_company_id, src_cost_center_id,
1183: intercompany_id, target_company_id,
1184: target_cost_center_id, target_entity_id,

Line 1289: AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1

1285: -- *** To eliminte self rows
1286: AND fcch3.parent_id = fcch4.parent_id
1287: ))
1288:
1289: AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1
1290: WHERE giet1.hierarchy_id = geh.hierarchy_id
1291: AND giet1.cal_period_id = geh.start_cal_period_id
1292: AND giet1.company_cost_center_org_id =
1293: gel.company_cost_center_org_id

Line 1304: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');

1300:
1301: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1302: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1303: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1304: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1305:
1306: FND_LOG.String (fnd_log.level_procedure,
1307: g_pkg_name || '.' || l_api_name,
1308: 'SHRD0117: '||FND_MESSAGE.get);

Line 1320: || ' organization into GCS_INTERCO_ELM_TRX'

1316: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1317: fnd_log.STRING (fnd_log.level_procedure,
1318: g_pkg_name || '.' || l_api_name,
1319: 'Inserting intercompany transactions for matching by'
1320: || ' organization into GCS_INTERCO_ELM_TRX'
1321: || ' - LOB REPORTING ENABLED ');
1322: END IF;
1323: Insert INTO gcs_interco_elm_trx
1324: (hierarchy_id, cal_period_id, company_cost_center_org_id,

Line 1323: Insert INTO gcs_interco_elm_trx

1319: 'Inserting intercompany transactions for matching by'
1320: || ' organization into GCS_INTERCO_ELM_TRX'
1321: || ' - LOB REPORTING ENABLED ');
1322: END IF;
1323: Insert INTO gcs_interco_elm_trx
1324: (hierarchy_id, cal_period_id, company_cost_center_org_id,
1325: src_entity_id, src_company_id, src_cost_center_id,
1326: intercompany_id, target_company_id,
1327: target_cost_center_id, target_entity_id,

Line 1432: AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1

1428: -- *** To eliminte self rows
1429: AND fcch3.parent_id = fcch4.parent_id
1430: ))
1431:
1432: AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1
1433: WHERE giet1.hierarchy_id = geh.hierarchy_id
1434: AND giet1.cal_period_id = geh.start_cal_period_id
1435: AND giet1.company_cost_center_org_id =
1436: gel.company_cost_center_org_id

Line 1447: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');

1443:
1444: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1445: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1446: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1447: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1448:
1449: FND_LOG.String (fnd_log.level_procedure,
1450: g_pkg_name || '.' || l_api_name,
1451: 'SHRD0117: '||FND_MESSAGE.get);

Line 1466: || ' organization into GCS_INTERCO_ELM_TRX'

1462: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1463: fnd_log.STRING (fnd_log.level_procedure,
1464: g_pkg_name || '.' || l_api_name,
1465: 'Inserting intercompany transactions for matching by'
1466: || ' organization into GCS_INTERCO_ELM_TRX'
1467: || ' - LOB REPORTING Disabled');
1468: END IF;
1469:
1470: Insert INTO gcs_interco_elm_trx

Line 1470: Insert INTO gcs_interco_elm_trx

1466: || ' organization into GCS_INTERCO_ELM_TRX'
1467: || ' - LOB REPORTING Disabled');
1468: END IF;
1469:
1470: Insert INTO gcs_interco_elm_trx
1471: (hierarchy_id, cal_period_id, company_cost_center_org_id,
1472: src_entity_id, src_company_id, src_cost_center_id,
1473: intercompany_id, target_company_id,
1474: target_cost_center_id, target_entity_id,

Line 1522: AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1

1518: AND gcr1.child_entity_id = geo1.entity_id
1519: AND gcr1.actual_ownership_flag ='Y'
1520: AND gcr1.dominant_parent_flag = 'Y'
1521:
1522: AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1
1523: WHERE giet1.hierarchy_id = geh.hierarchy_id
1524: AND giet1.cal_period_id = geh.start_cal_period_id
1525: AND giet1.company_cost_center_org_id =
1526: gel.company_cost_center_org_id

Line 1538: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');

1534:
1535: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1536: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1537: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1538: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1539:
1540: FND_LOG.String (fnd_log.level_procedure,
1541: g_pkg_name || '.' || l_api_name,
1542: 'SHRD0117: '||FND_MESSAGE.get);

Line 1553: || ' organization into GCS_INTERCO_ELM_TRX'

1549: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1550: fnd_log.STRING (fnd_log.level_procedure,
1551: g_pkg_name || '.' || l_api_name,
1552: 'Inserting intercompany transactions for matching by'
1553: || ' organization into GCS_INTERCO_ELM_TRX'
1554: || ' - LOB REPORTING Disabled');
1555: END IF;
1556:
1557: Insert INTO gcs_interco_elm_trx

Line 1557: Insert INTO gcs_interco_elm_trx

1553: || ' organization into GCS_INTERCO_ELM_TRX'
1554: || ' - LOB REPORTING Disabled');
1555: END IF;
1556:
1557: Insert INTO gcs_interco_elm_trx
1558: (hierarchy_id, cal_period_id, company_cost_center_org_id,
1559: src_entity_id, src_company_id, src_cost_center_id,
1560: intercompany_id, target_company_id,
1561: target_cost_center_id, target_entity_id,

Line 1609: AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1

1605: AND gcr1.child_entity_id = geo1.entity_id
1606: AND gcr1.actual_ownership_flag ='Y'
1607: AND gcr1.dominant_parent_flag = 'Y'
1608:
1609: AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1
1610: WHERE giet1.hierarchy_id = geh.hierarchy_id
1611: AND giet1.cal_period_id = geh.start_cal_period_id
1612: AND giet1.company_cost_center_org_id =
1613: gel.company_cost_center_org_id

Line 1625: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');

1621:
1622: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1623: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1624: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1625: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1626:
1627: FND_LOG.String (fnd_log.level_procedure,
1628: g_pkg_name || '.' || l_api_name,
1629: 'SHRD0117: '||FND_MESSAGE.get);

Line 1645: ||' company intercompany into GCS_INTERCO_ELM_TRX');

1641: FND_LOG.String (fnd_log.level_procedure,
1642: g_pkg_name || '.' || l_api_name,
1643: 'Specific_Value - '
1644: ||' Inserting intercompany transactions for matching by'
1645: ||' company intercompany into GCS_INTERCO_ELM_TRX');
1646: END IF;
1647:
1648: Insert /* PARALLEL ( GCS_INTERCO_ELM_TRX) */
1649: INTO gcs_interco_elm_trx

Line 1648: Insert /* PARALLEL ( GCS_INTERCO_ELM_TRX) */

1644: ||' Inserting intercompany transactions for matching by'
1645: ||' company intercompany into GCS_INTERCO_ELM_TRX');
1646: END IF;
1647:
1648: Insert /* PARALLEL ( GCS_INTERCO_ELM_TRX) */
1649: INTO gcs_interco_elm_trx
1650: (hierarchy_id, cal_period_id, company_cost_center_org_id,
1651: src_entity_id, src_company_id, src_cost_center_id,
1652: intercompany_id, target_company_id,

Line 1649: INTO gcs_interco_elm_trx

1645: ||' company intercompany into GCS_INTERCO_ELM_TRX');
1646: END IF;
1647:
1648: Insert /* PARALLEL ( GCS_INTERCO_ELM_TRX) */
1649: INTO gcs_interco_elm_trx
1650: (hierarchy_id, cal_period_id, company_cost_center_org_id,
1651: src_entity_id, src_company_id, src_cost_center_id,
1652: intercompany_id, target_company_id,
1653: target_cost_center_id, target_entity_id,

Line 1718: AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1

1714: AND fcoa3.version_id =
1715: gcs_utility_pkg.g_dimension_attr_info('COMPANY_COST_CENTER_ORG_ID-COMPANY').version_id
1716:
1717:
1718: AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1
1719: WHERE giet1.hierarchy_id = geh.hierarchy_id
1720: AND giet1.cal_period_id = geh.start_cal_period_id
1721: AND giet1.company_cost_center_org_id =
1722: gel.company_cost_center_org_id

Line 1738: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');

1734:
1735: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1736: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1737: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1738: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1739:
1740: FND_LOG.String (fnd_log.level_procedure,
1741: g_pkg_name || '.' || l_api_name,
1742: 'SHRD0117: '||FND_MESSAGE.get);

Line 1757: ||' company intercompany into GCS_INTERCO_ELM_TRX');

1753: FND_LOG.String (fnd_log.level_procedure,
1754: g_pkg_name || '.' || l_api_name,
1755: ' Org and Interco are different - '
1756: ||'Inserting intercompany transactions for matching by'
1757: ||' company intercompany into GCS_INTERCO_ELM_TRX');
1758: END IF;
1759:
1760: Insert /* PARALLEL ( GCS_INTERCO_ELM_TRX) */
1761: INTO gcs_interco_elm_trx

Line 1760: Insert /* PARALLEL ( GCS_INTERCO_ELM_TRX) */

1756: ||'Inserting intercompany transactions for matching by'
1757: ||' company intercompany into GCS_INTERCO_ELM_TRX');
1758: END IF;
1759:
1760: Insert /* PARALLEL ( GCS_INTERCO_ELM_TRX) */
1761: INTO gcs_interco_elm_trx
1762: (hierarchy_id, cal_period_id, company_cost_center_org_id,
1763: src_entity_id, src_company_id, src_cost_center_id,
1764: intercompany_id, target_company_id,

Line 1761: INTO gcs_interco_elm_trx

1757: ||' company intercompany into GCS_INTERCO_ELM_TRX');
1758: END IF;
1759:
1760: Insert /* PARALLEL ( GCS_INTERCO_ELM_TRX) */
1761: INTO gcs_interco_elm_trx
1762: (hierarchy_id, cal_period_id, company_cost_center_org_id,
1763: src_entity_id, src_company_id, src_cost_center_id,
1764: intercompany_id, target_company_id,
1765: target_cost_center_id, target_entity_id,

Line 1831: AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1

1827: AND fcoa3.dim_attribute_numeric_member <>
1828: fcoa2.dim_attribute_numeric_member
1829:
1830:
1831: AND NOT EXISTS ( SELECT 1 FROM GCS_INTERCO_ELM_TRX giet1
1832: WHERE giet1.hierarchy_id = geh.hierarchy_id
1833: AND giet1.cal_period_id = geh.start_cal_period_id
1834: AND giet1.company_cost_center_org_id =
1835: gel.company_cost_center_org_id

Line 1851: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');

1847:
1848: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1849: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1850: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1851: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_ELM_TRX');
1852:
1853: FND_LOG.String (fnd_log.level_procedure,
1854: g_pkg_name || '.' || l_api_name,
1855: 'SHRD0117: '||FND_MESSAGE.get);