P2P Cycle - Base Table

 YouTube Videos

https://www.youtube.com/channel/UCWFJCCCLUY0sgLrBsJQtjiw?view_as=subscriber

1. CREATE ITEM AND TYPE IS FINISHED GOODS

=========================================

select * from  MTL_SYSTEM_ITEMS_B where  SEGMENT1='CDM1'

--INVENTORY_ITEM_ID=238205

2. Interface ITEM for requisition,

===================================

   Submit the concurrent program "Min-max planning report" and data is populate the interface table.

  

select * from  po_requisitions_interface_all   where  ITEM_ID=238205

select * from  hr_operating_units where  name='Vision Operations'

3. Submit "Requisition Import" to import requisition and delete the records from interface table.

================================================================================

select * from  po_requisition_headers_all where  REQUISITION_HEADER_ID=537803

select * from  po_requisition_lines_all where  request_id=7477416 and org_id=204 and ITEM_ID=238205

select * from  po_req_distributions_all where  REQUISITION_LINE_ID=587239

select * from  gl_code_combinations_kfv where  code_combination_id=13401

-- charge account -- 01-000-1410-0000-000

4. Purchasing department received the Requistion from Inventory peoples

   Purchasing department prepare RFQ to send the supplier quote

   ============================================================

  

   select * from  PO_HEADERS_ALL where  SEGMENT1='308' AND ORG_ID=204 AND TYPE_LOOKUP_CODE='RFQ'

  

   select * from  PO_LINES_ALL where  PO_HEADER_ID=299875

  

   select * from  PO_LINE_LOCATIONS_ALL where  PO_LINE_ID=371230

  

   select * from  ORG_ORGANIZATION_DEFINITIONS where  ORGANIZATION_ID=207

  

   --- Going to request the Quoate from the suppliers

  

   select * from  po_rfq_vendors where  PO_HEADER_ID=299875

  

5. Print the RFQ and sent to suppliers

   Submit "Printed RFQ Report (XML)"

   =================================

  

   supplier sent the Quote and enter into the system  

 

   select * from  PO_HEADERS_ALL where  SEGMENT1='503' AND ORG_ID=204 AND TYPE_LOOKUP_CODE='QUOTATION'

  

   select * from  PO_LINES_ALL where  PO_HEADER_ID=299876

  

   select * from  PO_LINE_LOCATIONS_ALL where  PO_LINE_ID=371231 --9.7

  

   ---

  

   select * from  PO_HEADERS_ALL where  SEGMENT1='504' AND ORG_ID=204 AND TYPE_LOOKUP_CODE='QUOTATION'

  

   select * from  PO_LINES_ALL where  PO_HEADER_ID=299877

  

   select * from  PO_LINE_LOCATIONS_ALL where  PO_LINE_ID=371232 --9.6

  

6. CREATE PO AMONG SELECTED SUPPLIERS

======================================

  

   select * from  PO_HEADERS_ALL where  SEGMENT1='6576' AND ORG_ID=204 AND TYPE_LOOKUP_CODE='STANDARD'

  

   select * from  PO_LINES_ALL where  PO_HEADER_ID=299878

  

   select * from  PO_LINE_LOCATIONS_ALL where  PO_LINE_ID=371233

  

7. CREATE RECEIPTS IN INVENTORY TEAM, NO AMOUNT DETAILS PRESENT

================================================================

RECEIPT# 23698

select * from  RCV_SHIPMENT_HEADERS where  RECEIPT_NUM='23698'

select * from  RCV_SHIPMENT_LINES where  SHIPMENT_HEADER_ID=7714324

select * from  RCV_TRANSACTIONS  where  SHIPMENT_HEADER_ID=7714324

select * from  MTL_MATERIAL_TRANSACTIONS where INVENTORY_ITEM_ID=238205

select * from  MTL_MATERIAL_TRANSACTIONS where  RCV_TRANSACTION_ID IN (7712354,

7712355

)

INCREASED ONHAND QUANTITIES

