245: | FII_MEASURE2 - Number of Invoices |
246: +--------------------------------------------------------------*/
247:
248: /****************Messages to be displayed in the report**************/ /* Added for bug 3120355 */
249: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE1');
250: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE2');
251: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE3');
252: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE3');
253: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE2');
246: +--------------------------------------------------------------*/
247:
248: /****************Messages to be displayed in the report**************/ /* Added for bug 3120355 */
249: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE1');
250: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE2');
251: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE3');
252: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE3');
253: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE2');
254: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE1');
247:
248: /****************Messages to be displayed in the report**************/ /* Added for bug 3120355 */
249: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE1');
250: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE2');
251: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE3');
252: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE3');
253: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE2');
254: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE1');
255:
248: /****************Messages to be displayed in the report**************/ /* Added for bug 3120355 */
249: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE1');
250: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE2');
251: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE3');
252: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE3');
253: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE2');
254: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE1');
255:
256: -- Construct the sql query to be sent
249: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE1');
250: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE2');
251: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE3');
252: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE3');
253: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE2');
254: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE1');
255:
256: -- Construct the sql query to be sent
257: -- Following sql changed for customer bug-6028881. Added supplier to where clause
250: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE2');
251: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE3');
252: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE3');
253: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE2');
254: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE1');
255:
256: -- Construct the sql query to be sent
257: -- Following sql changed for customer bug-6028881. Added supplier to where clause
258: sqlstmt := '