DBA Data[Home] [Help]

APPS.FII_AP_INV_SUM_INC dependencies on AP_INVOICE_LINES_ALL

Line 1526: AP_Invoice_Lines_ALL AIL

1522: MAX(AID.Invoice_Distribution_ID) Invoice_Distribution_ID --Any invoice distribution id is ok. Just used to make the record unique.
1523: BULK COLLECT INTO FII_AP_WH_Tax_MS
1524: FROM FII_AP_Invoice_IDS ID,
1525: AP_Invoice_Distributions_ALL AID,
1526: AP_Invoice_Lines_ALL AIL
1527: WHERE ID.Invoice_ID = AID.Invoice_ID
1528: AND AID.Invoice_ID = AIL.Invoice_ID
1529: AND AID.Invoice_Line_Number = AIL.Line_Number
1530: AND (ID.Invoice_B_Flag = 'Y' OR ID.Pay_Sched_B_Flag = 'Y')

Line 1570: AP_Invoice_Lines_ALL AIL,

1566: TEMP.Invoice_ID Prepay_Invoice_ID,
1567: SUM(AID.Amount) Amount
1568: FROM FII_AP_Invoice_IDS ID,
1569: AP_Invoice_Distributions_All AID,
1570: AP_Invoice_Lines_ALL AIL,
1571: AP_Invoice_Distributions_ALL TEMP
1572: WHERE ID.Invoice_ID = AID.Invoice_ID
1573: AND AID.Invoice_ID = AIL.Invoice_ID
1574: AND AID.Invoice_Line_Number = AIL.Line_Number