DBA Data[Home] [Help]

APPS.JL_ZZ_AP_MONOTRIB_AWT_PKG dependencies on STANDARD

Line 46: AND ai.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT','CREDIT')

42: AND ai.invoice_id = ail.invoice_id
43: AND ail.line_number = aid.invoice_line_number
44: AND ai.invoice_date BETWEEN p_from_date AND p_to_date
45: AND ail.line_type_lookup_code NOT IN ('AWT','TAX')
46: AND ai.invoice_type_lookup_code IN ('STANDARD','PREPAYMENT','CREDIT')
47: AND ai.payment_status_flag IN ('N','P','Y')
48: AND ai.cancelled_date IS NULL
49: AND ai.legal_entity_id = p_legal_entity_id
50: GROUP BY ai.invoice_id, ai.invoice_date, ai.invoice_num, ai.payment_status_flag, ai.global_attribute13