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.FUN_INITIATOR_WF_PKG dependencies on RA_BATCH_SOURCES_ALL

Line 660: RA_BATCH_SOURCES_ALL WHERE BATCH_SOURCE_ID = 22 AND org_id = l_ou_id;

656: --added this for gscc warning
657: -- Bug 9634573 fetched src name from the table
658:
659: SELECT name into l_line.BATCH_SOURCE_NAME FROM
660: RA_BATCH_SOURCES_ALL WHERE BATCH_SOURCE_ID = 22 AND org_id = l_ou_id;
661:
662: -- l_line.BATCH_SOURCE_NAME:= 'Global Intercompany';
663: l_line.INTERFACE_LINE_CONTEXT:='INTERNAL_ALLOCATIONS';
664: l_line.LINE_TYPE:='LINE';

Line 1179: ra_batch_sources_all rbs

1175: SELECT rct.trx_number invoice_number,
1176: rct.interface_header_attribute1 batch_id,
1177: rct.interface_header_attribute2 trx_id
1178: FROM ra_customer_trx_all rct,
1179: ra_batch_sources_all rbs
1180: WHERE rct.request_id=p_request_id
1181: AND rct.batch_source_id=rbs.batch_source_id
1182: AND NVL(rct.org_id, -99) =NVL(rbs.org_id, -99)
1183: AND rbs.name=(SELECT name FROM

Line 1184: RA_BATCH_SOURCES_ALL WHERE BATCH_SOURCE_ID = 22 AND org_id = rct.org_id);

1180: WHERE rct.request_id=p_request_id
1181: AND rct.batch_source_id=rbs.batch_source_id
1182: AND NVL(rct.org_id, -99) =NVL(rbs.org_id, -99)
1183: AND rbs.name=(SELECT name FROM
1184: RA_BATCH_SOURCES_ALL WHERE BATCH_SOURCE_ID = 22 AND org_id = rct.org_id);
1185:
1186:
1187: BEGIN
1188: l_request_id := p_event.GetValueForParameter('REQUEST_ID');

Line 1332: RA_BATCH_SOURCES_ALL RBS

1328: l_trx_header_type.attribute1,
1329: l_trx_header_type.attribute2,
1330: l_trx_header_type.invoice_number
1331: FROM RA_CUSTOMER_TRX_ALL RCT,
1332: RA_BATCH_SOURCES_ALL RBS
1333: WHERE RBS.name = (SELECT name FROM
1334: RA_BATCH_SOURCES_ALL WHERE BATCH_SOURCE_ID = 22 AND org_id = rct.org_id)
1335: AND RBS.batch_source_id = RCT.batch_source_id
1336: AND RBS.org_id = RCT.org_id

Line 1334: RA_BATCH_SOURCES_ALL WHERE BATCH_SOURCE_ID = 22 AND org_id = rct.org_id)

1330: l_trx_header_type.invoice_number
1331: FROM RA_CUSTOMER_TRX_ALL RCT,
1332: RA_BATCH_SOURCES_ALL RBS
1333: WHERE RBS.name = (SELECT name FROM
1334: RA_BATCH_SOURCES_ALL WHERE BATCH_SOURCE_ID = 22 AND org_id = rct.org_id)
1335: AND RBS.batch_source_id = RCT.batch_source_id
1336: AND RBS.org_id = RCT.org_id
1337: AND RCT.request_id = p_request_id;
1338: