DBA Data[Home] [Help]

APPS.ZX_AR_EXTRACT_PKG dependencies on FND_API

Line 5352: ' AND NVL(ARD.REF_ACCOUNT_CLASS(+),'''||FND_API.G_MISS_CHAR||''') <> ''TAX'' '||

5348: ' AND nvl(ARDTAX.CODE_COMBINATION_ID,ARD.CODE_COMBINATION_ID)
5349: = CC.CODE_COMBINATION_ID '||
5350: ' AND nvl(ARD.SOURCE_TYPE(+),''ADJ'') IN (''ADJ'',''FINCHRG'') '||
5351: ' AND ARD.SOURCE_TABLE(+) = ''ADJ'' '||
5352: ' AND NVL(ARD.REF_ACCOUNT_CLASS(+),'''||FND_API.G_MISS_CHAR||''') <> ''TAX'' '||
5353: ' AND ARDTAX.SOURCE_TABLE = ''ADJ'' '||
5354: ' AND NVL(DECODE(ADJ.TYPE,''TAX'',ARDTAX.TAX_LINK_ID,''INVOICE'',DECODE(LINE_ADJUSTED+FREIGHT_ADJUSTED,0,ARDTAX.TAX_LINK_ID,ARD.TAX_LINK_ID),ARD.TAX_LINK_ID),0) = NVL(ARDTAX.TAX_LINK_ID,0) '||
5355: ' AND ADJ.DOC_SEQUENCE_ID = SEQ.DOC_SEQUENCE_ID (+) '
5356: || L_WHERE_REPORTING_CONTEXT_ADJ