Dear friends ,

Lets understand the Important Oracle Cloud Procurement Tables and its feature in details .

  1. PO_ACTION_HISTORY
  2. PO_AGENTS
  3. PO_AGENT_ACCESSES
  4. PO_AGENT_ASSIGNMENTS
  5. PO_APPROVED_SUPPLIER_LIST
  6. PO_ASL_ATTRIBUTES
  7. PO_ASL_DOCUMENTS
  8. PO_ASL_STATUSES
  9. PO_ATTRIBUTE_VALUES
  10. PO_ATTRIBUTE_VALUES_DRAFT
  11. PO_ATTRIBUTE_VALUES_TLP
  12. PO_ATTRIBUTE_VALUES_TLP_DRAFT
  13. PO_ATTR_VALUES_ARCHIVE
  14. PO_ATTR_VALUES_INTERFACE
  15. PO_ATTR_VALUES_TLP_ARCHIVE
  16. PO_ATTR_VALUES_TLP_INTERFACE
  17. PO_BCEA_DATA
  18. PO_BUYER_ASSIGNMENT_RULES
  19. PO_COMMUNICATION_GT
  20. PO_CONFIG_COMPONENTS
  21. PO_CONFIG_COMPONENTS_ARCHIVE
  22. PO_CONFIG_COMPONENTS_DRAFT
  23. PO_CO_TEMPLATES_B
  24. PO_CO_TEMPLATES_TL
  25. PO_CO_TEMPLATE_ATTR_VALUES
  26. PO_DISTRIBUTIONS_ALL
  27. PO_DISTRIBUTIONS_ARCHIVE_ALL
  28. PO_DISTRIBUTIONS_DRAFT_ALL
  29. PO_DISTRIBUTIONS_GT
  30. PO_DISTRIBUTIONS_INTERFACE
  31. PO_DOCUMENT_TOTALS_GT
  32. PO_DOCUMENT_TYPES_ALL_B
  33. PO_DOCUMENT_TYPES_ALL_TL
  34. PO_DOC_STYLE_HEADERS
  35. PO_DOC_STYLE_LINES_B
  36. PO_DOC_STYLE_LINES_TL
  37. PO_DOC_STYLE_VALUES
  38. PO_EVENT_AUDIT
  39. PO_GA_ORG_ASSIGNMENTS
  40. PO_GA_ORG_ASSIGNMENTS_ARCHIVE
  41. PO_GA_ORG_ASSIGN_DRAFT
  42. PO_GA_ORG_ASSIGN_INTERFACE
  43. PO_HAZARD_CLASSES_B
  44. PO_HAZARD_CLASSES_TL
  45. PO_HEADERS_ALL
  46. PO_HEADERS_ARCHIVE_ALL
  47. PO_HEADERS_DRAFT_ALL
  48. PO_HEADERS_GT
  49. PO_HEADERS_INTERFACE
  50. PO_INTERFACE_ERRORS
  51. PO_LINES_ALL
  52. PO_LINES_ARCHIVE_ALL
  53. PO_LINES_DRAFT_ALL
  54. PO_LINES_GT
  55. PO_LINES_INTERFACE
  56. PO_LINE_LOCATIONS_ALL
  57. PO_LINE_LOCATIONS_ARCHIVE_ALL
  58. PO_LINE_LOCATIONS_DRAFT_ALL
  59. PO_LINE_LOCATIONS_GT
  60. PO_LINE_LOCATIONS_INTERFACE
  61. PO_LINE_TYPES_B
  62. PO_LINE_TYPES_TL
  63. PO_NOTIFICATION_CONTROLS
  64. PO_NOTIFICATION_CTRL_ARCHIVE
  65. PO_NOTIFICATION_CTRL_DRAFT
  66. PO_ONLINE_REPORT_TEXT
  67. PO_ONLINE_REPORT_TEXT_GT
  68. PO_PDOI_PROGRESS
  69. PO_RECENT_ACTIVITIES
  70. PO_REQ_SPLIT_LINES_GT
  71. PO_RETROPRICE_GT
  72. PO_SEARCH_SUGGESTIONS_TLP
  73. PO_SEARCH_SUGGESTIONS_TLP_GT
  74. PO_SESSION_GT
  75. PO_SYSTEM_PARAMETERS_ALL
  76. PO_UNIQUE_IDENTIFIER_CONT_ALL
  77. PO_UN_NUMBERS_B
  78. PO_UN_NUMBERS_TL
  79. PO_VALIDATION_RESULTS_GT
  80. PO_VERSIONS
