Group items tagged

Filter: All | Bookmarks | Topics Simple Middle

Inventory Aging Query Oracle Applications R12 - 0 views

inventory-aging-report-r12.blogspot.ro

ebs aging query inventory apps oracle

shared by cezarovidiu on 15 Mar 13 - No Cached

- cezarovidiu on 15 Mar 13
  
  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
  
  <div class="cArrow"> </div><div class="cContentInner">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 </div>
  
  ...
  
  Cancel
...

Cancel

13 things to consider when implementing a CRM plan | Econsultancy - 0 views

econsultancy.com/...r-when-implementing-a-crm-plan

CRM implementare

shared by cezarovidiu on 08 Jul 14 - No Cached

These are few of the benefits of implementing a good quality CRM All of your clients’ information is stored in one place, it’s easy to update and share with the whole team. Updates by colleagues should be saved immediately. Every member of your team will be able to see the exact point when your business last communicated with a client, and what the nature of that communication was. CRMs can give you instant metrics on various aspects of your business automatically.  Reports can be generated. These can also be used to forecast and plan for the future. You will be able to see the complete history of your company’s interaction with a client. Calendars and diaries can be integrated, relating important events or tasks with the relevant client.  Suitable times can be suggested to contact customers and set reminders.
...

Cancel
Finding one system that will fit your needs in one package may not be possible, so be aware that you may need to customise it to fit into your company. There are infinite possibilities here so don’t get too carried away as costs will rise accordingly.
...

Cancel
Ensure that the CRM works on mobile devices and can be accessed remotely. Employees aren’t necessarily sat at their desks when it needs to be used or updated. Real-time updates are necessary for ensuring that clients aren’t contacted twice with the exact same follow up.
...

Cancel
...4 more annotations...
Will it work for Outlook, Gmail or whichever email provider your company uses? 
...

Cancel
Does you CRM have full social media integration? It’s vital that any customers or clients interacting with you on social channels can be included in your CRM updates. You will find this happens increasingly as your public facing channels become more popular. For more detailed information download our best practice guide CRM in the social age.  
...

Cancel
Do you have a fully CRM trained analytics team that can study and understand the data and reports the system will generate? It’s probably wise to implement a cleansing plan for your existing data before the new system is implemented. Sifting through contacts to remove any duplicated or defunct leads.
...

Cancel
Having an extra piece of software in the company, especially one as integral as this, means there’s a lot more to manage and possibly to go wrong. Make sure you have the technical support in place to ensure its smooth running.
...

Cancel