DBA Data[Home] [Help]

APPS.FII_AP_INV_B_C dependencies on FND_USER

Line 547: fnd_user fnd,

543: XLA_Transaction_Entities XTE,
544: AP_Invoice_Lines_ALL AIL,
545: ap_invoices_all ai,
546: po_vendors po, --AP_SUPPLIERS PO,
547: fnd_user fnd,
548: (select vouchno,
549: case when count(1) > 1 then -1
550: else min(report_header_id) end report_header_id
551: from ap_expense_report_headers_all

Line 580: AND fnd.user_id = nvl(aid.created_by, ai.cancelled_by)

576: OR slga.bal_seg_value_id = -1 )
577: AND aid.set_of_books_id = slga.ledger_id
578: AND slga.source_ledger_group_id = fslg.source_ledger_group_id
579: AND fslg.usage_code = g_usage_code
580: AND fnd.user_id = nvl(aid.created_by, ai.cancelled_by)
581: AND XAH.Application_ID = 200
582: AND XAH.Balance_Type_Code = 'A'
583: AND XTE.Application_ID = 200
584: AND XAL.Application_ID = 200

Line 1522: fnd_user fnd,

1518: XLA_Transaction_Entities XTE,
1519: AP_Invoice_Lines_ALL AIL,
1520: ap_invoices_all ai,
1521: po_vendors po, --AP_SUPPLIERS PO,
1522: fnd_user fnd,
1523: (SELECT /*+ no_merge parallel(H) */
1524: VOUCHNO,
1525: CASE WHEN COUNT(*) > 1 THEN -1
1526: ELSE MIN(REPORT_HEADER_ID) END REPORT_HEADER_ID

Line 1545: and fnd.user_id = nvl(aid.created_by, ai.cancelled_by)

1541: AND AID.Invoice_ID = AIL.Invoice_ID
1542: AND AID.Invoice_Line_Number = AIL.Line_Number
1543: and ai.invoice_id = aid.invoice_id
1544: and ai.vendor_id = po.vendor_id
1545: and fnd.user_id = nvl(aid.created_by, ai.cancelled_by)
1546: and aid.set_of_books_id = v.ledger_id
1547: and XAL.Code_Combination_ID = v.code_combination_id
1548: AND XAH.Application_ID = 200
1549: AND XAH.Balance_Type_Code = 'A'