Important Views 

Oracle Certified Expert, An Oracle SCM Fusion Cloud Tech with added advantage of experienced as EBS Apps Technical with unique combinations of skills including Python with more than 10 years of Industrial Experience.

LinkedIn profile –                                            https://www.linkedin.com/in/ghanshyammondal/

Blog -                                                                https://oracleapplicationlearning.blogspot.com/

YouTube(Proficient Tech Learning) - https://www.youtube.com/watch?v=8xd36SRMWBc

Check my Books at Amazon             -

1.      https://www.amazon.in/Build-First-Oracle-Database-Query/dp/1636331270/ref=sr_1_1?dchild=1&keywords=build+your+first+oracle+database+sql+query&qid=1605229038&sr=8-1

2.      https://www.amazon.in/dp/1636332943/ref=cm_sw_r_wa_apa_i_gYNCFb4RQSXT1

Contact : 9611668092(WhatsApp) For More details Contact me


Comments

Post a Comment

Popular posts from this blog

How to Customize AP Invoice Approval in Oracle Fusion cloud Application using Business Process Management(BPM)

Image
Dear Viewers ,   Lets Understand with different case studies How to Customize AP Invoice Approval in Oracle Fusion cloud Application using Business Process Management(BPM) .   Case Study 1 #Configure an approval rule to route a notification to a requestor  It covers the most common business use cases of invoice approval in a Payables Department.   Each business use case provides how to configure the invoice approval rules, using various participants, invoice attributes, and list builders such as:   • Single Approver   • Approval Group   • Supervisor Hierarchy   • Job level Hierarchy   • Position Hierarchy   The information presented in this document is intended to help various users (Payables business users, Approval workflow administrators and Consultants) who are involved in the configuration of invoice approval policy to meet the various business use cases of invoice approvals in a Payables Department.  Note: 1) Refer to the Appendix section for navigation details for configuring in
Read more
Image
Sometime , We need to know specific relationship between some important tables . Lets come to know one such important SQL Query to know the relationship between Transfer Order, Pick Slip Number, and Supply Orchestration SQL Query can be used to show the link between a Transfer Order, Pick Slip Number, and Supply Orchestration Belo is the screenshot for instance    The Required output We need from the report is below  The Query used for above requirement is below  SELECT  a.pick_slip_number ,   b.source_header_number transfer_order_number,   c.supply_order_number ,   c.supply_order_reference_number FROM   INV_PICK_SLIP_NUMBERS a ,   WSH_DELIVERY_DETAILS b ,   DOS_SUPPLY_HEADERS c ,   INV_TRANSFER_ORDER_HEADERS d,   INV_TRANSFER_ORDER_LINES e WHERE 1 =1   AND a.PICK_SLIP_NUMBER = 11022   AND a.pick_slip_batch_id = b.batch_id   AND b.source_header_number = d.header_number   AND d.header_id = e.header_id   AND e.source_header_id = c.header_id Thank you , Please do comment and share here .
Read more
Dear Friends ,  Below Query can be useful to find the Unit cost of Item at costing Module . We can have  FOR Unit cost OF Material under specified Val Unit code AND Cost Book SELECT TO_CHAR ( CICT . total_cost , 'fm99999999d00' ) UNIT_COST FROM CST_ITEM_COSTS_V CICT , CST_TRANSACTIONS CT WHERE 1 = 1 AND CICT . ITEM_NUMBER = :P_Item_Number AND CICT . TRANSACTION_ID = CT . TRANSACTION_ID AND TRUNC ( CICT . PREVIOUS_COST , 6 ) = ( SELECT TRUNC ( UNIT_COST_AVERAGE , 6 ) FROM cst_perpavg_cost WHERE PERPAVG_COST_ID = ( SELECT MIN ( PERPAVG_COST_ID ) FROM cst_perpavg_cost WHERE TRANSACTION_ID = CICT . TRANSACTION_ID ) ) AND CICT . VAL_UNIT_CODE LIKE 'XXXXXX' AND TO_CHAR ( CT . TRANSACTION_DATE , 'DD-MM-YYYY' ) BETWEEN TO_CHAR ( :P_START_DATE , 'DD-MM-YYYY' ) AND TO_CHAR ( :P_END_DATE , 'DD-MM-YYYY' ) And If you want to have the Query to fetch Current Item cost
Read more