cof_rv_detalheplanomestre

SELECT pp.ad_client_id,

    pp.ad_org_id,

    pp.documentno,

    pp.name,

    pp.cof_pp_roteiroprod_id,

    pp.description,

    pp.cof_pp_instrucoes,

    pp.c_doctype_id,

    pp.docstatus,

    pp.processed,

    pp.cof_pp_dataabertura,

    pp.cof_pp_dataprevistaencerramento,

    pp.cof_pp_datainicioplano,

    pp.cof_pp_dataencerramentoplano,

    pp.cof_productiontype,

    pp.m_product_id,

    pp.m_locator_id,

    pp.c_activity_id,

    pp.c_campaign_id,

    pp.user1_id,

    pp.cof_pp_quantidadeplanejada,

    pp.cof_pp_qtdproduzida,

    pp.cof_pp_loteminimo,

    pp.cof_pp_porcentagemrealizada,

    pp.cof_pp_distorcaoproducao,

    pp.cof_pp_qtdciclo,

    pp.cof_pp_qtdhorasapontada,

    pp.cof_pp_qtdhorastrabalho,

    pp.cof_pp_considerahorassetup,

    pp.cof_pp_qtdtotalhrstrabalhadas,

    pp.isactive,

    pp.cof_pp_perdaporcentagem,

    pp.cof_pp_quantidadeperdaapontada,

    pp.cof_pp_perdaporcentagemproduzida,

    ppl.value,

    ppl.line,

    ppl.cof_pp_ocorrenciaprod_id,

    ppl.c_bpartner_id,

    ppl.cof_pp_datahorade,

    ppl.cof_pp_datahoraate,

    ppl.cof_pp_observacoes

   FROM (cof_pp_planomestreprod pp

     LEFT JOIN cof_pp_planomestreprodline ppl ON ((ppl.cof_pp_planomestreprod_id = pp.cof_pp_planomestreprod_id)))

  ORDER BY pp.cof_pp_planomestreprod_id;