018_check_current_state.sql 325 B

1234567
  1. -- 현재 파트너십 상태 확인
  2. SELECT SEQ, VENDOR_SEQ, INFLUENCER_SEQ, STATUS, IS_ACTIVE, REQUEST_TYPE,
  3. REQUEST_DATE, RESPONSE_DATE, PARTNERSHIP_START_DATE, PARTNERSHIP_END_DATE,
  4. PROCESSED_BY, REQUESTED_BY
  5. FROM VENDOR_INFLUENCER_PARTNERSHIP
  6. WHERE VENDOR_SEQ = 8 AND INFLUENCER_SEQ = 23
  7. ORDER BY SEQ DESC;