Skip to main content

Home/ BI-TAGS/ Group items tagged ebs

Rss Feed Group items tagged

cezarovidiu

Inventory Aging Query Oracle Applications R12 - 0 views

    • cezarovidiu
       
      SELECT ev1.INVENTORY_ITEM_ID,   ev1.ITEM_CODE ITEM,   XXRG_HR_PKG.get_org_name(:ORG_ID) ORGANIZATION,   ev1.DESCRIPTION,   SUM(Buk11) buk11,   SUM(Buk21) buk21 ,   SUM(Buk31) buk31 ,   SUM(Buk41) buk41,   SUM(Buk51) buk51  FROM   (SELECT ev1.INVENTORY_ITEM_ID,     ITEM_CODE,     DESCRIPTION,     (     CASE       WHEN age BETWEEN :BUK1_DAYS_FROM AND :BUK1_DAYS_TO       THEN SUM(aqty)       ELSE NULL     END) Buk11,     (     CASE       WHEN age BETWEEN :BUK2_DAYS_FROM AND :BUK2_DAYS_TO       THEN SUM(aqty)       ELSE NULL     END) Buk21,     (     CASE       WHEN age BETWEEN :BUK3_DAYS_FROM AND :BUK3_DAYS_TO       THEN SUM(aqty)       ELSE NULL     END) Buk31,     (     CASE       WHEN age BETWEEN :BUK4_DAYS_FROM AND :BUK4_DAYS_TO       THEN SUM(aqty)       ELSE NULL     END) Buk41,     (     CASE       WHEN age >= :BUK5_DAYS_FROM       THEN SUM(aqty)       ELSE NULL     END) Buk51   FROM     (SELECT        ITEM_CODE,       DESCRIPTION,       TRANSACTION_DATE,       TRANSACTION_QUANTITY,       SUM(TRANSACTION_QUANTITY) OVER(PARTITION BY INVENTORY_ITEM_ID ORDER BY TRANSACTION_ID,TRANSACTION_DATE)+ NVL(NQTY,0) BFF ,       (       CASE         WHEN TRANSACTION_QUANTITY > SUM(TRANSACTION_QUANTITY) OVER(PARTITION BY INVENTORY_ITEM_ID ORDER BY TRANSACTION_ID,TRANSACTION_DATE)+ NVL(NQTY,0)         THEN SUM(TRANSACTION_QUANTITY) OVER(PARTITION BY INVENTORY_ITEM_ID ORDER BY TRANSACTION_ID,TRANSACTION_DATE)                       +NVL(NQTY,0)         ELSE TRANSACTION_QUANTITY       END) AQTY       --,TCOST       ,       NVL(fnd_conc_date.string_to_date(:TILL_DATE),SYSDATE)-fnd_conc_date.string_to_date(TRANSACTION_DATE) AGE,       inventory_item_id     FROM       (SELECT V1.TRANSACTION_ID,         V1.ITEM_CODE,         V1.DESCRIPTION,         TRUNC(         CASE           WHEN V1.TRANSACTION_TYPE_ID = 4
cezarovidiu

How to join GL tables with XLA (SubLedger Accounting) tables - 0 views

  • GL_JE_BATCHES (je_batch_id)                                   => GL_JE_HEADERS (je_batch_id) GL_JE_HEADERS (je_header_id)                                  => GL_JE_LINES (je_header_id) GL_JE_LINES (je_header_id,  je_line_num)                      => GL_IMPORT_REFERENCES (je_header_id, je_line_num) GL_IMPORT_REFERENCES (gl_sl_link_table, gl_sl_link_id)        => XLA_AE_LINES (gl_sl_link_table, gl_sl_link_id) XLA_AE_LINES (application_id, ae_header_id)                   => XLA_AE_HEADERS (application_id, ae_header_id)  XLA_AE_HEADERS (application_id, event_id)                     => XLA_EVENTS (application_id, event_id)    XLA_EVENTS (application_id, entity_id)                        => XLA.XLA_TRANSACTION_ENTITIES (application_id, entity_id) 
  • The source_id_int_1 column of xla.xla_transaction_entities stores the primary_id value for the transactions. You can join the xla.xla_transaction_entities table with the corresponding transactions table for obtaining additional information of the transaction. For e.g you join the xla.xla_transaction_entities table with ra_customer_trx_all for obtaining receivables transactions information or with mtl_material_transactions table for obtaining material transactions information. The entity_id mappings can be obtained from the XLA_ENTITY_ID_MAPPINGS table
  •  
    "How to join GL tables with XLA (SubLedger Accounting) tables"
cezarovidiu

Oracle Apps technical - 0 views

  •  
    "Oracle Apps technical"
1 - 20 of 22 Next ›
Showing 20 items per page