651: 'LINE_CORRECTION'
652: END) AS Match_Type,
653: /*
654: DECODE(AID.Line_Type_Lookup_Code, 'TAX',
655: DECODE(AID.Parent_Reversal_ID, NULL, ZX_Lines_Summary_S.NEXTVAL,
656: DECODE(AID.Reversal_Flag, 'Y', NULL, ZX_Lines_Summary_S.NEXTVAL)),
657: NULL) Summary_Tax_Line_ID
658: */
659: DECODE(AID.Line_Type_Lookup_Code, 'TAX',
652: END) AS Match_Type,
653: /*
654: DECODE(AID.Line_Type_Lookup_Code, 'TAX',
655: DECODE(AID.Parent_Reversal_ID, NULL, ZX_Lines_Summary_S.NEXTVAL,
656: DECODE(AID.Reversal_Flag, 'Y', NULL, ZX_Lines_Summary_S.NEXTVAL)),
657: NULL) Summary_Tax_Line_ID
658: */
659: DECODE(AID.Line_Type_Lookup_Code, 'TAX',
660: DECODE(AID1.Parent_Reversal_ID, NULL,
657: NULL) Summary_Tax_Line_ID
658: */
659: DECODE(AID.Line_Type_Lookup_Code, 'TAX',
660: DECODE(AID1.Parent_Reversal_ID, NULL,
661: DECODE(AID.Parent_Reversal_ID, NULL, ZX_Lines_Summary_S.Nextval,
662: DECODE(AID.Reversal_Flag, 'Y',
663: DECODE(AID1.Invoice_Distribution_ID, NULL, ZX_Lines_Summary_S.Nextval, NULL),
664: ZX_Lines_Summary_S.Nextval)),
665: ZX_Lines_Summary_S.Nextval),
659: DECODE(AID.Line_Type_Lookup_Code, 'TAX',
660: DECODE(AID1.Parent_Reversal_ID, NULL,
661: DECODE(AID.Parent_Reversal_ID, NULL, ZX_Lines_Summary_S.Nextval,
662: DECODE(AID.Reversal_Flag, 'Y',
663: DECODE(AID1.Invoice_Distribution_ID, NULL, ZX_Lines_Summary_S.Nextval, NULL),
664: ZX_Lines_Summary_S.Nextval)),
665: ZX_Lines_Summary_S.Nextval),
666: NULL) Summary_Tax_Line_ID
667: FROM AP_Invoices_ALL AI,
660: DECODE(AID1.Parent_Reversal_ID, NULL,
661: DECODE(AID.Parent_Reversal_ID, NULL, ZX_Lines_Summary_S.Nextval,
662: DECODE(AID.Reversal_Flag, 'Y',
663: DECODE(AID1.Invoice_Distribution_ID, NULL, ZX_Lines_Summary_S.Nextval, NULL),
664: ZX_Lines_Summary_S.Nextval)),
665: ZX_Lines_Summary_S.Nextval),
666: NULL) Summary_Tax_Line_ID
667: FROM AP_Invoices_ALL AI,
668: AP_Inv_Dists_Source AID,
661: DECODE(AID.Parent_Reversal_ID, NULL, ZX_Lines_Summary_S.Nextval,
662: DECODE(AID.Reversal_Flag, 'Y',
663: DECODE(AID1.Invoice_Distribution_ID, NULL, ZX_Lines_Summary_S.Nextval, NULL),
664: ZX_Lines_Summary_S.Nextval)),
665: ZX_Lines_Summary_S.Nextval),
666: NULL) Summary_Tax_Line_ID
667: FROM AP_Invoices_ALL AI,
668: AP_Inv_Dists_Source AID,
669: AP_Inv_Dists_Source AID1,