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.IEX_PROMISES_BATCH_PUB dependencies on IEX_PRD_APPL_XREF

Line 1093: 'IEX_prd_appl_xref pax, ' ||

1089: 'pax.amount_applied, ' ||
1090: 'raa.receivable_application_id ' ||
1091: 'FROM ' ||
1092: 'AR_RECEIVABLE_APPLICATIONS raa, ' ||
1093: 'IEX_prd_appl_xref pax, ' ||
1094: 'iex_promise_details prd ' ||
1095: 'WHERE ' ||
1096: 'raa.receivable_application_id = pax.receivable_application_id and ' ||
1097: 'raa.status in (''APP'', ''ACC'') and ' ||

Line 1124: 'IEX_prd_appl_xref pax, ' ||

1120: 'pax.amount_applied, ' ||
1121: 'raa.receivable_application_id ' ||
1122: 'FROM ' ||
1123: 'IEX_OKL_PAYMENTS_V raa, ' ||
1124: 'IEX_prd_appl_xref pax, ' ||
1125: 'iex_promise_details prd ' ||
1126: 'WHERE ' ||
1127: 'raa.receivable_application_id = pax.receivable_application_id and ' ||
1128: 'raa.amount_applied > 0 and ' ||

Line 1146: 'IEX_prd_appl_xref pax, ' ||

1142: 'prd.amount_due_remaining, ' ||
1143: 'pax.amount_applied, ' ||
1144: 'pax.receivable_application_id ' ||
1145: 'FROM ' ||
1146: 'IEX_prd_appl_xref pax, ' ||
1147: 'iex_promise_details prd, ' ||
1148: 'AR_SYSTEM_PARAMETERS asp ' ||--Added for bug 73237026 barathsr 31-Dec-2008
1149: 'WHERE ' ||
1150: 'pax.receivable_application_id IN (select receivable_application_id from IEX_OKL_PAYMENTS_V where ' ||

Line 1227: LogMessage(G_PKG_NAME || '.' || l_api_name || ':updating records in IEX_prd_appl_xref with reversed_flag = Y...');

1223: END IF;
1224: end if;
1225:
1226: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1227: LogMessage(G_PKG_NAME || '.' || l_api_name || ':updating records in IEX_prd_appl_xref with reversed_flag = Y...');
1228: END IF;
1229:
1230: update IEX_prd_appl_xref
1231: set reversed_flag = 'Y',

Line 1230: update IEX_prd_appl_xref

1226: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1227: LogMessage(G_PKG_NAME || '.' || l_api_name || ':updating records in IEX_prd_appl_xref with reversed_flag = Y...');
1228: END IF;
1229:
1230: update IEX_prd_appl_xref
1231: set reversed_flag = 'Y',
1232: reversed_date = sysdate,
1233: last_update_date = sysdate,
1234: last_updated_by = G_USER_ID,

Line 1249: P_MESSAGE => 'Failed to update record in IEX_prd_appl_xref for promise_detail_id = ' || l_appl_tbl(i).promise_detail_id);

1245: /*
1246: IEX_CONC_REQUEST_MSG_PKG.Log_Error(
1247: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
1248: P_Procedure_name => G_PKG_NAME || '.' || l_api_name,
1249: P_MESSAGE => 'Failed to update record in IEX_prd_appl_xref for promise_detail_id = ' || l_appl_tbl(i).promise_detail_id);
1250: */
1251: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
1252: else
1253: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1896: 'IEX_prd_appl_xref pax ' ||

1892: 'NULL, ' ||
1893: 'NULL ' ||
1894: 'from ' ||
1895: 'AR_RECEIVABLE_APPLICATIONS raa, ' ||
1896: 'IEX_prd_appl_xref pax ' ||
1897: 'where ' ||
1898: '(trunc(raa.apply_date) between trunc(:PROMISE_CR_DATE) and trunc(sysdate)) and ' ||
1899: 'raa.status = ''APP'' and ' ||
1900: 'raa.amount_applied > 0 and ' ||

Line 1906: 'from IEX_prd_appl_xref where promise_detail_id = :PROMISE_ID and ' ||

