APPS.ARP_DET_DIST_PKG dependencies on AR_LINE_DIST_INTERFACE_GT

Line 3187: (SELECT /*+INDEX (ar_line_dist_interface_gt ar_line_dist_interface_gt_n1)*/

3183: ,CASE WHEN g_uned_tax_flag = 'INTERFACE' THEN it.sum_uned_tax_amount ELSE NULL END -- SUM_INT_UNED_TAX_AMOUNT
3184: --}
3185: FROM ra_customer_trx trx,
3186: ra_customer_trx_lines_gt ctl,
3187: (SELECT /*+INDEX (ar_line_dist_interface_gt ar_line_dist_interface_gt_n1)*/
3188: gt_id gt_id
3189: ,customer_trx_id customer_trx_id
3190: ,customer_trx_line_id customer_trx_line_id
3191: ,line_type line_type

Line 3204: FROM ar_line_dist_interface_gt

3200: ,SUM(NVL(ed_line_amount,0)) OVER (PARTITION BY gt_id, customer_trx_id) sum_ed_line_amount
3201: ,SUM(NVL(ed_tax_amount,0)) OVER (PARTITION BY gt_id, customer_trx_id) sum_ed_tax_amount
3202: ,SUM(NVL(uned_line_amount,0)) OVER (PARTITION BY gt_id, customer_trx_id) sum_uned_line_amount
3203: ,SUM(NVL(uned_tax_amount,0)) OVER (PARTITION BY gt_id, customer_trx_id) sum_uned_tax_amount
3204: FROM ar_line_dist_interface_gt
3205: WHERE gt_id = p_gt_id
3206: AND customer_trx_id = p_customer_trx_id ) it
3207: WHERE trx.customer_trx_id = p_customer_trx_id
3208: AND trx.customer_trx_id = ctl.customer_trx_id