AR Standard Memo Lines (Oracle Fusion SQL)

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

This AR Standard Memo Lines query retrieves details of standard memo lines used in customer invoicing, including memo name, type, description, effective dates, tax code, unit of measure, standard price, associated invoicing and accounting rules.

#sqlquery

SELECT
 --SQL4Fusion (An Orbit Analytics Project)
 --This query retrieves details of standard memo lines used in customer invoicing
  AMLAB.NAME MEMO_NAME,
  AL.MEANING MEMO_LINE_TYPE,
  AMLAB.DESCRIPTION MEMO_LINE_DESCRIPTION,
  AMLAB.EFFECTIVE_START_DATE MEMO_LINE_START_DATE,
  AMLAB.EFFECTIVE_END_DATE MEMO_LINE_END_DATE,  
  AMLAB.TAX_CODE,
  IUOMT.UNIT_OF_MEASURE,
  AMLAB.UNIT_STD_PRICE UNIT_STANDARD_PRICE,
  --GCC.SEGMENT1 || '-' || GCC.SEGMENT2 || '-' || GCC.SEGMENT3 || '-' || GCC.SEGMENT4 || '-' || GCC.SEGMENT5 ACCOUNT,
  RR.NAME INVOICING_RULE,
  RR2.NAME ACCOUNTING_RULE
  --AMLAB.MEMO_LINE_SEQ_ID ORGANIZATION_ID,
  --GCC.ACCOUNT_TYPE
FROM
  AR_MEMO_LINES_ALL_B AMLAB,
  INV_UNITS_OF_MEASURE_TL IUOMT,
  --GL_CODE_COMBINATIONS GCC,
  RA_RULES RR,
  RA_RULES RR2,
  AR_LOOKUPS AL
WHERE
  1 = 1
  AND AMLAB.LINE_TYPE = AL.LOOKUP_CODE
  AND AL.LOOKUP_TYPE = 'STD_LINE_TYPE'
  AND AMLAB.UOM_CODE = IUOMT.UNIT_OF_MEASURE(+)
  AND AMLAB.INVOICING_RULE_ID = RR.RULE_ID(+)
  AND AMLAB.ACCOUNTING_RULE_ID = RR2.RULE_ID(+)