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 1207: 'IEX_prd_appl_xref pax, ' ||

1203: 'pax.amount_applied, ' ||
1204: 'raa.receivable_application_id ' ||
1205: 'FROM ' ||
1206: 'AR_RECEIVABLE_APPLICATIONS raa, ' ||
1207: 'IEX_prd_appl_xref pax, ' ||
1208: 'iex_promise_details prd ' ||
1209: 'WHERE ' ||
1210: 'raa.receivable_application_id = pax.receivable_application_id and ' ||
1211: 'raa.status in (''APP'', ''ACC'') and ' ||

Line 1238: 'IEX_prd_appl_xref pax, ' ||

1234: 'pax.amount_applied, ' ||
1235: 'raa.receivable_application_id ' ||
1236: 'FROM ' ||
1237: 'IEX_OKL_PAYMENTS_V raa, ' ||
1238: 'IEX_prd_appl_xref pax, ' ||
1239: 'iex_promise_details prd ' ||
1240: 'WHERE ' ||
1241: 'raa.receivable_application_id = pax.receivable_application_id and ' ||
1242: 'raa.amount_applied > 0 and ' ||

Line 1260: 'IEX_prd_appl_xref pax, ' ||

1256: 'prd.amount_due_remaining, ' ||
1257: 'pax.amount_applied, ' ||
1258: 'pax.receivable_application_id ' ||
1259: 'FROM ' ||
1260: 'IEX_prd_appl_xref pax, ' ||
1261: 'iex_promise_details prd, ' ||
1262: 'AR_SYSTEM_PARAMETERS asp ' ||--Added for bug 73237026 barathsr 31-Dec-2008
1263: 'WHERE ' ||
1264: 'pax.receivable_application_id IN (select receivable_application_id from IEX_OKL_PAYMENTS_V where ' ||

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

1337: END IF;
1338: end if;
1339:
1340: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1341: LogMessage(G_PKG_NAME || '.' || l_api_name || ':updating records in IEX_prd_appl_xref with reversed_flag = Y...');
1342: END IF;
1343:
1344: update IEX_prd_appl_xref
1345: set reversed_flag = 'Y',

Line 1344: update IEX_prd_appl_xref

1340: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1341: LogMessage(G_PKG_NAME || '.' || l_api_name || ':updating records in IEX_prd_appl_xref with reversed_flag = Y...');
1342: END IF;
1343:
1344: update IEX_prd_appl_xref
1345: set reversed_flag = 'Y',
1346: reversed_date = sysdate,
1347: last_update_date = sysdate,
1348: last_updated_by = G_USER_ID,

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

1359: /*
1360: IEX_CONC_REQUEST_MSG_PKG.Log_Error(
1361: P_Concurrent_Request_ID => FND_GLOBAL.CONC_REQUEST_ID,
1362: P_Procedure_name => G_PKG_NAME || '.' || l_api_name,
1363: P_MESSAGE => 'Failed to update record in IEX_prd_appl_xref for promise_detail_id = ' || l_appl_tbl(i).promise_detail_id);
1364: */
1365: -- End - Andre Araujo - 09/30/2004- Remove obsolete logging
1366: else
1367: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2036: 'IEX_prd_appl_xref pax ' ||

2032: 'NULL, ' ||
2033: 'NULL ' ||
2034: 'from ' ||
2035: 'AR_RECEIVABLE_APPLICATIONS raa, ' ||
2036: 'IEX_prd_appl_xref pax ' ||
2037: 'where ' ||
2038: '(trunc(raa.apply_date) between trunc(:PROMISE_CR_DATE) and trunc(sysdate)) and ' ||
2039: 'raa.status = ''APP'' and ' ||
2040: 'raa.amount_applied > 0 and ' ||

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

2042: 'raa.applied_payment_schedule_id = :PSA_ID and ' ||
2043: 'raa.receivable_application_id = pax.receivable_application_id(+) and ' ||
2044: 'raa.receivable_application_id not in ' ||
2045: '(select receivable_application_id ' ||
2046: 'from IEX_prd_appl_xref where promise_detail_id = :PROMISE_ID and ' ||
2047: 'REVERSED_FLAG is null and REVERSED_DATE is null and receivable_application_id is NOT NULL) ' ||
2048: 'group by raa.receivable_application_id, raa.amount_applied, raa.apply_date ' ||
2049: 'order by raa.receivable_application_id';
2050:

