-- Log API
SELECT   no_registration AS spk_no, flag_api, BODY AS request,
         content AS response_api
    FROM mtr_accals.trn_vc_ai_log_api
   WHERE no_registration = '0040000666001' AND id_user_respond IS NULL
--     AND flag_api = 5
ORDER BY date_request;

-- API 1
-- Check di log api apakah sudah berhasil hit dimereka
SELECT spk_no, application_no, enoreg, no_leads
  FROM trn_vc_ai_download
 WHERE spk_no = '0040000666001';

-- API 2
/*
1. Waktu Lanjut data entry
2. Waktu submit Outstanding
*/
SELECT no_registration
  FROM trn_vc_ai_download
 WHERE spk_no = '0040000666001';

-- API 3,4
-- flow dikirim waktu auth BM
-- Check di log api apakah sudah berhasil hit dimereka
SELECT dt_survey
  FROM trn_vc_ai_download
 WHERE spk_no = '0040000666001';

-- API 6
-- flow dikirim waktu auth BM
-- Check di log api apakah sudah berhasil hit dimereka
SELECT cd_company, spk_no, flag_leasing
  FROM trn_vc_ai_download
 WHERE spk_no = '0040000666001';

-- API 6.1
SELECT st_epo
  FROM mtr_accals.trn_appl_detail
 WHERE no_registration = '100106003697085';

 -- API 5
SELECT chasis_no, engine_no, no_sales_order, dt_sales_order, rq_uuid,
       leasing_type
  FROM trn_vc_ai_download
 WHERE spk_no = '0040000666001';

-- API 7
SELECT gi_date, final_dp_date
  FROM trn_vc_ai_download
 WHERE spk_no = '0040000666001';

-- API 8
SELECT bpkb_rqst_date
  FROM trn_vc_ai_download
 WHERE spk_no = '0040000666001';

-- API 9
SELECT bpkb_acc_received_date
  FROM trn_vc_ai_download
 WHERE spk_no = '0040000666001';

-- API 10
SELECT /*+INDEX(TRN_APPL_DEtAIL  TRN_APPL_DETAIL01)*/
       flag_ready, st_appl, no_aggr
  FROM trn_appl_detail
 WHERE no_registration = '100106003697085';

SELECT is_cancelled, flag_verify
  FROM trn_vc_ai_download
 WHERE spk_no = '0040000666001';

SELECT flag_verify, flag_ok, flag_reject, flag_assign, flag_receive,
       flag_reschedule, flag_load, flag_view
  FROM mtr_accals.trn_efap_header
 WHERE e_noreg = 'L240731144805CZJ';

-- API 11

SELECT *
  FROM mtr_accals.trn_vc_ai_invoice
 WHERE spk_no = '0040000666001';

SELECT *
  FROM mtr_accals.trn_asset_appl
 WHERE no_registration = '100106003697085';

SELECT *
  FROM mtr_accals.trn_asset_aggr
 WHERE no_aggr = '07100106003697085';

SELECT td.bill_no o, td.bill_date, td.bill_status, td.bstkb_no,
       td.bstkb_print_date, td.dt_invoice, td.invoice_no, td.invoice_amt
  FROM mtr_accals.trn_vc_ai_download td
 WHERE no_registration = '100106003697085';

 -- API 11.1
SELECT /*+INDEX(TRN_APPL_DEtAIL  TRN_APPL_DETAIL01)*/
       st_einvoice
  FROM trn_appl_detail
 WHERE no_registration = '100106003697085';

-- API 12
SELECT md.no_aggr, md.tot_amt_disburse_paid, md.cd_sp
--           INTO v_no_aggr, v_amt_paid_lc, v_cd_sp
FROM   mtr_accals.mst_disbursement md
 WHERE md.no_registration = '100106003697085'
   AND md.flag_disb_paid = 'Z'
   AND md.tot_amt_disburse_paid > 0;