AP Payables Tolerance Listing (Oracle Fusion SQL)

Enterprise Resource Planning (ERP) Oracle Account Payables (AP-Fusion-SQL's)
1

This AP Payables Tolerance Listing query retrieves tolerance template details used in accounts payable, including threshold values for pricing, quantity, shipping, and rates, along with associated descriptions.

#sqlquery

SELECT
  --SQL4Fusion (An Orbit Analytics Project)
  --This query retrieves tolerance template details used in accounts payable
  ATT.TOLERANCE_NAME,
  ALC.DISPLAYED_FIELD TOLERANCE_TYPE,
  ALC.DESCRIPTION  TOLERANCE_DESCRIPTION,
  ATT.PRICE_TOLERANCE,
  ATT.QUANTITY_TOLERANCE,
  ATT.QTY_RECEIVED_TOLERANCE QUANTITY_RECEIVED_TOLERANCE,
  ATT.SHIP_AMT_TOLERANCE SHIPMENT_AMOUNT_VARIANCE,
  ATT.RATE_AMT_TOLERANCE  EXCHANGE_RATE_AMOUNT_VARIANCE,
  ATT.TOTAL_AMT_TOLERANCE TOTAL_AMOUNT_VARIANCE,
  ATT.CREATION_DATE,
  ATT.MAX_QTY_ORD_TOLERANCE MAXIMUM_ORDERED_VARIANCE,
  ATT.MAX_QTY_REC_TOLERANCE MAXIMUM_RECEIVED_VARIANCE
FROM
  AP_TOLERANCE_TEMPLATES ATT,
  AP_LOOKUP_CODES ALC
WHERE ATT.TOLERANCE_TYPE=ALC.LOOKUP_CODE
 AND ALC.LOOKUP_TYPE= 'TOLERANCE TYPE'