APPS.FII_AP_INV_DISTRIBUTIONS_B_C dependencies on FND_USER

Line 367: fnd_user fnd,

363: ap_invoice_lines_all ail,
364: ap_invoice_distributions_all aid,
365: gl_ledgers_public_v gsob,
366: fii_gl_ccid_dimensions glcc,
367: fnd_user fnd,
368: fii_slg_assignments slga,
369: fii_source_ledger_groups fslg
370: WHERE ai.invoice_id = temp.invoice_id
371: AND ai.invoice_id = aid.invoice_id

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

379: OR slga.bal_seg_value_id = -1 )
380: AND aid.set_of_books_id = slga.ledger_id
381: AND slga.source_ledger_group_id = fslg.source_ledger_group_id
382: AND fslg.usage_code = g_usage_code
383: AND fnd.user_id = nvl(aid.created_by, ai.cancelled_by)
384: AND temp.sequence_id >= p_start_range
385: AND temp.sequence_id <= p_end_range
386: AND aid.accounting_date >= g_start_date;
387:

Line 1224: fnd_user fnd

1220: and fslg.usage_code = g_usage_code) v,
1221: ap_invoice_distributions_all aid,
1222: ap_invoice_lines_all ail,
1223: ap_invoices_all ai,
1224: fnd_user fnd
1225: where ai.invoice_id = aid.invoice_id
1226: and ai.invoice_id = ail.invoice_id
1227: AND AID.Invoice_ID = AIL.Invoice_ID
1228: AND AID.Invoice_Line_Number = AIL.Line_Number

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

1226: and ai.invoice_id = ail.invoice_id
1227: AND AID.Invoice_ID = AIL.Invoice_ID
1228: AND AID.Invoice_Line_Number = AIL.Line_Number
1229: and nvl(aid.posted_flag, 'N') = 'N'
1230: and fnd.user_id = nvl(aid.created_by, ai.cancelled_by)
1231: and aid.set_of_books_id = v.ledger_id
1232: and aid.dist_code_combination_id = v.code_combination_id
1233: and aid.accounting_date >= g_start_date;
1234: