APPS.LNS_REP_UTILS dependencies on XMLAGG

Line 1246: XMLAGG(

1242: ),
1243: -- Loan_Participants
1244: (select
1245: XMLELEMENT("LOAN_PARTICIPANTS",
1246: XMLAGG(
1247: XMLELEMENT("LOAN_PARTICIPANTS_ROW", XMLATTRIBUTES (rownum AS "num"),
1248: XMLFOREST(
1249: party.party_name participant_name,
1250: party.JGZZ_FISCAL_CODE participant_tax_id,

Line 1297: XMLAGG(

1293: ), -- end of LOAN_PARTICIPANTS
1294: -- DISB_RATE_SCHEDULE
1295: (select
1296: XMLELEMENT("DISB_RATE_SCHEDULE",
1297: XMLAGG(
1298: XMLELEMENT("DISB_RATE_SCHEDULE_ROW", XMLATTRIBUTES (rownum AS "num"),
1299: XMLFOREST(
1300: BEGIN_INSTALLMENT_NUMBER installment_from
1301: ,END_INSTALLMENT_NUMBER installment_to

Line 1316: XMLAGG(

1312: ), -- end of DISB_RATE_SCHEDULE
1313: -- RATE_SCHEDULE
1314: (select
1315: XMLELEMENT("RATE_SCHEDULE",
1316: XMLAGG(
1317: XMLELEMENT("RATE_SCHEDULE_ROW", XMLATTRIBUTES (rownum AS "num"),
1318: XMLFOREST(
1319: BEGIN_INSTALLMENT_NUMBER installment_from
1320: ,END_INSTALLMENT_NUMBER installment_to

Line 1335: XMLAGG(

1331: ), -- end of RATE_SCHEDULE
1332: -- COLLATERAL
1333: (select
1334: XMLELEMENT("COLLATERAL",
1335: XMLAGG(
1336: XMLELEMENT("COLLATERAL_ROW", XMLATTRIBUTES (rownum AS "num"),
1337: XMLFOREST(
1338: assetassign.PLEDGED_AMOUNT,
1339: assetassign.START_DATE_ACTIVE,

Line 1388: XMLAGG(

1384: ), -- end of COLLATERAL
1385: -- FEES
1386: (select
1387: XMLELEMENT("FEES",
1388: XMLAGG(
1389: XMLELEMENT("FEES_ROW", XMLATTRIBUTES (rownum AS "num"),
1390: XMLFOREST(
1391: lfa.FEE, lfa.FEE_TYPE, lfa.FEE_BASIS, lfa.RATE_TYPE,
1392: lfa.BILLING_OPTION BILLING_OPTION_CODE,

Line 1429: XMLAGG(

1425: ), -- end of FEES
1426: -- CONDITIONS
1427: (select
1428: XMLELEMENT("CONDITIONS",
1429: XMLAGG(
1430: XMLELEMENT("CONDITIONS_ROW", XMLATTRIBUTES (rownum AS "num"),
1431: XMLFOREST(
1432: lc.CONDITION_NAME,
1433: lca.CONDITION_DESCRIPTION,

Line 1454: XMLAGG(

1450: ), -- end of CONDITIONS
1451: -- ORIGINAL_RECEIVABLES
1452: (select
1453: XMLELEMENT("ORIGINAL_RECEIVABLES",
1454: XMLAGG(
1455: XMLELEMENT("ORIGINAL_RECEIVABLES_ROW", XMLATTRIBUTES (rownum AS "num"),
1456: XMLFOREST(
1457: lll.REFERENCE_NUMBER original_rec_number,
1458: lll.REFERENCE_AMOUNT original_rec_balance,

Line 1484: XMLAGG(

1480: ), -- end of ORIGINAL_RECEIVABLES
1481: -- DISBURSEMENTS
1482: (select
1483: XMLELEMENT("DISBURSEMENTS",
1484: XMLAGG(
1485: XMLELEMENT("DISBURSEMENTS_ROW", XMLATTRIBUTES (rownum AS "num"),
1486: XMLFOREST(
1487: disbursement_number
1488: ,llkac.meaning disbursement_activity

Line 1496: XMLAGG(

1492: ),
1493: -- PAYEES
1494: (select
1495: XMLELEMENT("PAYEES",
1496: XMLAGG(
1497: XMLELEMENT("PAYEES_ROW", XMLATTRIBUTES (rownum AS "num"),
1498: XMLFOREST(
1499: party.party_name payee_name
1500: ,party.ADDRESS1 || ' ' || party.ADDRESS2 || ' ' ||

Line 1521: XMLAGG(

1517: ),-- end of PAYEES
1518: -- DISBFEES
1519: (select
1520: XMLELEMENT("DISBFEES",
1521: XMLAGG(
1522: XMLELEMENT("DISBFEES_ROW", XMLATTRIBUTES (rownum AS "num"),
1523: XMLFOREST(
1524: lfa.FEE, lfa.FEE_TYPE,
1525: lfa.FEE_BASIS,

Line 1564: XMLAGG(

1560: ), -- end of DISBFEES
1561: -- DISBCOND
1562: (select
1563: XMLELEMENT("DISBCOND",
1564: XMLAGG(
1565: XMLELEMENT("DISBCOND_ROW", XMLATTRIBUTES (rownum AS "num"),
1566: XMLFOREST(
1567: lc.CONDITION_NAME,
1568: lca.CONDITION_DESCRIPTION,

Line 1597: XMLAGG(

1593: ), -- end of DISBURSEMENTS
1594: -- AMORTIZATION
1595: (select
1596: XMLELEMENT("AMORTIZATION",
1597: XMLAGG(
1598: XMLELEMENT("AMORTIZATION_ROW", XMLATTRIBUTES (rownum AS "num"),
1599: XMLFOREST(
1600: INSTALLMENT_NUMBER PAYMENT_NUMBER
1601: ,to_char(DUE_DATE, 'YYYY-MM-DD') DUE_DATE