===========================

select * from  MTL_ONHAND_QUANTITIES_DETAIL where INVENTORY_ITEM_ID=238205

-----------------------------------

8. CREATE AP INVOICES

====================

select * from  AP_INVOICES_ALL where  INVOICE_NUM='6576-INV'

select * from  AP_INVOICE_LINES_ALL where  INVOICE_ID=566060

select ACCOUNTING_EVENT_ID from  AP_INVOICE_DISTRIBUTIONS_ALL where  INVOICE_ID=566060

select * from  AP_PAYMENT_SCHEDULES_ALL where  INVOICE_ID=566060 --AMOUNT_REMAINING  PAYMENT_STATUS_FLAG

SLA

===

select * from  XLA_EVENTS where  EVENT_ID=6197566

select * from  XLA_AE_HEADERS where  EVENT_ID=6197566

select * from  XLA_AE_LINES where  AE_HEADER_ID=8109566

select * from  GL_INTERFACE

select * from  XLA.XLA_TRANSACTION_ENTITIES where  SOURCE_ID_INT_1=566060

select * from  GL_IMPORT_REFERENCES where  (gl_sl_link_table,gl_sl_link_id) IN (select gl_sl_link_table,gl_sl_link_id from  XLA_AE_LINES where  AE_HEADER_ID=8109566)

select * from  GL_JE_BATCHES where  JE_BATCH_ID=5350730

select * from  GL_JE_HEADERS where  JE_BATCH_ID=5350730

select * from  GL_JE_LINES where  JE_HEADER_ID=7104873

PAYMENTS IS DONE

================

select * from  AP_INVOICES_ALL where  INVOICE_NUM='6576-INV'  -- AMOUNT PAID

select * from  AP_PAYMENT_SCHEDULES_ALL where  INVOICE_ID=566060 --AMOUNT_REMAINING  PAYMENT_STATUS_FLAG

select * from  AP_INVOICE_PAYMENTS_ALL where  INVOICE_ID=566060

--ACCOUNTING-EVENT_ID=6197567

select * from  AP_CHECKS_ALL where  CHECK_ID=161702 AND CHECK_NUMBER='95004' -- -PAYMENT_ID

select * from  IBY_PAYMENTS_ALL where  PAYMENT_PROCESS_REQUEST_NAME='Quick Payment: ID=161702' -- PAYMENT AND SUPPLIER INFORMATIONS

-- PAYMENT_INSTRUCTION_ID

-- PAYMENT_SERVICE_REQUEST_ID

select * from  IBY_DOCS_PAYABLE_ALL where  PAYMENT_SERVICE_REQUEST_ID=31444 -- INVOICE INFORMATIONS

--- CALLING_APP_DOC_UNIQUE_REF2 INVOICE ID

select * from  IBY_PAY_INSTRUCTIONS_ALL where  PAYMENT_INSTRUCTION_ID=70474

select * from  AP_PAYMENT_HISTORY_ALL  where  CHECK_ID=161702

--ACCOUNTING_EVENT_ID

SLA

===

select * from  XLA_EVENTS where  EVENT_ID=6197567

select * from  XLA_AE_HEADERS where  EVENT_ID=6197567

select * from  XLA_AE_LINES where  AE_HEADER_ID=8109567

select * from  GL_INTERFACE

select * from  XLA.XLA_TRANSACTION_ENTITIES where ENTITY_ID=6126421-- SOURCE_ID_INT_1=104837

--TRANSACTION_NUMBER IS CHECKNUMBER

select * from  GL_IMPORT_REFERENCES where  (gl_sl_link_table,gl_sl_link_id) IN (select gl_sl_link_table,gl_sl_link_id from  XLA_AE_LINES where  AE_HEADER_ID=8109567)

select * from  GL_JE_BATCHES where  JE_BATCH_ID=5350732

select * from  GL_JE_HEADERS where  JE_BATCH_ID=5350730

select * from  GL_JE_LINES where  JE_HEADER_ID=7104873

-----------------