APPS.LNS_REP_UTILS dependencies on XMLAGG

Line 1152: XMLAGG(

1148: ),
1149: -- Loan_Participants
1150: (select
1151: XMLELEMENT("LOAN_PARTICIPANTS",
1152: XMLAGG(
1153: XMLELEMENT("LOAN_PARTICIPANTS_ROW", XMLATTRIBUTES (rownum AS "num"),
1154: XMLFOREST(
1155: party.party_name participant_name,
1156: party.JGZZ_FISCAL_CODE participant_tax_id,

Line 1203: XMLAGG(

1199: ), -- end of LOAN_PARTICIPANTS
1200: -- DISB_RATE_SCHEDULE
1201: (select
1202: XMLELEMENT("DISB_RATE_SCHEDULE",
1203: XMLAGG(
1204: XMLELEMENT("DISB_RATE_SCHEDULE_ROW", XMLATTRIBUTES (rownum AS "num"),
1205: XMLFOREST(
1206: BEGIN_INSTALLMENT_NUMBER installment_from
1207: ,END_INSTALLMENT_NUMBER installment_to

Line 1222: XMLAGG(

1218: ), -- end of DISB_RATE_SCHEDULE
1219: -- RATE_SCHEDULE
1220: (select
1221: XMLELEMENT("RATE_SCHEDULE",
1222: XMLAGG(
1223: XMLELEMENT("RATE_SCHEDULE_ROW", XMLATTRIBUTES (rownum AS "num"),
1224: XMLFOREST(
1225: BEGIN_INSTALLMENT_NUMBER installment_from
1226: ,END_INSTALLMENT_NUMBER installment_to

Line 1241: XMLAGG(

1237: ), -- end of RATE_SCHEDULE
1238: -- COLLATERAL
1239: (select
1240: XMLELEMENT("COLLATERAL",
1241: XMLAGG(
1242: XMLELEMENT("COLLATERAL_ROW", XMLATTRIBUTES (rownum AS "num"),
1243: XMLFOREST(
1244: assetassign.PLEDGED_AMOUNT,
1245: assetassign.START_DATE_ACTIVE,

Line 1294: XMLAGG(

1290: ), -- end of COLLATERAL
1291: -- FEES
1292: (select
1293: XMLELEMENT("FEES",
1294: XMLAGG(
1295: XMLELEMENT("FEES_ROW", XMLATTRIBUTES (rownum AS "num"),
1296: XMLFOREST(
1297: lfa.FEE, lfa.FEE_TYPE, lfa.FEE_BASIS, lfa.RATE_TYPE,
1298: lfa.BILLING_OPTION BILLING_OPTION_CODE,

Line 1335: XMLAGG(

1331: ), -- end of FEES
1332: -- CONDITIONS
1333: (select
1334: XMLELEMENT("CONDITIONS",
1335: XMLAGG(
1336: XMLELEMENT("CONDITIONS_ROW", XMLATTRIBUTES (rownum AS "num"),
1337: XMLFOREST(
1338: lc.CONDITION_NAME,
1339: lca.CONDITION_DESCRIPTION,

Line 1360: XMLAGG(

1356: ), -- end of CONDITIONS
1357: -- ORIGINAL_RECEIVABLES
1358: (select
1359: XMLELEMENT("ORIGINAL_RECEIVABLES",
1360: XMLAGG(
1361: XMLELEMENT("ORIGINAL_RECEIVABLES_ROW", XMLATTRIBUTES (rownum AS "num"),
1362: XMLFOREST(
1363: lll.REFERENCE_NUMBER original_rec_number,
1364: lll.REFERENCE_AMOUNT original_rec_balance,

Line 1390: XMLAGG(

1386: ), -- end of ORIGINAL_RECEIVABLES
1387: -- DISBURSEMENTS
1388: (select
1389: XMLELEMENT("DISBURSEMENTS",
1390: XMLAGG(
1391: XMLELEMENT("DISBURSEMENTS_ROW", XMLATTRIBUTES (rownum AS "num"),
1392: XMLFOREST(
1393: disbursement_number
1394: ,llkac.meaning disbursement_activity

Line 1402: XMLAGG(

1398: ),
1399: -- PAYEES
1400: (select
1401: XMLELEMENT("PAYEES",
1402: XMLAGG(
1403: XMLELEMENT("PAYEES_ROW", XMLATTRIBUTES (rownum AS "num"),
1404: XMLFOREST(
1405: party.party_name payee_name
1406: ,party.ADDRESS1 || ' ' || party.ADDRESS2 || ' ' ||

Line 1427: XMLAGG(

1423: ),-- end of PAYEES
1424: -- DISBFEES
1425: (select
1426: XMLELEMENT("DISBFEES",
1427: XMLAGG(
1428: XMLELEMENT("DISBFEES_ROW", XMLATTRIBUTES (rownum AS "num"),
1429: XMLFOREST(
1430: lfa.FEE, lfa.FEE_TYPE,
1431: lfa.FEE_BASIS,

Line 1470: XMLAGG(

1466: ), -- end of DISBFEES
1467: -- DISBCOND
1468: (select
1469: XMLELEMENT("DISBCOND",
1470: XMLAGG(
1471: XMLELEMENT("DISBCOND_ROW", XMLATTRIBUTES (rownum AS "num"),
1472: XMLFOREST(
1473: lc.CONDITION_NAME,
1474: lca.CONDITION_DESCRIPTION,

Line 1503: XMLAGG(

1499: ), -- end of DISBURSEMENTS
1500: -- AMORTIZATION
1501: (select
1502: XMLELEMENT("AMORTIZATION",
1503: XMLAGG(
1504: XMLELEMENT("AMORTIZATION_ROW", XMLATTRIBUTES (rownum AS "num"),
1505: XMLFOREST(
1506: INSTALLMENT_NUMBER PAYMENT_NUMBER
1507: ,to_char(DUE_DATE, 'MM/DD/YYYY') DUE_DATE