AP Distribution Set Listing (Oracle Fusion SQL)

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

This AP Distribution Set Listing Report query provides details of AP distribution sets and their line-level account distributions, including organization, status, account combinations.

#sqlquery

SELECT
  -- SQL4Fusion (An Orbit Analytics Project) 
  -- This query retrieves detailed information about AP (Accounts Payables) Distribution Sets and their associated distribution lines.
  ADSA.DISTRIBUTION_SET_NAME,
  ADSA.DESCRIPTION DISTRIBUTION_DESCRIPTION,
  HAOU.NAME ORGANIZATION_NAME,
  ADSA.CREATION_DATE EFFECTIVE_DATE,
  ADSA.INACTIVE_DATE,
  DECODE (
    ADSA.INACTIVE_DATE,
    NULL,
    'Active',
    'Inactive'
  ) STATUS,
  DISTRIBUTION_SET_LINE_NUMBER,
  ADSLA.DESCRIPTION ACCOUNT_DESCRIPTION,
  ADSLA.DISTRIBUTION_SET_ID,
  ADSA.ORG_ID,
  FND_FLEX_EXT.GET_SEGS(
   'GL',
   'GL#',
   GCC.CHART_OF_ACCOUNTS_ID,
   GCC.CODE_COMBINATION_ID
 ) DISTRIBUTION_ACCOUNT,
 ADSLA.PERCENT_DISTRIBUTION,
 ADSLA.TYPE_1099 
FROM
  AP_DISTRIBUTION_SETS_ALL ADSA,
  AP_DISTRIBUTION_SET_LINES_ALL ADSLA,
  GL_CODE_COMBINATIONS GCC,
  HR_ALL_ORGANIZATION_UNITS HAOU
WHERE
  1 = 1
  AND ADSA.DISTRIBUTION_SET_ID = ADSLA.DISTRIBUTION_SET_ID
  AND GCC.CODE_COMBINATION_ID = ADSLA.DIST_CODE_COMBINATION_ID
  AND HAOU.ORGANIZATION_ID = ADSA.ORG_ID