Database Error in model , relation does not exist

[AdeptusTitus]

The problem I’m having

The context of why I’m trying to do this

Build model with command dbt run --models +customerrevenue
Trying to follow along with this Youtube video :
SleekData

I am stuck at this point

What I’ve already tried

Here is my dbt_project.yml file contents

name: oms_dbt_proj
version: 1.0.0
profile: oms_dbt_proj
model-paths:
  - models
analysis-paths:
  - analyses
test-paths:
  - tests
seed-paths:
  - seeds
macro-paths:
  - macros
snapshot-paths:
  - snapshots
clean-targets:
  - target
  - dbt_packages
models:
  oms_dbt_proj:
    customers_stg:
      schema: L2_PROCESSING
    orders_stg:
      schema: L2_PROCESSING
    orderitems_stg:
      schema: L2_PROCESSING
    customerrevenue:
      materialized: table
    orders_fact:
      materialized: table
      schema: L2_PROCESSING

Here is the profiles,yml file

oms_dbt_proj:
  outputs:
    dev:
      dbname: SLEEKMART_OMS
      host: localhost
      pass: ********
      port: 5432
      schema: L3_CONSUMPTION
      threads: 1
      type: postgres
      user: postgres
  target: dev

Some example code or error messages

e[0m17:07:56.999344 [debug] [Thread-1 (]: Postgres adapter: Postgres error: relation "l1_landing.customers" does not exist
LINE 20: from L1_LANDING.customers
              ^

e[0m17:07:57.000365 [debug] [Thread-1 (]: On model.oms_dbt_proj.customers_stg: ROLLBACK
e[0m17:07:57.000365 [debug] [Thread-1 (]: On model.oms_dbt_proj.customers_stg: Close
e[0m17:07:57.004954 [debug] [Thread-1 (]: Database Error in model customers_stg (models\customers_stg.sql)
  relation "l1_landing.customers" does not exist
  LINE 20: from L1_LANDING.customers
                ^

macro file

{% macro generate_schema_name(custom_schema_name, node) -%}

    {%- set default_schema = target.schema -%}
    {%- if custom_schema_name is none -%}

        {{ default_schema }}
    
    {%- else -%}

        {{ custom_schema_name | trim }}
        
    {%- endif -%}

{%- endmacro %}

lastly , here is a screen clipping of dbt_log file :