{"id":20675,"date":"2020-07-23T16:52:16","date_gmt":"2020-07-23T19:52:16","guid":{"rendered":"https:\/\/orabr.com\/?p=20675"},"modified":"2020-07-23T17:59:05","modified_gmt":"2020-07-23T20:59:05","slug":"pesquisa-detalhada-de-transacoes-contabeis-em-estoque","status":"publish","type":"post","link":"https:\/\/orabr.virttus.com\/?p=20675","title":{"rendered":"Pesquisa detalhada de transa\u00e7\u00f5es cont\u00e1beis em estoque"},"content":{"rendered":"\n
\n\nSELECT gl.name                                                \"Ledger\", \n       haou2.name                                             \"Operating Unit\", \n       mtl_acct.organization_code                             \"Org Code\", \n       oap.period_name                                        \"Period Name\", \n       gcc1.segment1                                          \"Co\", \n       gcc1.segment2                                          \"Cost Ctr\", \n       gcc1.segment3                                          \"Acct\", \n       gcc1.segment4                                          \"Sub-Acct\", \n       gcc1.segment5                                          \"Prod Grp\", \n       mtl_acct.item_number                                   \"Item Number\", \n       mtl_acct.item_description                              \"Item Description\" \n       , \n       ml.meaning \n       \"Acct Line Type\", \n       mtl_acct.transaction_type_name                         \"Transaction Type\" \n       , \n       mtl_acct.subinventory_code                             \"Subinv.\", \n       mtl_acct.wip_class                                     \"WIP Class\", \n       mtl_acct.class_type                                    \"Class Type\", \n       mtl_acct.job                                           \"WIP Job\", \n       mtl_acct.fg_item                                       \"FG Item Number\", \n       mtl_acct.fg_description                                \"FG Description\", \n       mtl_acct.primary_uom_code                              \"UOM Code\", \n       SUM(mtl_acct.primary_quantity)                         \"Quantity\", \n       gl.currency_code                                       \"Curr Code\", \n       -- Fix for version 1.5 \n       mtl_acct.item_cost                                     \"Item Cost\", \n       -- Fix for version 1.4 \n       -- sum(nvl(al.ACCOUNTED_DR,0) - nvl(al.ACCOUNTED_CR,0)) \"Amount\" \n       SUM(Nvl(al.accounted_dr, 0) - Nvl(al.accounted_cr, 0)) \"Amount\" \n-- End fix for version 1.4 \nFROM   inv.org_acct_periods oap, \n       apps.gl_code_combinations gcc1, \n       apps.mfg_lookups ml, \n       hr.hr_organization_information hoi, \n       hr.hr_all_organization_units haou,-- inv_organization_id \n       hr.hr_all_organization_units haou2,-- operating unit \n       gl.gl_ledgers gl, \n       xla.xla_transaction_entities ent, \n       xla.xla_events xe, \n       xla.xla_distribution_links xdl, \n       xla.xla_ae_headers ah, \n       xla.xla_ae_lines al, \n       -- ======= \n       -- Use this inline table to fetch the WIP and non-WIP material transactions \n       -- WIP is when the mmt.transaction_source_type_id = 5 \n       -- ======= \n       (SELECT mp.organization_code \n                organization_code, \n               mp.organization_id \n                organization_id, \n               mmt.acct_period_id \n                acct_period_id, \n               mta.reference_account \n                reference_account, \n               mta.inv_sub_ledger_id \n                inv_sub_ledger_id, \n               msi.segment1 \n                item_number, \n               msi.description \n                item_description, \n               mta.accounting_line_type \n                accounting_line_type, \n               mtt.transaction_type_name \n                transaction_type_name, \n               Decode(mta.accounting_line_type, 7, 'WIP', \n                                                14, '', \n                                                1, \n               Decode (mmt.transaction_action_id, 2 \n               , \n               Decode \n               (Sign (mta.primary_quantity), -1, \n               mmt.subinventory_code, \n                1, \n               mmt.transfer_subinventory, \n               mmt.subinventory_code), \n               3, \n               Decode (mmt.organization_id, mta.organization_id, \n               mmt.subinventory_code, \n                                                   mmt.transfer_subinventory), \n                                                   21, \n               Decode ( \n                                                   Sign (mta.primary_quantity), \n               -1, \n                                                       mmt.subinventory_code, \n                                                     1, \n                                                   mmt.transfer_subinventory, \n                                                   mmt.subinventory_code), \n                                                   22, \n               Decode ( \n                                                   Sign (mta.primary_quantity), \n               -1, \n                                                       mmt.subinventory_code, \n                                                     1, \n                                                   mmt.transfer_subinventory, \n                                                   mmt.subinventory_code), \n                                                   28, \n               Decode ( \n                                                   Sign (mta.primary_quantity), \n               -1, \n                                                       mmt.subinventory_code, \n                                                     1, \n                                                   mmt.transfer_subinventory, \n                                                   mmt.subinventory_code), \n                                                   mmt.subinventory_code)) \n                subinventory_code, \n               we.wip_entity_name \n               job \n               , \n               wdj.class_code \n                wip_class, \n               ml.meaning \n                class_type, \n               msi2.segment1 \n                fg_item, \n               msi2.description \n                fg_description, \n               msi.primary_uom_code, \n               -- Revised quantity calculation for version 1.5 \n               Sign(SUM(mta.base_transaction_value)) * Abs(SUM( \n               Decode(mmt.transaction_type_id, 24, mmt.quantity_adjusted, \n                                               mmt.primary_quantity))) \n                primary_quantity, \n               -- Revised item cost calculation for version 1.5 \n               SUM(mta.base_transaction_value) \/ Decode( \nSign(SUM(mta.base_transaction_value)) \n* \nAbs( \nSUM( \nDecode(mmt.transaction_type_id, 24, \nmmt.quantity_adjusted, \n   mmt.primary_quantity))), 0, 1, \nSign(SUM(mta.base_transaction_value)) \n* \nAbs( \nSUM( \nDecode(mmt.transaction_type_id, 24, \nmmt.quantity_adjusted, \n          mmt.primary_quantity)))) \nitem_cost, \n-- End of revisions for version 1.5 \nSUM(base_transaction_value) \nmta_amount \nFROM   inv.mtl_transaction_accounts mta, \ninv.mtl_material_transactions mmt, \nwip.wip_entities we, \nwip.wip_accounting_classes wac, \nwip.wip_discrete_jobs wdj, \ninv.mtl_transaction_types mtt, \ninv.mtl_system_items_b msi, \ninv.mtl_system_items_b msi2, \ninv.mtl_parameters mp, \napps.mfg_lookups ml \n-- ======= \n-- Material Transaction, org and item joins \n-- ======= \nWHERE  mta.transaction_id = mmt.transaction_id \nAND mmt.transaction_type_id = mtt.transaction_type_id \nAND mta.organization_id = msi.organization_id \nAND mta.inventory_item_id = msi.inventory_item_id \nAND mp.organization_id = mta.organization_id \n-- ======= \n-- Material Transaction date and accounting code joins \n-- ======= \nAND mta.transaction_date >= To_date('&P_TRX_FROM_DD_MON_YYYY', \n'DD\/MON\/YYYY HH24:MI:SS') -- P_TRX_DATE_FROM \nAND mta.transaction_date < To_date('&P_TRX_TO_DD_MON_YYYY', \n'DD\/MON\/YYYY HH24:MI:SS' \n) \n+ 1 -- P_TRX_DATE_TO \n-- ======== \n-- WIP joins to material transactions and to wip tables \n-- ======= \nAND mmt.transaction_source_type_id = 5 \nAND mmt.transaction_source_id = we.wip_entity_id \nAND we.wip_entity_id = wdj.wip_entity_id \nAND wdj.class_code = wac.class_code \nAND mp.organization_id = wac.organization_id \nAND wdj.primary_item_id = msi2.inventory_item_id \nAND mp.organization_id = msi2.organization_id \n-- ========= \n-- WIP MFG Lookup joins \n-- ========= \nAND ml.lookup_type = 'WIP_CLASS_TYPE' \nAND ml.lookup_code = wac.class_type \nGROUP  BY mp.organization_code, \nmp.organization_id, \nmmt.acct_period_id, \nmta.reference_account, \nmta.inv_sub_ledger_id, \nmsi.segment1, \nmsi.description, \nmta.accounting_line_type, \nmtt.transaction_type_name, \nDecode(mta.accounting_line_type, 7, 'WIP', \n  14, '', \n  1, \nDecode (mmt.transaction_action_id, 2, Decode \n(Sign (mta.primary_quantity), -1, \nmmt.subinventory_code, \n1, \nmmt.transfer_subinventory, \nmmt.subinventory_code), \n3, \nDecode (mmt.organization_id, mta.organization_id, \nmmt.subinventory_code, \n     mmt.transfer_subinventory), \n     21, Decode ( \nSign (mta.primary_quantity), -1, \n         mmt.subinventory_code, \n       1, \n     mmt.transfer_subinventory, \n     mmt.subinventory_code), \n     22, Decode ( \nSign (mta.primary_quantity), -1, \n         mmt.subinventory_code, \n       1, \n     mmt.transfer_subinventory, \n     mmt.subinventory_code), \n     28, Decode ( \nSign (mta.primary_quantity), -1, \n         mmt.subinventory_code, \n       1, \n     mmt.transfer_subinventory, \n     mmt.subinventory_code), \n     mmt.subinventory_code)), \nwe.wip_entity_name, \nwdj.class_code, \nml.meaning, \nmsi2.segment1, \nmsi2.description, \nmsi.primary_uom_code, \n-- Fix for version 1.4 \n-- Add for inline columns \nmsi.inventory_item_id, \nmsi.organization_id \n-- End fix for version 1.4 \nUNION ALL \nSELECT mp.organization_code \norganization_code, \nmp.organization_id \norganization_id, \nmmt.acct_period_id \nacct_period_id, \nmta.reference_account \nreference_account, \nmta.inv_sub_ledger_id \ninv_sub_ledger_id, \nmsi.segment1 \nitem_number, \nmsi.description \nitem_description, \nmta.accounting_line_type \naccounting_line_type, \nmtt.transaction_type_name \ntransaction_type_name, \nDecode(mta.accounting_line_type, 7, 'WIP', \n14, '', \n1, Decode (mmt.transaction_action_id, 2 \n  , \n  Decode \n  (Sign (mta.primary_quantity), -1, \n  mmt.subinventory_code, \n   1, \n  mmt.transfer_subinventory, \n  mmt.subinventory_code), \n  3, \nDecode (mmt.organization_id, mta.organization_id, mmt.subinventory_code, \n  mmt.transfer_subinventory), \n  21, Decode ( \n  Sign (mta.primary_quantity), -1, \n      mmt.subinventory_code, \n    1, \n  mmt.transfer_subinventory, \n  mmt.subinventory_code), \n  22, Decode ( \n  Sign (mta.primary_quantity), -1, \n      mmt.subinventory_code, \n    1, \n  mmt.transfer_subinventory, \n  mmt.subinventory_code), \n  28, Decode ( \n  Sign (mta.primary_quantity), -1, \n      mmt.subinventory_code, \n    1, \n  mmt.transfer_subinventory, \n  mmt.subinventory_code), \n  mmt.subinventory_code)) \nsubinventory_code, \n''                                                                   job \n, \n'' \nwip_class, \n'' \nclass_type, \n'' \nfg_item, \n'' \nfg_description, \nmsi.primary_uom_code, \n-- Revision for version 1.4 \nSign(SUM(mta.base_transaction_value)) * Abs(SUM( \nDecode(mmt.transaction_type_id, 24, mmt.quantity_adjusted, \nmmt.primary_quantity))) \nprimary_quantity, \nSUM(mta.base_transaction_value) \/ Decode( \nSign(SUM(mta.base_transaction_value)) \n* \nAbs( \nSUM( \nDecode(mmt.transaction_type_id, 24, \nmmt.quantity_adjusted, \n   mmt.primary_quantity))), 0, 1, \nSign(SUM(mta.base_transaction_value)) \n* \nAbs( \nSUM( \nDecode(mmt.transaction_type_id, 24, \nmmt.quantity_adjusted, \n          mmt.primary_quantity)))) \nitem_cost, \nSUM(base_transaction_value) \nmta_amount \n-- End fix for version 1.4 \nFROM   inv.mtl_transaction_accounts mta, \ninv.mtl_material_transactions mmt, \ninv.mtl_transaction_types mtt, \ninv.mtl_system_items_b msi, \ninv.mtl_parameters mp \n-- ======= \n-- Material Transaction, org and item joins \n-- ======= \nWHERE  mta.transaction_id = mmt.transaction_id \nAND mmt.transaction_type_id = mtt.transaction_type_id \nAND mta.organization_id = msi.organization_id \nAND mta.inventory_item_id = msi.inventory_item_id \nAND mp.organization_id = mta.organization_id \n-- ======== \n-- Material Transaction date and accounting code joins \n-- ======== \nAND mta.transaction_date >= To_date('&P_TRX_FROM_DD_MON_YYYY', \n'DD\/MON\/YYYY HH24:MI:SS') -- P_TRX_DATE_FROM \nAND mta.transaction_date < To_date('&P_TRX_TO_DD_MON_YYYY', \n'DD\/MON\/YYYY HH24:MI:SS' \n) \n+ 1 -- P_TRX_DATE_TO \n-- ========= \n-- WIP joins to material transactions \n-- ======== \nAND mmt.transaction_source_type_id <> 5 \nGROUP  BY mp.organization_code, \nmp.organization_id, \nmmt.acct_period_id, \nmta.reference_account, \nmta.inv_sub_ledger_id, \nmsi.segment1, \nmsi.description, \nmta.accounting_line_type, \nmtt.transaction_type_name, \nDecode(mta.accounting_line_type, 7, 'WIP', \n  14, '', \n  1, \nDecode (mmt.transaction_action_id, 2, Decode \n(Sign (mta.primary_quantity), -1, \nmmt.subinventory_code, \n1, \nmmt.transfer_subinventory, \nmmt.subinventory_code), \n3, \nDecode (mmt.organization_id, mta.organization_id, \nmmt.subinventory_code, \n     mmt.transfer_subinventory), \n     21, Decode ( \nSign (mta.primary_quantity), -1, \n         mmt.subinventory_code, \n       1, \n     mmt.transfer_subinventory, \n     mmt.subinventory_code), \n     22, Decode ( \nSign (mta.primary_quantity), -1, \n         mmt.subinventory_code, \n       1, \n     mmt.transfer_subinventory, \n     mmt.subinventory_code), \n     28, Decode ( \nSign (mta.primary_quantity), -1, \n         mmt.subinventory_code, \n       1, \n     mmt.transfer_subinventory, \n     mmt.subinventory_code), \n     mmt.subinventory_code)), \n'', \n'', \n'', \n'', \n'', \nmsi.primary_uom_code, \n-- Fix for version 1.4 \n-- Add for inline columns \nmsi.inventory_item_id, \nmsi.organization_id \n-- End fix for version 1.4 \n) mtl_acct \n-- ======= \n-- Inventory Org accounting period joins \n-- ======== \nWHERE  oap.period_name = ah.period_name \n       AND oap.organization_id = mtl_acct.organization_id \n       -- ======= \n       -- Lookup values to see more detail \n       -- ======= \n       AND ml.lookup_type = 'CST_ACCOUNTING_LINE_TYPE' \n       AND ml.lookup_code = mtl_acct.accounting_line_type \n       -- ======= \n       -- using the base tables to avoid the performance issues \n       -- with org_organization_definitions and hr_operating_units \n       -- ======= \n       AND hoi.org_information_context = 'Accounting Information' \n       AND hoi.organization_id = mtl_acct.organization_id \n       AND hoi.organization_id = haou.organization_id \n       -- this gets the organization name \n       AND haou2.organization_id = To_number(hoi.org_information3) \n       -- this gets the operating unit id \n       AND gl.ledger_id = To_number(hoi.org_information1) -- get the ledger_id \n       -- and gl.name = nvl('&P_LEDGER',gl.name) -- P_LEDGER \n       AND gl.name = Decode('&P_LEDGER', '%', gl.name, \n                                         NULL, gl.name, \n                                         '&P_LEDGER') -- P_LEDGER \n       -- ======== \n       -- SLA table joins to get the exact account numbers \n       -- ======= \n       AND ent.entity_code = 'MTL_ACCOUNTING_EVENTS' \n       AND ent.application_id = 707 \n       AND xe.application_id = ent.application_id \n       AND xe.event_id = xdl.event_id \n       AND ah.entity_id = ent.entity_id \n       AND ah.ledger_id = ent.ledger_id \n       AND ah.application_id = al.application_id \n       AND ah.application_id = 707 \n       AND ah.event_id = xe.event_id \n       AND ah.ae_header_id = al.ae_header_id \n       AND al.application_id = ent.application_id \n       AND al.ledger_id = ah.ledger_id \n       AND al.ae_header_id = xdl.ae_header_id \n       AND al.ae_line_num = xdl.ae_line_num \n       AND xdl.application_id = ent.application_id \n       AND xdl.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS' \n       AND mtl_acct.inv_sub_ledger_id = xdl.source_distribution_id_num_1 \n       AND gcc1.code_combination_id = al.code_combination_id \n-- ======= \nGROUP  BY gl.name, \n          haou2.name, \n          mtl_acct.organization_code, \n          oap.period_name, \n          gcc1.segment1, \n          gcc1.segment2, \n          gcc1.segment3, \n          gcc1.segment4, \n          gcc1.segment5, \n          mtl_acct.item_number, \n          mtl_acct.item_description, \n          mtl_acct.subinventory_code, \n          mtl_acct.wip_class, \n          mtl_acct.class_type, \n          mtl_acct.job, \n          mtl_acct.fg_item, \n          mtl_acct.fg_description, \n          ml.meaning, \n          mtl_acct.transaction_type_name, \n          mtl_acct.primary_uom_code, \n          gl.currency_code, \n          mtl_acct.item_cost \nORDER  BY 1, \n          3, \n          4, \n          7, \n          8, \n          9, \n          10, \n          11, \n          14, \n          16, \n          21; \n\n<\/code><\/pre>\n\n\n\n
SELECT b.name                       batch_name, \n       b.description                batch_description, \n       b.running_total_accounted_dr batch_total_dr, \n       b.running_total_accounted_cr batch_total_cr, \n       b.status                     batch_status, \n       b.default_effective_date     effective_date, \n       b.default_period_name        batch_period_name, \n       b.creation_date, \n       u.user_name                  batch_created_by, \n       h.je_category, \n       h.je_source, \n       h.period_name                je_period_name, \n       h.name                       journal_name, \n       h.status                     journal_status, \n       h.creation_date              je_created_date, \n       u1.user_name                 je_created_by, \n       h.description                je_description, \n       h.running_total_accounted_dr je_total_dr, \n       h.running_total_accounted_cr je_total_cr, \n       l.je_line_num                line_number, \n       l.ledger_id, \n       glcc.concatenated_segments   Account, \n       l.entered_dr, \n       l.entered_cr, \n       l.accounted_dr, \n       l.accounted_cr, \n       xlal.unrounded_accounted_dr  XLA_unrounded_accounted_dr, \n       xlal.unrounded_accounted_cr  XLA_unrounded_accounted_cr, \n       l.description, \n       xlal.code_combination_id, \n       xlal.accounting_class_code, \n       xlal.accounted_dr            xlal_accounted_dr, \n       xlal.accounted_cr            xlal_accounted_cr, \n       xlal.description             xlal_description, \n       xlal.accounting_date         xlal_accounting_date, \n       xlate.entity_code            xlate_entity_code, \n       xlate.source_id_int_1        xlate_source_id_int_1, \n       xlate.source_id_int_2        xlate_source_id_int_2, \n       xlate.source_id_int_3        xlate_source_id_int_3, \n       xlate.security_id_int_1      xlate_security_id_int_1, \n       xlate.security_id_int_2      xlate_security_id_int_2, \n       xlate.transaction_number     xlate_transaction_number, \n       mmt.transaction_id, \n       mmt.transaction_reference, \n       mmt.organization_id, \n       mmt.transaction_date, \n       mtt.transaction_type_name \nFROM   gl_je_batches b, \n       gl_je_headers h, \n       gl_je_lines l, \n       fnd_user u, \n       fnd_user u1, \n       gl_code_combinations_kfv glcc, \n       gl_import_references gir, \n       xla_ae_lines xlal, \n       xla_ae_headers xlah, \n       xla_events xlae, \n       xla.xla_transaction_entities xlate, \n       mtl_material_transactions mmt, \n       mtl_transaction_types mtt \nWHERE  b.created_by = u.user_id \n       AND h.created_by = u1.user_id \n       AND b.je_batch_id = h.je_batch_id \n       AND h.je_header_id = l.je_header_id \n       AND xlal.code_combination_id = glcc.code_combination_id \n       AND l.je_header_id = gir.je_header_id \n       AND l.je_line_num = gir.je_line_num \n       AND gir.gl_sl_link_table = xlal.gl_sl_link_table \n       AND gir.gl_sl_link_id = xlal.gl_sl_link_id \n       AND xlal.ae_header_id = xlah.ae_header_id \n       AND xlah.event_id = xlae.event_id \n       AND xlae.entity_id = xlate.entity_id \n       AND xlae.application_id = xlate.application_id \n       AND xlate.source_id_int_1 = mmt.transaction_id \n       AND mmt.transaction_type_id = mtt.transaction_type_id \n       AND h.je_source = 'Cost Management' \n       AND h.je_category = 'Inventory' \n       AND h.period_name = '&period_name'; <\/code><\/pre>\n\n\n\n
SELECT gjh.period_name            \"Period name\", \n       gjb.name                   \"Batch name\", \n       gjjlv.header_name          \"Journal entry\", \n       gjjlv.je_source            \"Source\", \n       glcc.concatenated_segments \"Accounts\", \n       mmt.subinventory_code      \"Subinventory\", \n       glcc3.segment4             \"Costcenter\", \n       gjjlv.line_entered_dr      \"Entered debit\", \n       gjjlv.line_entered_cr      \"Entered credit\", \n       gjjlv.line_accounted_dr    \"Accounted debit\", \n       gjjlv.line_accounted_cr    \"Accounted credit\", \n       gjjlv.currency_code        \"Currency\", \n       mtt.transaction_type_name  \"Transaction type\", \n       To_char(mta.transaction_id)\"Transaction_number\", \n       mta.transaction_date       \"Transaction_date\", \n       msi.segment1               \"Reference\" \nFROM   apps.gl_je_journal_lines_v gjjlv, \n       gl_je_lines gje, \n       mtl_transaction_accounts mta, \n       mtl_material_transactions mmt, \n       mtl_system_items_b msi, \n       gl_je_headers gjh, \n       gl_je_batches gjb, \n       apps.gl_code_combinations_kfv glcc, \n       apps.gl_code_combinations_kfv glcc2, \n       mtl_secondary_inventories msin, \n       mtl_transaction_types mtt, \n       mtl_secondary_inventories cost, \n       gl_code_combinations glcc3 \nWHERE  gjjlv.period_name BETWEEN 'NOV-2008' AND 'DEC-2008' \n       AND gje.code_combination_id = gje.code_combination_id \n       AND gjjlv.line_je_line_num = gje.je_line_num \n       AND gl_sl_link_table = 'MTA' \n       AND gjjlv.je_header_id = gje.je_header_id \n       AND mmt.inventory_item_id = msi.inventory_item_id \n       AND gje.je_header_id = gjh.je_header_id \n       AND gjh.je_batch_id = gjb.je_batch_id \n       AND mmt.organization_id = msi.organization_id \n       AND mmt.organization_id = msin.organization_id \n       AND mmt.subinventory_code = msin.secondary_inventory_name \n       AND mta.gl_sl_link_id = gje.gl_sl_link_id \n       AND mta.reference_account = glcc.code_combination_id \n       AND msin.expense_account = glcc2.code_combination_id \n       AND mmt.transaction_id = mta.transaction_id \n       AND mtt.transaction_type_id = mmt.transaction_type_id \n       AND cost.organization_id(+) = mmt.organization_id \n       AND cost.secondary_inventory_name(+) = mmt.subinventory_code \n       AND glcc3.code_combination_id(+) = cost.expense_account <\/code><\/pre>\n<\/HTML>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[29],"tags":[],"class_list":["post-20675","post","type-post","status-publish","format-standard","hentry","category-base-de-conhecimentos"],"_links":{"self":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/20675","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=20675"}],"version-history":[{"count":8,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/20675\/revisions"}],"predecessor-version":[{"id":20683,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=\/wp\/v2\/posts\/20675\/revisions\/20683"}],"wp:attachment":[{"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=20675"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/orabr.virttus.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=20675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}