Line 2061: 'iex_prd_appl_xref pax ' ||

2057: 'NULL, ' ||
2058: 'NULL, ' ||
2059: 'NULL ' ||
2060: 'FROM ar_receivable_applications raa, ' ||
2061: 'iex_prd_appl_xref pax ' ||
2062: 'WHERE(TRUNC(raa.apply_date) BETWEEN TRUNC(:promise_cr_date) ' ||
2063: 'AND TRUNC(sysdate)) ' ||
2064: 'AND raa.status = ''APP'' ' ||
2065: 'AND raa.amount_applied > 0 ' ||

Line 2071: 'FROM iex_prd_appl_xref ' ||

2067: 'AND raa.applied_payment_schedule_id = :psa_id ' ||
2068: 'AND raa.receivable_application_id = pax.receivable_application_id(+) ' ||
2069: 'AND raa.receivable_application_id NOT IN ' ||
2070: '(SELECT receivable_application_id ' ||
2071: 'FROM iex_prd_appl_xref ' ||
2072: 'WHERE promise_detail_id = :promise_id ' ||
2073: 'AND reversed_flag IS NULL ' ||
2074: 'AND reversed_date IS NULL AND receivable_application_id is NOT NULL) ' ||
2075: 'GROUP BY raa.receivable_application_id, ' ||

Line 2088: 'iex_prd_appl_xref pax ' ||

2084: '-ara.amount, ' ||
2085: 'ara.apply_date, ' ||
2086: '-ara.amount -nvl(SUM(pax.amount_applied), 0) ' ||
2087: 'FROM ar_adjustments ara, ' ||
2088: 'iex_prd_appl_xref pax ' ||
2089: 'WHERE(TRUNC(ara.apply_date) BETWEEN TRUNC(:promise_cr_date) ' ||
2090: 'AND TRUNC(sysdate)) ' ||
2091: 'AND ara.status = ''A'' ' ||
2092: 'AND ara.amount < 0 ' ||

Line 2097: 'FROM iex_prd_appl_xref ' ||

2093: 'AND ara.payment_schedule_id = :psa_id ' ||
2094: 'AND ara.adjustment_id = pax.adjustment_id(+) ' ||
2095: 'AND ara.adjustment_id NOT IN ' ||
2096: '(SELECT adjustment_id ' ||
2097: 'FROM iex_prd_appl_xref ' ||
2098: 'WHERE promise_detail_id = :promise_id AND adjustment_id is NOT NULL)' ||
2099: 'GROUP BY ara.adjustment_id, ' ||
2100: 'ara.amount, ' ||
2101: 'ara.apply_date';

Line 2135: 'IEX_prd_appl_xref pax, ' ||

2131: 'NULL, ' ||
2132: 'NULL ' ||
2133: 'from ' ||
2134: 'AR_RECEIVABLE_APPLICATIONS raa, ' ||
2135: 'IEX_prd_appl_xref pax, ' ||
2136: 'AR_PAYMENT_SCHEDULES psa ' ||
2137: 'where ' ||
2138: '(trunc(raa.apply_date) between trunc(:PROMISE_CR_DATE) and trunc(sysdate)) and ' ||
2139: 'raa.status = ''ACC'' and ' ||

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

2143: 'psa.customer_id = :CUSTOMER_ID and ' ||
2144: 'raa.receivable_application_id = pax.receivable_application_id(+) and ' ||
2145: 'raa.receivable_application_id not in ' ||
2146: '(select receivable_application_id ' ||
2147: 'from IEX_prd_appl_xref where promise_detail_id = :PROMISE_ID and ' ||
2148: 'REVERSED_FLAG is null and REVERSED_DATE is null and receivable_application_id is NOT NULL) ' ||
2149: 'group by raa.receivable_application_id, raa.amount_applied, raa.apply_date ' ||
2150: 'order by raa.receivable_application_id';
2151:

Line 2164: 'IEX_prd_appl_xref pax ' ||

