Oracle EBS ERP Setup
Find out items received against the purchase order from the supplier. SELECT APS.VENDOR_NAME "SUPPLIER", ph.segment1 "PO NUM", MSI.DESCRIPTION, RCT.SOURCE_DOC_QUANTITY "RECIEVED", TO_NUMBER (QUANTITY_RECEIVED) " NET RECIEVED", rct.transaction_type, TRUNC (RCT.TRANSACTION_DATE) TRANSACTION_DATE FROM...
/ Posted by KapilAll the history of PO SELECT PHA.SEGMENT1 PO_NUM, PHA.REVISION_NUM, PLA.LINE_NUM PO_LINE_NUM, PLLA.SHIPMENT_NUM, PLA.ITEM_DESCRIPTION, PLA.UNIT_MEAS_LOOKUP_CODE, PLA.LIST_PRICE_PER_UNIT, PLA.CANCEL_FLAG, PLA.CANCEL_DATE, PLA.QUANTITY PO_LINE_QUANTITY, PHA.AUTHORIZATION_STATUS HEADER_APPROVAL_STATUS,PHA.APPROVED_FLAG HEADER_APPROVED_FLAG,PHA.APPROVED_DATE HEADER_APPROVED_DATE, PHA.CLOSED_CODE HEADER_CLOSURE_STATUS, PLA.CLOSED_CODE LINE_CLOSURE_STATUS, PLLA.CLOSED_CODE SHIPMENT_CLORSURE_STATUS, PLLA.APPROVED_FLAG...
/ Posted by KapilCheck the approval status of purchase order SELECT poh.segment1 "PO NUM", poh.authorization_status "STATUS", pla.line_num "SEQ NUM", plla.line_location_id, d.po_distribution_id, poh.type_lookup_code "TYPE" FROM po.po_headers_all poh, po.po_lines_all pla, po.po_line_locations_all plla, po.po_distributions_all d WHERE...
/ Posted by KapilFind out application base path which is useful to find out the file on application server. SELECT fa.application_id "Application ID", fat.application_name "Application Name", fa.application_short_name "Application Short Name", fa.basepath "Basepath" FROM...
/ Posted by KapilPayroll details of employees with all the attributes. SELECT TO_NUMBER (pap.employee_number) employee_number, INITCAP (pap.title) || ' ' || (pap.full_name) full_name, NVL (pet.attribute1, pet.element_name) Description, SUM(DECODE (pec.classification_name, 'Earnings', result_value, 'Deductions', result_value...
/ Posted by KapilGet the details about the loan of employees. Change the effective date as required. SELECT DISTINCT papf.EMPLOYEE_NUMBER, papf.full_name, pbv.balance_name Loan_Detail, MAX (pbv.VALUE) Loan_Remaining_Amount, hou.name Department_Name FROM per_all_people_f papf, per_all_assignments_f paaf,...
/ Posted by KapilList of employee with all the details like Name, Gender, Nationality, Department, Hire date & Address. /* Formatted on 8/21/2021 9:28:51 PM (QP5 v5.136.908.31019) */ SELECT papf.employee_number "Employee Number", papf.title...
/ Posted by KapilBank details of employees with bank name and account. SELECT DISTINCT a.employee_number, a.full_name employee_name, TRIM (d.segment1) bank_name, TRIM (d.segment2) bank_name_arabic, TRIM (d.segment6) IBAN FROM per_all_people_f a, per_all_assignments_f b, pay_personal_payment_methods_f c,...
/ Posted by Kapil