What I ordered hasn't arrived yet.

Literal

Ordered thing [subject-が] still come-not.

頼んだ物 is a relative clause: 頼む ('order') in past plain form modifying 物 ('thing'). Japanese relative clauses precede the noun directly with no relative pronoun. まだ + negative = 'not yet.'