2160: 'raa.apply_date, ' ||
2161: 'raa.amount_applied - nvl(sum(pax.amount_applied), 0) ' ||
2162: 'from ' ||
2163: 'IEX_OKL_PAYMENTS_V raa, ' ||
2164: 'IEX_prd_appl_xref pax ' ||
2165: 'where ' ||
2166: '(trunc(raa.apply_date) between trunc(:PROMISE_CR_DATE) and trunc(sysdate)) and ' ||
2167: 'raa.amount_applied > 0 and ' ||
2168: 'raa.reversal_gl_date is null and ' ||

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

2169: 'raa.contract_id = :CONTRACT_ID and ' ||
2170: 'raa.receivable_application_id = pax.receivable_application_id(+) and ' ||
2171: 'raa.receivable_application_id not in ' ||
2172: '(select receivable_application_id ' ||
2173: 'from IEX_prd_appl_xref where promise_detail_id = :PROMISE_ID and ' ||
2174: 'REVERSED_FLAG is null and REVERSED_DATE is null) ' ||
2175: 'group by raa.receivable_application_id, raa.amount_applied, raa.apply_date ' ||
2176: 'order by raa.receivable_application_id';
2177: */

Line 2192: ' IEX_prd_appl_xref PAX '||

2188: ' From ' ||
2189: ' OKL_CNSLD_AR_STRMS_B CNSLD, '||
2190: ' AR_RECEIVABLE_APPLICATIONS ARAPP, '||
2191: ' AR_PAYMENT_SCHEDULES PMTSCH, '||
2192: ' IEX_prd_appl_xref PAX '||
2193: ' Where '||
2194: ' CNSLD.khr_id = :CONTRACT_ID '||
2195: ' and CNSLD.receivables_invoice_id = PMTSCH.customer_trx_id '||
2196: ' and PMTSCH.class = ''INV'' '||

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

2198: ' and (trunc(ARAPP.apply_date) between trunc(:PROMISE_CR_DATE) and trunc(sysdate)) '||
2199: ' and ARAPP.amount_applied > 0 '||
2200: ' and ARAPP.reversal_gl_date is null '||
2201: ' and ARAPP.receivable_application_id = PAX.receivable_application_id(+) '||
2202: ' and ARAPP.receivable_application_id not in (select receivable_application_id from IEX_prd_appl_xref ' ||
2203: ' where promise_detail_id = :PROMISE_ID and REVERSED_FLAG is null and REVERSED_DATE is null ' ||
2204: ' and receivable_application_id is NOT NULL) '||
2205: ' group by ARAPP.receivable_application_id, ARAPP.amount_applied, ARAPP.apply_date '||
2206: ' order by ARAPP.receivable_application_id ';

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

2467: END IF;
2468: end if;
2469:
2470: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2471: LogMessage(G_PKG_NAME || '.' || l_api_name || ':Inserting into iex_prd_appl_xref values:');
2472: END IF;
2473:
2474: FOR x in 1..l_applied_appl_count LOOP
2475: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2485: INSERT INTO iex_prd_appl_xref

2481: LogMessage(G_PKG_NAME || '.' || l_api_name || ':AR_ADJUSTED_AMOUNT = ' || l_appl_tbl(x).ar_adjusted_amount);
2482: LogMessage(G_PKG_NAME || '.' || l_api_name || ':PRO_APPLIED_AMOUNT = ' || l_appl_tbl(x).pro_applied_amount);
2483: END IF;
2484:
2485: INSERT INTO iex_prd_appl_xref
2486: (PRD_APPL_XREF_ID
2487: ,PROMISE_DETAIL_ID
2488: ,RECEIVABLE_APPLICATION_ID
2489: ,AMOUNT_APPLIED

Line 2504: iex_prd_appl_xref_s.NEXTVAL

2500: ,SECURITY_GROUP_ID
2501: ,REQUEST_ID
2502: ,ADJUSTMENT_ID)
2503: VALUES (
2504: iex_prd_appl_xref_s.NEXTVAL
2505: ,P_PROMISES_TBL(i).PROMISE_DETAIL_ID
2506: ,l_appl_tbl(x).receivable_application_id
2507: ,l_appl_tbl(x).pro_applied_amount
2508: ,sysdate