APPS.ARP_DET_DIST_PKG dependencies on AR_LINE_DIST_INTERFACE_GT

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

3896: ,SUM(NVL(ed_tax_amount,0)) OVER (PARTITION BY gt_id, customer_trx_id, line_type) sum_ed_tax_amount
3897: ,SUM(NVL(uned_line_amount,0)) OVER (PARTITION BY gt_id, customer_trx_id, line_type) sum_uned_line_amount
3898: ,SUM(NVL(uned_tax_amount,0)) OVER (PARTITION BY gt_id, customer_trx_id, line_type) sum_uned_tax_amount
3899: FROM
3900: (SELECT /*+INDEX (ar_line_dist_interface_gt ar_line_dist_interface_gt_n1)*/
3901: gt_id gt_id
3902: ,customer_trx_id customer_trx_id
3903: ,customer_trx_line_id customer_trx_line_id
3904: ,line_type line_type

Line 3911: FROM ar_line_dist_interface_gt

3907: ,SUM(NVL(ed_line_amount,0)) ed_line_amount
3908: ,SUM(NVL(ed_tax_amount,0)) ed_tax_amount
3909: ,SUM(NVL(uned_line_amount,0)) uned_line_amount
3910: ,SUM(NVL(uned_tax_amount,0)) uned_tax_amount
3911: FROM ar_line_dist_interface_gt
3912: WHERE gt_id = p_gt_id
3913: AND customer_trx_id = p_customer_trx_id
3914: GROUP BY gt_id, customer_trx_id, customer_trx_line_id, line_type)) it
3915: WHERE trx.customer_trx_id = p_customer_trx_id