APPS.GHG_TRANSACTIONS_API_PKG dependencies on GHG_TRANSACTIONS_ALL

Line 891: FROM GHG_TRANSACTIONS_all em

887: v_msg varchar2(500) ; --bug 14741401--neechand
888:
889: CURSOR emissions_records IS
890: SELECT *
891: FROM GHG_TRANSACTIONS_all em
892: WHERE org_id = p_org_id
893: AND nvl(em.vendor_id,-1) = nvl(p_supplier_id, nvl(em.vendor_id,-1))
894: AND nvl(em.invoice_id,-1) = nvl(p_invoice_id, nvl(em.invoice_id,-1) )
895: AND em.ghg_organization_id = nvl(p_facility_id, em.ghg_organization_id)

Line 901: FROM GHG_TRANSACTIONS_all em

897: AND (trunc(em.transaction_date_from) between nvl(v_emission_from_date, em.transaction_date_from) and nvl(v_emission_to_date, em.transaction_date_to)
898: OR trunc(em.transaction_date_to) between nvl(v_emission_from_date, em.transaction_date_from) and nvl(v_emission_to_date, em.transaction_date_to))
899: UNION ALL
900: SELECT *
901: FROM GHG_TRANSACTIONS_all em
902: WHERE org_id = p_org_id
903: AND nvl(em.vendor_id,-1) = nvl(p_supplier_id, nvl(em.vendor_id,-1))
904: AND nvl(em.invoice_id,-1) = nvl(p_invoice_id, nvl(em.invoice_id,-1) )
905: AND em.ghg_organization_id = nvl(p_facility_id, em.ghg_organization_id)

Line 1587: 'FROM GHG_TRANSACTIONS_ALL tr ' ||

1583: ', tr.measurement_criteria measurement_criteria_code ' ||
1584: ', tr.measurement_criteria measurement_criteria_desc ' ||
1585: ', nvl(tr.usage_quantity,0) ' ||
1586: ', tr.unit_of_measure ' ||
1587: 'FROM GHG_TRANSACTIONS_ALL tr ' ||
1588: ', ap_invoices ap ' ||
1589: ', GHG_PERIODS_D@' || v_dblink || ' rp ' ||
1590: ', fnd_currencies_tl cur ' ||
1591: ', GHG_TRANSACTION_DETAILS_ALL em ' ||

Line 1700: 'from GHG_TRANSACTIONS_all em ' ||

1696: ', em.ghg_asset_id ' ||
1697: ', em.vendor_id ' ||
1698: ', em.inventory_item_id ' ||
1699: ', em.ghg_organization_id ' ||
1700: 'from GHG_TRANSACTIONS_all em ' ||
1701: ', GHG_TRANSACTION_DETAILS_all ld ' ||
1702: 'where em.transaction_id = ld.transaction_id ' ||
1703: 'and ld.transaction_type = ''E''';
1704: