DBA Data[Home] [Help]

APPS.FV_ASSIGN_REASON_CODES_PKG dependencies on FV_TERMS_TYPES

Line 51: fv_terms_types fvt

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
55: WHERE farc.set_of_books_id = x_set_of_books_id

Line 159: FROM fv_terms_types ftt,

155:
156: CURSOR c_quick_payments IS
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