APPS.AR_DEFERRAL_REASONS_GRP dependencies on RA_CUSTOMER_TRX_LINES

Line 144: FROM ra_customer_trx_lines pl

140: CURSOR parent_lines IS
141: SELECT pl.customer_trx_line_id, pl.customer_trx_id,
142: NVL(pl.autorule_complete_flag,'Y') autorule_complete_flag,
143: pl.accounting_rule_id
144: FROM ra_customer_trx_lines pl
145: WHERE interface_line_context = p_order_line.interface_line_context
146: AND interface_line_attribute1 = p_order_line.interface_line_attribute1
147: AND interface_line_attribute2 = p_order_line.interface_line_attribute2
148: AND interface_line_attribute3 = p_order_line.interface_line_attribute3

Line 158: FROM ra_customer_trx_lines pline,

154: SELECT child.customer_trx_line_id,
155: child.customer_trx_id,
156: NVL(cline.autorule_complete_flag,'Y') autorule_complete_flag,
157: cline.accounting_rule_id
158: FROM ra_customer_trx_lines pline,
159: ar_deferred_lines child,
160: ra_customer_trx_lines cline
161: WHERE pline.customer_trx_line_id = parent_trx_line_id
162: AND pline.interface_line_context = g_om_context

Line 160: ra_customer_trx_lines cline

156: NVL(cline.autorule_complete_flag,'Y') autorule_complete_flag,
157: cline.accounting_rule_id
158: FROM ra_customer_trx_lines pline,
159: ar_deferred_lines child,
160: ra_customer_trx_lines cline
161: WHERE pline.customer_trx_line_id = parent_trx_line_id
162: AND pline.interface_line_context = g_om_context
163: AND child.parent_line_id = to_number(pline.interface_line_attribute6)
164: AND child.customer_trx_id = cline.customer_trx_id

Line 406: FROM ra_customer_trx_lines

402: AND wda.delivery_id = p_delivery_id;
403:
404: CURSOR lines (p_order_line line_flex_rec) IS
405: SELECT customer_trx_line_id, customer_trx_id
406: FROM ra_customer_trx_lines
407: WHERE interface_line_context = p_order_line.interface_line_context
408: AND interface_line_attribute1 = p_order_line.interface_line_attribute1
409: AND interface_line_attribute1 = p_order_line.interface_line_attribute2
410: AND interface_line_attribute1 = p_order_line.interface_line_attribute3