En çok kullanılan modüllerin türkçe, ingilizce ve kısa adları.

Kapatılacak Olan İş Emirlerinde Yapılması Gereken Kontroller. Beklemede ki kaynak işlemlerinde; Kapatılacak iş emirine ait beklemede veya hatada herhangi bir kaydın olmadığına emin olun.( WIP_COST_TXN_INTERFACE ) ( WIP:Kaynak İşlemleri >  Beklemedeki Kaynak İşlemleri) Beklemde ki hareket işlemlerinde; Kapatılacak iş emirine ait beklemede veya hatada herhangi bir kaydın olmadığına emin olun.( WIP_MOVE_TXN_INTERFACE ) (WIP:Hareket İşlemleri > Beklemedeki Hareket […]

Merhaba, Kalem kodunu inactive yapabilmek için aşağıdaki script’i kullanabilirsiniz.   DECLARE l_item_tbl_typ        ego_item_pub.item_tbl_type; x_item_table          ego_item_pub.item_tbl_type; x_inventory_item_id   mtl_system_items_b.inventory_item_id%TYPE; x_organization_id     mtl_system_items_b.organization_id%TYPE; x_return_status       VARCHAR2 (1); x_msg_count           NUMBER (10); x_msg_data            VARCHAR2 (1000); x_message_list        error_handler.error_tbl_type; BEGIN l_item_tbl_typ (1).transaction_type := ‘UPDATE’; l_item_tbl_typ (1).inventory_item_id := 209910; l_item_tbl_typ (1).organization_id := 443; –> Hangi organizasyondaki kalemi inactive yapmak istiyorsak organization_id ona göre yazılmalıdır! l_item_tbl_typ […]

CREATE OR REPLACE PROCEDURE APPS.xxxt_ap_bank_branches_cnv_prc ( ERRBUF OUT VARCHAR2, RETCODE OUT VARCHAR2 ) AS l_branch_id NUMBER := 0; CURSOR csr_bankbranches IS SELECT A.BANK_NAME, A.BRANCH_NAME bank_branch_name, A.BANK_NO bank_number, A.BRANCH_NO BANK_NUM, NULL bank_branch_type, ‘BANK’ institution_type, NULL END_DATE, NULL eft_user_number, NULL eft_swift_code, NULL edi_id_number, NULL ece_tp_location_code, NULL description, NULL from XXXT.XXXT_BANK_BRANCH_CODES A; BEGIN FOR v_bankbranch IN csr_bankbranches LOOP […]

select pv.vendor_name as vendor, to_date (rt.transaction_date, ‘DD-MM-YYYY’) as receipt_date, rt.subinventory as subinventory_code, (select organization_name from apps.org_organization_definitions where organization_id = rt.organization_id) as organization_name, rsh.receipt_num as receipt_number, rsh.attribute_category as attribute_category, rsl.quantity_received as quantity_received, rsl.item_description as item_description, pha.segment1 as po_number, plla.quantity as po_quantity, fu.description from po.rcv_transactions rt, po.rcv_shipment_headers rsh, po.rcv_shipment_lines rsl, po.po_vendors pv, po.po_headers_all pha, po.po_line_locations_all plla, po.po_lines_all […]

select variable_name, value from fnd_env_context where variable_name like ‘%\TOP’ escape ‘\’ and concurrent_process_id = ( select max(concurrent_process_id) from fnd_env_context ) order by 1;

SIRA NO Module Name 1 ABM – Activity Based Management 2 AD – Applications DBA 3 AHL – Oracle Advanced Service Online 4 AK – Oracle Common Modules-AK 5 ALR – Oracle Alert 6 AMF – Oracle Fulfillment Services 7 AMS – Oracle Marketing 8 AP – Oracle Payables 9 AR – Oracle Receivables 10 […]