PO Purchase Order Supplier Information (Oracle Fusion SQL)

Supply Chain & Manufacturing (SCM) Purchase Order (PO-Fusion-SQL's)
1

This PO Purchase Order Supplier Information query displays detailed supplier information for purchase orders as of today, helping users manage supplier relationships and procurement decisions.

#sqlquery

SELECT
  --SQL4Fusion (An Orbit Analytics Project)
  --PO supplier details as of today for supplier management.
  PSV.SEGMENT1                          SUPPLIER_NUMBER,  
  PSV.VENDOR_NAME                       SUPPLIER_NAME,
  PSV.VENDOR_TYPE_LOOKUP_CODE           SUPPLIER_TYPE,
  PSV.CUSTOMER_NUM                      CUSTOMER_NUMBER,
  PSV.TAX_REPORTING_NAME,
  PSV.TAX_VERIFICATION_DATE,
  PSV.TYPE_1099                         TAX_IDENTIFICATION_NUMBER,
  PSV.ONE_TIME_FLAG,
  -- Supplier Dates
  PSV.START_DATE_ACTIVE                 START_ACTIVE_DATE,
  PSV.END_DATE_ACTIVE                   END_ACTIVE_DATE,
  PSV.CREATION_DATE,
  PSV.CREATED_BY,
  -- Employee Details
  PU.USER_ID                            SUPPLIER_EMPLOYEE_NUMBER,
  PU.USERNAME                           SUPPLIER_EMPLOYEE_NAME
FROM
  POZ_SUPPLIERS_V        PSV,
  PER_USERS              PU,
  PER_ALL_PEOPLE_F       PAPF
WHERE
  PU.PERSON_ID = PAPF.PERSON_ID
  AND PSV.CREATED_BY = PU.USERNAME
  AND PAPF.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE)
  AND PAPF.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE);