DBA Data[Home] [Help]

APPS.GHG_PO_EMISSIONS_PKG dependencies on PO_LINES_V

Line 40: v_po_unit_of_measure po_lines_v.unit_meas_lookup_code%TYPE;

36: v_supplier_emission_rate_id NUMBER(15);
37: v_supplier_rate_uom VARCHAR2(25);
38: v_supplier_emission_factor NUMBER;
39: v_supplier_emission_energy NUMBER;
40: v_po_unit_of_measure po_lines_v.unit_meas_lookup_code%TYPE;
41: v_code_combination_id NUMBER(15);
42: v_uom_conversion NUMBER;
43: v_rowid VARCHAR2(24);
44: v_debug_info VARCHAR2(100);

Line 82: po_lines_v pl,

78: pd.code_combination_id
79: FROM ap_invoices_all ai,
80: po_vendor_sites pvs,
81: ap_invoice_distributions_v aid,
82: po_lines_v pl,
83: po_distributions_v pd,
84: fnd_lookup_values_vl xnlv
85: WHERE ai.invoice_id = i_invoice_id
86: AND pvs.vendor_site_id = ai.vendor_site_id