DBA Data[Home] [Help]

APPS.AP_LINES_UPGRADE_PKG dependencies on ZX_RATES_B

Line 616: ZX_Rates_B ZXR

612: NULL) Summary_Tax_Line_ID
613: FROM AP_Invoices_ALL AI,
614: AP_Inv_Dists_Source AID,
615: AP_Inv_Dists_Source AID1,
616: ZX_Rates_B ZXR
617: WHERE AI.Invoice_ID = AID.Invoice_ID
618: AND AID.Parent_Reversal_ID = AID1.Invoice_Distribution_ID (+)
619: AND AID.Tax_Code_ID = ZXR.Source_ID (+)
620: AND NVL(AID1.Reversal_Flag, 'Y') = 'Y'

Line 1431: ZX_Rates_B ZXR

1427: PO_Distributions_All PD,
1428: PO_Lines_All PL,
1429: AP_Inv_Dists_Source AID1,
1430: AP_Tax_Codes_All ATC,
1431: ZX_Rates_B ZXR
1432: WHERE AI.Invoice_ID = AID.Invoice_ID
1433: AND NVL(AI.Org_ID,-99) = NVL(ASP.Org_ID,-99)
1434: AND ((NVL(AID.Reversal_Flag,'N') = 'N')
1435: OR (AID.Reversal_Flag = 'Y' AND AID.Parent_Reversal_ID IS NULL)