1902: 'raa.applied_payment_schedule_id = :PSA_ID and ' ||
1903: 'raa.receivable_application_id = pax.receivable_application_id(+) and ' ||
1904: 'raa.receivable_application_id not in ' ||
1905: '(select receivable_application_id ' ||
1906: 'from IEX_prd_appl_xref where promise_detail_id = :PROMISE_ID and ' ||
1907: 'REVERSED_FLAG is null and REVERSED_DATE is null and receivable_application_id is NOT NULL) ' ||
1908: 'group by raa.receivable_application_id, raa.amount_applied, raa.apply_date ' ||
1909: 'order by raa.receivable_application_id';
1910:

Line 1921: 'iex_prd_appl_xref pax ' ||

1917: 'NULL, ' ||
1918: 'NULL, ' ||
1919: 'NULL ' ||
1920: 'FROM ar_receivable_applications raa, ' ||
1921: 'iex_prd_appl_xref pax ' ||
1922: 'WHERE(TRUNC(raa.apply_date) BETWEEN TRUNC(:promise_cr_date) ' ||
1923: 'AND TRUNC(sysdate)) ' ||
1924: 'AND raa.status = ''APP'' ' ||
1925: 'AND raa.amount_applied > 0 ' ||

Line 1931: 'FROM iex_prd_appl_xref ' ||

1927: 'AND raa.applied_payment_schedule_id = :psa_id ' ||
1928: 'AND raa.receivable_application_id = pax.receivable_application_id(+) ' ||
1929: 'AND raa.receivable_application_id NOT IN ' ||
1930: '(SELECT receivable_application_id ' ||
1931: 'FROM iex_prd_appl_xref ' ||
1932: 'WHERE promise_detail_id = :promise_id ' ||
1933: 'AND reversed_flag IS NULL ' ||
1934: 'AND reversed_date IS NULL AND receivable_application_id is NOT NULL) ' ||
1935: 'GROUP BY raa.receivable_application_id, ' ||

Line 1948: 'iex_prd_appl_xref pax ' ||

1944: '-ara.amount, ' ||
1945: 'ara.apply_date, ' ||
1946: '-ara.amount -nvl(SUM(pax.amount_applied), 0) ' ||
1947: 'FROM ar_adjustments ara, ' ||
1948: 'iex_prd_appl_xref pax ' ||
1949: 'WHERE(TRUNC(ara.apply_date) BETWEEN TRUNC(:promise_cr_date) ' ||
1950: 'AND TRUNC(sysdate)) ' ||
1951: 'AND ara.status = ''A'' ' ||
1952: 'AND ara.amount < 0 ' ||

Line 1957: 'FROM iex_prd_appl_xref ' ||

1953: 'AND ara.payment_schedule_id = :psa_id ' ||
1954: 'AND ara.adjustment_id = pax.adjustment_id(+) ' ||
1955: 'AND ara.adjustment_id NOT IN ' ||
1956: '(SELECT adjustment_id ' ||
1957: 'FROM iex_prd_appl_xref ' ||
1958: 'WHERE promise_detail_id = :promise_id AND adjustment_id is NOT NULL)' ||
1959: 'GROUP BY ara.adjustment_id, ' ||
1960: 'ara.amount, ' ||
1961: 'ara.apply_date';

Line 1995: 'IEX_prd_appl_xref pax, ' ||

1991: 'NULL, ' ||
1992: 'NULL ' ||
1993: 'from ' ||
1994: 'AR_RECEIVABLE_APPLICATIONS raa, ' ||
1995: 'IEX_prd_appl_xref pax, ' ||
1996: 'AR_PAYMENT_SCHEDULES psa ' ||
1997: 'where ' ||
1998: '(trunc(raa.apply_date) between trunc(:PROMISE_CR_DATE) and trunc(sysdate)) and ' ||
1999: 'raa.status = ''ACC'' and ' ||

Line 2007: 'from IEX_prd_appl_xref where promise_detail_id = :PROMISE_ID and ' ||

2003: 'psa.customer_id = :CUSTOMER_ID and ' ||
2004: 'raa.receivable_application_id = pax.receivable_application_id(+) and ' ||
2005: 'raa.receivable_application_id not in ' ||
2006: '(select receivable_application_id ' ||
2007: 'from IEX_prd_appl_xref where promise_detail_id = :PROMISE_ID and ' ||
2008: 'REVERSED_FLAG is null and REVERSED_DATE is null and receivable_application_id is NOT NULL) ' ||
2009: 'group by raa.receivable_application_id, raa.amount_applied, raa.apply_date ' ||
2010: 'order by raa.receivable_application_id';
2011:

Line 2024: 'IEX_prd_appl_xref pax ' ||

