AR Invoice Line Ordering Rules (Oracle Fusion SQL)

Enterprise Resource Planning (ERP) Oracle Account Receivables (AR-Fusion-SQL's)
1

This AR Invoice Ordering Rules query retrieves line ordering rule definitions from Oracle Receivables. These rules determine how invoice or transaction lines are sorted during processing (e.g., for printing or interfacing).

#sqlquery

SELECT
  --SQL4Fusion (An Orbit Analytics Project)
  --This query retrieves line ordering rule definitions from Oracle Receivables
  RLOR.NAME RULE_NAME,
  RLOR.DESCRIPTION RULE_DESCRIPTION,
  RLOR.START_DATE RULE_START_DATE,
  RLOR.END_DATE RULE_END_DATE,
  RLOB.ORDER_BY_SEQUENCE SEQUENCE_ORDER,
  RLOBC.DESCRIPTION TRANSACTION_ATTRIBUTE,
  AL.MEANING TYPE,
  --RLOBC.COLUMN_ID,
  RLOR.ORDERING_RULE_ID
FROM
  RA_LINE_ORDERING_RULES RLOR,
  RA_LINE_ORDER_BYS RLOB,
  RA_LINE_ORDER_BY_COLUMNS RLOBC,
  AR_LOOKUPS AL
WHERE
  1 = 1
  AND RLOR.ORDERING_RULE_ID = RLOB.ORDERING_RULE_ID(+)
  AND RLOB.COLUMN_ID = RLOBC.COLUMN_ID
  AND RLOB.ORDER_BY_TYPE = AL.LOOKUP_CODE
  AND AL.LOOKUP_TYPE = 'ORDER_BY_TYPE'
ORDER BY
  RLOR.NAME,
  RLOBC.DESCRIPTION