471: APH.Posted_Flag,
472: APH.Accounting_Event_ID,
473: decode(sign(APH.amount), -1, 'PREPAYMENT APPLIED',
474: 'PREPAYMENT UNAPPLIED') Transaction_Type,
475: FND_GLOBAL.User_ID Last_Updated_By,
476: Sysdate Last_Update_Date,
477: FND_GLOBAL.Conc_Login_ID Last_Update_Login,
478: FND_GLOBAL.User_ID Created_By,
479: Sysdate Creation_Date,
473: decode(sign(APH.amount), -1, 'PREPAYMENT APPLIED',
474: 'PREPAYMENT UNAPPLIED') Transaction_Type,
475: FND_GLOBAL.User_ID Last_Updated_By,
476: Sysdate Last_Update_Date,
477: FND_GLOBAL.Conc_Login_ID Last_Update_Login,
478: FND_GLOBAL.User_ID Created_By,
479: Sysdate Creation_Date,
480: APH.Invoice_Line_Number,
481: APH.Accounting_Date
474: 'PREPAYMENT UNAPPLIED') Transaction_Type,
475: FND_GLOBAL.User_ID Last_Updated_By,
476: Sysdate Last_Update_Date,
477: FND_GLOBAL.Conc_Login_ID Last_Update_Login,
478: FND_GLOBAL.User_ID Created_By,
479: Sysdate Creation_Date,
480: APH.Invoice_Line_Number,
481: APH.Accounting_Date
482: FROM
535: PA_Addition_Flag,
536: DECODE(Rank_Num, Dist_Count, Entered_Amount + Delta_Entered, Entered_Amount) Amount,
537: DECODE(Rank_Num, Dist_Count, Accounted_Amount + Delta_Accounted,
538: Accounted_Amount) Base_Amount,
539: FND_GLOBAL.User_ID Last_Updated_By,
540: SYSDATE Last_Update_Date,
541: FND_GLOBAL.Conc_Login_ID Last_Update_Login,
542: FND_GLOBAL.User_ID Created_By,
543: SYSDATE Creation_Date
537: DECODE(Rank_Num, Dist_Count, Accounted_Amount + Delta_Accounted,
538: Accounted_Amount) Base_Amount,
539: FND_GLOBAL.User_ID Last_Updated_By,
540: SYSDATE Last_Update_Date,
541: FND_GLOBAL.Conc_Login_ID Last_Update_Login,
542: FND_GLOBAL.User_ID Created_By,
543: SYSDATE Creation_Date
544: FROM (
545: SELECT Prepay_Dist_Lookup_Code,
538: Accounted_Amount) Base_Amount,
539: FND_GLOBAL.User_ID Last_Updated_By,
540: SYSDATE Last_Update_Date,
541: FND_GLOBAL.Conc_Login_ID Last_Update_Login,
542: FND_GLOBAL.User_ID Created_By,
543: SYSDATE Creation_Date
544: FROM (
545: SELECT Prepay_Dist_Lookup_Code,
546: Invoice_Distribution_ID,
829: DECODE(Rank_Num, Dist_Count, Accounted_Amount + Delta_Entered, Accounted_Amount)
830: ELSE NULL
831: END) Paid_Base_Amount,
832: Reversal_Flag,
833: FND_GLOBAL.User_ID Created_By,
834: Sysdate Creation_Date,
835: Sysdate Last_Update_Date,
836: FND_GLOBAL.User_ID Last_Updated_By,
837: FND_GLOBAL.Conc_Login_ID Last_Update_Login,
832: Reversal_Flag,
833: FND_GLOBAL.User_ID Created_By,
834: Sysdate Creation_Date,
835: Sysdate Last_Update_Date,
836: FND_GLOBAL.User_ID Last_Updated_By,
837: FND_GLOBAL.Conc_Login_ID Last_Update_Login,
838: PA_Addition_Flag
839: FROM (SELECT Pay_Dist_Lookup_Code,
840: Invoice_Distribution_ID,
833: FND_GLOBAL.User_ID Created_By,
834: Sysdate Creation_Date,
835: Sysdate Last_Update_Date,
836: FND_GLOBAL.User_ID Last_Updated_By,
837: FND_GLOBAL.Conc_Login_ID Last_Update_Login,
838: PA_Addition_Flag
839: FROM (SELECT Pay_Dist_Lookup_Code,
840: Invoice_Distribution_ID,
841: Accounting_Event_ID,
1809: 'AP_SLA_ONDEMAND',
1810: sysdate,
1811: NULL,
1812: sysdate,
1813: FND_GLOBAL.User_ID,
1814: FND_GLOBAL.User_ID,
1815: sysdate,
1816: FND_GLOBAL.Login_ID,
1817: FND_GLOBAL.prog_appl_id,
1810: sysdate,
1811: NULL,
1812: sysdate,
1813: FND_GLOBAL.User_ID,
1814: FND_GLOBAL.User_ID,
1815: sysdate,
1816: FND_GLOBAL.Login_ID,
1817: FND_GLOBAL.prog_appl_id,
1818: FND_GLOBAL.conc_program_id,
1812: sysdate,
1813: FND_GLOBAL.User_ID,
1814: FND_GLOBAL.User_ID,
1815: sysdate,
1816: FND_GLOBAL.Login_ID,
1817: FND_GLOBAL.prog_appl_id,
1818: FND_GLOBAL.conc_program_id,
1819: FND_GLOBAL.conc_request_id);
1820: END;
1813: FND_GLOBAL.User_ID,
1814: FND_GLOBAL.User_ID,
1815: sysdate,
1816: FND_GLOBAL.Login_ID,
1817: FND_GLOBAL.prog_appl_id,
1818: FND_GLOBAL.conc_program_id,
1819: FND_GLOBAL.conc_request_id);
1820: END;
1821:
1814: FND_GLOBAL.User_ID,
1815: sysdate,
1816: FND_GLOBAL.Login_ID,
1817: FND_GLOBAL.prog_appl_id,
1818: FND_GLOBAL.conc_program_id,
1819: FND_GLOBAL.conc_request_id);
1820: END;
1821:
1822: BEGIN
1815: sysdate,
1816: FND_GLOBAL.Login_ID,
1817: FND_GLOBAL.prog_appl_id,
1818: FND_GLOBAL.conc_program_id,
1819: FND_GLOBAL.conc_request_id);
1820: END;
1821:
1822: BEGIN
1823: SELECT sub_module
1852: 'AP_SLA_ONDEMAND',
1853: sysdate,
1854: NULL,
1855: sysdate,
1856: FND_GLOBAL.User_ID,
1857: FND_GLOBAL.User_ID,
1858: sysdate,
1859: FND_GLOBAL.Login_ID,
1860: FND_GLOBAL.prog_appl_id,
1853: sysdate,
1854: NULL,
1855: sysdate,
1856: FND_GLOBAL.User_ID,
1857: FND_GLOBAL.User_ID,
1858: sysdate,
1859: FND_GLOBAL.Login_ID,
1860: FND_GLOBAL.prog_appl_id,
1861: FND_GLOBAL.conc_program_id,
1855: sysdate,
1856: FND_GLOBAL.User_ID,
1857: FND_GLOBAL.User_ID,
1858: sysdate,
1859: FND_GLOBAL.Login_ID,
1860: FND_GLOBAL.prog_appl_id,
1861: FND_GLOBAL.conc_program_id,
1862: FND_GLOBAL.conc_request_id);
1863: END;
1856: FND_GLOBAL.User_ID,
1857: FND_GLOBAL.User_ID,
1858: sysdate,
1859: FND_GLOBAL.Login_ID,
1860: FND_GLOBAL.prog_appl_id,
1861: FND_GLOBAL.conc_program_id,
1862: FND_GLOBAL.conc_request_id);
1863: END;
1864:
1857: FND_GLOBAL.User_ID,
1858: sysdate,
1859: FND_GLOBAL.Login_ID,
1860: FND_GLOBAL.prog_appl_id,
1861: FND_GLOBAL.conc_program_id,
1862: FND_GLOBAL.conc_request_id);
1863: END;
1864:
1865:
1858: sysdate,
1859: FND_GLOBAL.Login_ID,
1860: FND_GLOBAL.prog_appl_id,
1861: FND_GLOBAL.conc_program_id,
1862: FND_GLOBAL.conc_request_id);
1863: END;
1864:
1865:
1866: /* When the program is run in on demand upgrade mode it is submitted from