2020: 'raa.apply_date, ' ||
2021: 'raa.amount_applied - nvl(sum(pax.amount_applied), 0) ' ||
2022: 'from ' ||
2023: 'IEX_OKL_PAYMENTS_V raa, ' ||
2024: 'IEX_prd_appl_xref pax ' ||
2025: 'where ' ||
2026: '(trunc(raa.apply_date) between trunc(:PROMISE_CR_DATE) and trunc(sysdate)) and ' ||
2027: 'raa.amount_applied > 0 and ' ||
2028: 'raa.reversal_gl_date is null and ' ||

Line 2033: 'from IEX_prd_appl_xref where promise_detail_id = :PROMISE_ID and ' ||

2029: 'raa.contract_id = :CONTRACT_ID and ' ||
2030: 'raa.receivable_application_id = pax.receivable_application_id(+) and ' ||
2031: 'raa.receivable_application_id not in ' ||
2032: '(select receivable_application_id ' ||
2033: 'from IEX_prd_appl_xref where promise_detail_id = :PROMISE_ID and ' ||
2034: 'REVERSED_FLAG is null and REVERSED_DATE is null) ' ||
2035: 'group by raa.receivable_application_id, raa.amount_applied, raa.apply_date ' ||
2036: 'order by raa.receivable_application_id';
2037: */

Line 2052: ' IEX_prd_appl_xref PAX '||

2048: ' From ' ||
2049: ' OKL_CNSLD_AR_STRMS_B CNSLD, '||
2050: ' AR_RECEIVABLE_APPLICATIONS ARAPP, '||
2051: ' AR_PAYMENT_SCHEDULES PMTSCH, '||
2052: ' IEX_prd_appl_xref PAX '||
2053: ' Where '||
2054: ' CNSLD.khr_id = :CONTRACT_ID '||
2055: ' and CNSLD.receivables_invoice_id = PMTSCH.customer_trx_id '||
2056: ' and PMTSCH.class = ''INV'' '||

Line 2062: ' and ARAPP.receivable_application_id not in (select receivable_application_id from IEX_prd_appl_xref ' ||

2058: ' and (trunc(ARAPP.apply_date) between trunc(:PROMISE_CR_DATE) and trunc(sysdate)) '||
2059: ' and ARAPP.amount_applied > 0 '||
2060: ' and ARAPP.reversal_gl_date is null '||
2061: ' and ARAPP.receivable_application_id = PAX.receivable_application_id(+) '||
2062: ' and ARAPP.receivable_application_id not in (select receivable_application_id from IEX_prd_appl_xref ' ||
2063: ' where promise_detail_id = :PROMISE_ID and REVERSED_FLAG is null and REVERSED_DATE is null ' ||
2064: ' and receivable_application_id is NOT NULL) '||
2065: ' group by ARAPP.receivable_application_id, ARAPP.amount_applied, ARAPP.apply_date '||
2066: ' order by ARAPP.receivable_application_id ';

Line 2331: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Inserting into iex_prd_appl_xref values:');

2327: END IF;
2328: end if;
2329:
2330: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2331: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Inserting into iex_prd_appl_xref values:');
2332: END IF;
2333:
2334: FOR x in 1..l_applied_appl_count LOOP
2335: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2345: INSERT INTO iex_prd_appl_xref

2341: LogMessage(G_PKG_NAME || '.' || l_api_name || ':AR_ADJUSTED_AMOUNT = ' || l_appl_tbl(x).ar_adjusted_amount);
2342: LogMessage(G_PKG_NAME || '.' || l_api_name || ':PRO_APPLIED_AMOUNT = ' || l_appl_tbl(x).pro_applied_amount);
2343: END IF;
2344:
2345: INSERT INTO iex_prd_appl_xref
2346: (PRD_APPL_XREF_ID
2347: ,PROMISE_DETAIL_ID
2348: ,RECEIVABLE_APPLICATION_ID
2349: ,AMOUNT_APPLIED

Line 2364: iex_prd_appl_xref_s.NEXTVAL

2360: ,SECURITY_GROUP_ID
2361: ,REQUEST_ID
2362: ,ADJUSTMENT_ID)
2363: VALUES (
2364: iex_prd_appl_xref_s.NEXTVAL
2365: ,P_PROMISES_TBL(i).PROMISE_DETAIL_ID
2366: ,l_appl_tbl(x).receivable_application_id
2367: ,l_appl_tbl(x).pro_applied_amount
2368: ,sysdate