Running the latest Oracle JInitiator | Aaron Parker - 0 views
Inventory Aging Query Oracle Applications R12 - 0 views
-
-
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
-
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 Purge Obsolete Workflow Runtime Data for Applications - 0 views
Oracle Apps technical - 0 views
Oracle E-Business Suite R12 12.1.3, build a Vision Instance using Oracle Virtual Box | ... - 0 views
Oracle Apps Technical................: Complete Order to Cash(O2C) Techno-Functional fl... - 0 views
-
Complete Order to Cash(O2C) Techno-Functional flow in R12
Oracle Accounts Receivables (AR) - key Tables 2 | Business Intelligence | Dashboards - 0 views
-
AR_PAYMENT_SCHEDULES_ALL
Transaction to Receipt flow in Oracle Receivables | Oracle Maniacs' Notes - 0 views
-
Transaction to Receipt flow in Oracle Receivables