DBA Data[Home] [Help]

APPS.FV_ASSIGN_REASON_CODES_PKG dependencies on AP_INVOICES

Line 50: ap_invoices api,

46:
47: CURSOR reason_codes_cur IS
48: SELECT air.original_invoice_id, air.checkrun_name
49: FROM ap_invoice_relationships air,
50: ap_invoices api,
51: fv_terms_types fvt
52: WHERE( air.original_invoice_id NOT IN
53: (SELECT farc.invoice_id
54: FROM fv_assign_reason_codes farc

Line 161: ap_invoices api,

157:
158: SELECT /*+ USE_MERGE(api) */ api.invoice_id, apc.checkrun_name
159: FROM fv_terms_types ftt,
160: ap_terms apt,
161: ap_invoices api,
162: ap_checks apc,
163: ap_invoice_payments app
164: WHERE app.set_of_books_id = x_set_of_books_id
165: and api.org_id = x_org_id