597: 'LINE_CORRECTION'
598: END) AS Match_Type,
599: /*
600: DECODE(AID.Line_Type_Lookup_Code, 'TAX',
601: DECODE(AID.Parent_Reversal_ID, NULL, ZX_Lines_Summary_S.NEXTVAL,
602: DECODE(AID.Reversal_Flag, 'Y', NULL, ZX_Lines_Summary_S.NEXTVAL)),
603: NULL) Summary_Tax_Line_ID
604: */
605: DECODE(AID.Line_Type_Lookup_Code, 'TAX',
598: END) AS Match_Type,
599: /*
600: DECODE(AID.Line_Type_Lookup_Code, 'TAX',
601: DECODE(AID.Parent_Reversal_ID, NULL, ZX_Lines_Summary_S.NEXTVAL,
602: DECODE(AID.Reversal_Flag, 'Y', NULL, ZX_Lines_Summary_S.NEXTVAL)),
603: NULL) Summary_Tax_Line_ID
604: */
605: DECODE(AID.Line_Type_Lookup_Code, 'TAX',
606: DECODE(AID1.Parent_Reversal_ID, NULL,
603: NULL) Summary_Tax_Line_ID
604: */
605: DECODE(AID.Line_Type_Lookup_Code, 'TAX',
606: DECODE(AID1.Parent_Reversal_ID, NULL,
607: DECODE(AID.Parent_Reversal_ID, NULL, ZX_Lines_Summary_S.Nextval,
608: DECODE(AID.Reversal_Flag, 'Y',
609: DECODE(AID1.Invoice_Distribution_ID, NULL, ZX_Lines_Summary_S.Nextval, NULL),
610: ZX_Lines_Summary_S.Nextval)),
611: ZX_Lines_Summary_S.Nextval),
605: DECODE(AID.Line_Type_Lookup_Code, 'TAX',
606: DECODE(AID1.Parent_Reversal_ID, NULL,
607: DECODE(AID.Parent_Reversal_ID, NULL, ZX_Lines_Summary_S.Nextval,
608: DECODE(AID.Reversal_Flag, 'Y',
609: DECODE(AID1.Invoice_Distribution_ID, NULL, ZX_Lines_Summary_S.Nextval, NULL),
610: ZX_Lines_Summary_S.Nextval)),
611: ZX_Lines_Summary_S.Nextval),
612: NULL) Summary_Tax_Line_ID
613: FROM AP_Invoices_ALL AI,
606: DECODE(AID1.Parent_Reversal_ID, NULL,
607: DECODE(AID.Parent_Reversal_ID, NULL, ZX_Lines_Summary_S.Nextval,
608: DECODE(AID.Reversal_Flag, 'Y',
609: DECODE(AID1.Invoice_Distribution_ID, NULL, ZX_Lines_Summary_S.Nextval, NULL),
610: ZX_Lines_Summary_S.Nextval)),
611: ZX_Lines_Summary_S.Nextval),
612: NULL) Summary_Tax_Line_ID
613: FROM AP_Invoices_ALL AI,
614: AP_Inv_Dists_Source AID,
607: DECODE(AID.Parent_Reversal_ID, NULL, ZX_Lines_Summary_S.Nextval,
608: DECODE(AID.Reversal_Flag, 'Y',
609: DECODE(AID1.Invoice_Distribution_ID, NULL, ZX_Lines_Summary_S.Nextval, NULL),
610: ZX_Lines_Summary_S.Nextval)),
611: ZX_Lines_Summary_S.Nextval),
612: NULL) Summary_Tax_Line_ID
613: FROM AP_Invoices_ALL AI,
614: AP_Inv_Dists_Source AID,
615: AP_Inv_Dists_Source AID1,