BI APPPS ODI code logic

User_B544H

Hello All,

Good day..!!

I came across an OOTB code which is being used by ODI and trying to understand the logic it's being used. but not able to understand fully. Any help in this regard is really helpful to me.

ODI Code:

IIF((DOMAIN_MEMBER_MAP('AP_XACT_TYPE',SQ_AP_INVOICES_ALL.INVOICE_TYPE_LOOKUP_CODE,#DATASOURCE_NUM_ID,'W_LOOKUP_CODE_IS_SPEND'))='Y',

IIF((IIF(ISNULL(SQ_AP_INVOICES_ALL.PO_DISTRIBUTION_ID),'N','Y'))='Y', 'AP_INVOICE_SPEND_TYPE~PO MATCHED SPEND',

IIF((IIF((IIF(IsNull(SQ_AP_INVOICES_ALL.RECEIPT_REQUIRED_FLAG) AND IsNULL(SQ_AP_INVOICES_ALL.INSPECTION_REQUIRED_FLAG), 'N', 'Y'))='N', 'N', IIF(SQ_AP_INVOICES_ALL.PURCHASING_SITE_FLAG = 'Y', 'Y', 'N')))='Y',

'AP_INVOICE_SPEND_TYPE~PAYABLES LEAKAGE', 'AP_INVOICE_SPEND_TYPE~PO NOT REQUIRED SPEND')), NULL)||' ON '||(DOMAIN_MEMBER_MAP('AP_XACT_TYPE','INVDIST~'||SQ_AP_INVOICES_ALL.LINE_TYPE_LOOKUP_CODE,#DATASOURCE_NUM_ID,

'W_AP_SPEND_TYPE1'))

I'm looking for actual conditions the ODI logic is looking for. If any explains in bullet point would be highly appreciable. Thanks in  Advance.

Thanks,