DBA Data[Home] [Help]

APPS.AP_RECURRING_INVOICES_PKG dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 335: C_inventory_org_id financials_system_parameters.inventory_organization_id%TYPE;

331: C_Invoice_line_number ap_invoice_lines_all.line_number%TYPE;
332: C_Price NUMBER;
333: C_Description ap_lookup_codes.description%TYPE;
334: C_unit_meas_lookup_code po_line_locations_all.unit_meas_lookup_code%TYPE;
335: C_inventory_org_id financials_system_parameters.inventory_organization_id%TYPE;
336: C_asset_bt_code AP_INVOICE_LINES_ALL.ASSET_BOOK_TYPE_CODE%TYPE;
337: C_dist_tab AP_MATCHING_PKG.dist_tab_type;
338: C_ship_to_location_id PO_VENDOR_SITES.ship_to_location_id%TYPE;
339: C_retained_amount Number; /*bug 5228301 */

Line 836: financials_system_parameters fsp

832: P_ship_to_location_id
833: FROM po_vendors v,
834: ap_system_parameters sp,
835: po_vendor_sites vs,
836: financials_system_parameters fsp
837: WHERE v.vendor_id = P_vendor_id
838: AND vs.org_id = sp.org_id
839: AND sp.org_id = fsp.org_id
840: AND vs.vendor_site_id = P_vendor_site_id