DBA Data[Home] [Help]

APPS.AR_AI_INTEG_PKG dependencies on STANDARD

Line 135: AND cp1.standard_terms = t_cp1.term_id(+)

131: AND cp2.cust_account_id = p_bill_to_customer_account_id
132: AND su.site_use_id = cp1.site_use_id(+)
133: AND cp2.site_use_id IS NULL
134: AND su.payment_term_id = t_su.term_id(+)
135: AND cp1.standard_terms = t_cp1.term_id(+)
136: AND cp2.standard_terms = t_cp2.term_id(+)
137: AND NVL( t_su.term_id, NVL( t_cp1.term_id, t_cp2.term_id)) = tl.term_id
138: AND su.site_use_id = l_site_use_id
139: AND su.org_id = p_org_id;

Line 136: AND cp2.standard_terms = t_cp2.term_id(+)

132: AND su.site_use_id = cp1.site_use_id(+)
133: AND cp2.site_use_id IS NULL
134: AND su.payment_term_id = t_su.term_id(+)
135: AND cp1.standard_terms = t_cp1.term_id(+)
136: AND cp2.standard_terms = t_cp2.term_id(+)
137: AND NVL( t_su.term_id, NVL( t_cp1.term_id, t_cp2.term_id)) = tl.term_id
138: AND su.site_use_id = l_site_use_id
139: AND su.org_id = p_org_id;
140: END IF;