DBA Data[Home] [Help]

APPS.AP_LINES_UPGRADE_PKG dependencies on ZX_RATES_B

Line 671: ZX_Rates_B ZXR

667: FROM AP_Invoices_ALL AI,
668: AP_Inv_Dists_Source AID,
669: AP_Inv_Dists_Source AID1,
670: PO_Distributions_All POD, -- 9196221
671: ZX_Rates_B ZXR
672: WHERE AI.Invoice_ID = AID.Invoice_ID
673: AND AID.Parent_Reversal_ID = AID1.Invoice_Distribution_ID (+)
674: AND AID.Tax_Code_ID = ZXR.Source_ID (+)
675: AND NVL(AID1.Reversal_Flag, 'Y') = 'Y'

Line 1520: ZX_Rates_B ZXR

1516: PO_Distributions_All PD,
1517: PO_Lines_All PL,
1518: AP_Inv_Dists_Source AID1,
1519: AP_Tax_Codes_All ATC,
1520: ZX_Rates_B ZXR
1521: WHERE AI.Invoice_ID = AID.Invoice_ID
1522: AND NVL(AI.Org_ID,-99) = NVL(ASP.Org_ID,-99)
1523: AND ((NVL(AID.Reversal_Flag,'N') = 'N')
1524: OR (AID.Reversal_Flag = 'Y' AND AID.Parent_Reversal_ID IS NULL)