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
-----------------
