Receiving Transactions SQL

Receiving Transactions

select * from RCV_TRANSACTIONS_V
select * from RCV_TRANSACTIONS_INTERFACE
select * from MTL_TRANSACTION_LOTS_TEMP
select * from MTL_SERIAL_NUMBERS_TEMP
select * from QA_RESULTS_V
select * from ic_lots_mst
select * from mtl_serial_numbers
select * from wms_license_plate_numbers
select * from rcv_lots_supply
select * from oe_lot_serial_numbers
select * from rcv_transactions
select * from sy_reas_cds
select * from mtl_serial_numbers_all_v
select * from qa_plan_char_value_lookups
select * from mtl_lot_numbers
select * from mtl_serial_numbers
select * from wip_operations_all_v
select * from cs_counter_values
select * from wip_discrete_jobs_all_v
select * from cs_incidents
select * from qa_ahl_mr
select * from cs_counters
select * from qa_csi_item_instances
select * from mtl_system_items_kfv
select * from wms_lpn_contents
select * from ic_item_mst
select * from ic_tran_pnd
select * from ic_loct_inv
select * from ic_loct_mst
select * from hr_employees
select * from pjm_projects_all_v
select * from PA_TASKS_EXPEND_V
select * from wip_osp_jobs_val_v
select * from mtl_kanban_cards
select * from hr_locations_all
select * from hr_locations_all_tl
select * from mtl_serial_numbers_all_v
select * from hz_parties----------
select * from po_pos_val_v 
select * from rcv_transactions_interface
select * from PO_LINE_LOCATIONS
select * from PO_REQUISITION_LINES 
select * from wip_discrete_jobs_all_v 
select * from oke_k_headers_lov_v 
select * from oke_k_lines_full_v 
select * from oke_k_deliverables_vl 
select * from OE_SOLD_TO_ORGS_V
select * from cst_cost_groups
select * from rcv_shipment_headers
select * from rcv_shipment_lines
select * from rcv_transactions_interface
select * from oe_order_lines_all
select * from oe_order_headers_all
select * from oe_transaction_types_all
select * from MTL_TRANSACTION_TYPES
select * from oe_transaction_types_tl
select * from rcv_transactions
select * from rcv_supply
select * from oe_transaction_types
select * from oe_po_enter_receipts_v 
select * from mtl_customer_items_all_v 
select * from mtl_lot_issues_val_v
select * from mtl_uom_conversions -----------
select * from mtl_uom_class_conversions --------------
select * from po_lines_supplier_items_v 
select * from per_all_people_f ---------------
select * from financials_system_parameters 
select * from org_freight
select * from mtl_supply -------------
select * from org_organization_definitions --------------
select * from po_vendor_sites 
select * from rcv_sources_both_val_v ----------------
select * from rcv_suppliers_val_v -----------
select * from hr_locations_all ---------
select * from hr_locations_all_tl ------------
select * from mtl_item_revisions -----------
select * from mtl_system_items_kfv ----
select * from po_requisition_lines 
select * from financials_system_parameters 
select * from po_lookup_codes ----------------
select * from po_requisition_headers 
select * from rcv_shipment_lines---------
select * from rcv_transactions------------
select * from po_line_locations 
select * from hr_locations_all_tl -----------
select * from po_releases 
select * from po_pos_all_v 
select * from po_pos_val_v 
select * from per_all_people_f ------------
select * from rcv_transactions_interface
select * from mtl_serial_numbers ------------------SERIAL----------
select * from mtl_transaction_lots_temp 
select * from mtl_employees_view ----------
select * from po_suppliers_val_v ---------------
select * from mtl_employees_current_view -------------
select * from mtl_item_status ---------------------------
select * from org_organization_definitions ------------
select * from mtl_secondary_inventories --------------
select * from mtl_transaction_types ------------
select * from mtl_txn_source_types -----------
select * from mtl_system_items_vl ------------
select * from mtl_system_items_kfv --------
select * from mtl_category_sets_vl ---------
select * from mtl_physical_inventories_v ----------
select * from mtl_kanban_cards 
select * from mtl_item_sub_inventories 
select * from fnd_folders -------
select * from fnd_user --------
select * from so_order_types_all ----------
select * from oe_order_headers_all ---------
select * from qa_customers_lov_v ---------
select * from qa_sales_orders_lov_v-----------
select * from PO_VENDORS ----------
select * from po_shipments_all_v 
select * from po_lines_val_v 
select * from po_pos_val_v 
select * from mtl_task_v 
select * from pjm_projects_all_v 
select * from qa_customers_lov_v ---
select * from mtl_item_revisions ----
select * from mtl_category_sets----
select * from wip_operations_all_v 
select * from wip_first_open_schedule_v 
select * from wip_discrete_jobs_all_v 
select * from wip_lines_val_v 
select * from mtl_item_uoms_view -----
select * from bom_resources_val_v 
select * from bom_departments_val_v 
select * from qa_plan_char_value_lookups ---------
select * from qa_plans-------
select * from qa_specs_v 
select * from qa_specs_val_v 
select * from po_lookup_codes -----
select * from hr_employees_current_v --------
select * from po_quality_codes 
select * from mtl_transaction_reasons ------
select * from mtl_uom_conversions_val_v ----
select * from mtl_uom_class_conversions ----
select * from hr_locations_all --------
select * from hr_locations_all_tl --------
select * from hz_locations -------
select * from hz_party_sites ---------
select * from hz_cust_site_uses_all --------
select * from hz_cust_acct_sites_all ---------
select * from hz_cust_accounts -----------
select * from oe_order_lines_all -----------
select * from oe_drop_ship_sources 
select * from rcv_trx_int_lots_v 
select * from mtl_rma_serial_temp 
select * from rcv_trx_int_serials_v 
select * from po_distributions 
select * from pjm_projects_all_v 
select * from po_distributions 
select * from hr_locations_all_tl-----------
select * from hr_employees_current_v -------
select * from po_lookup_codes -----------
select * from pjm_projects_all_v 
select * from pa_tasks_expend_v 
select * from mtl_kanban_cards 
select * from qa_plans_val_v ---------

---Lookup

select t.meaning from fnd_lookup_values_vl t Wheret.lookup_type='CUX_FC_QZYY'

-- Task ID
Select Distinct A.Task_Number,A.Task_Name

Frompa_tasks A