DBA Data[Home] [Help]

APPS.ARP_ALLOCATION_PKG dependencies on AR_LINE_APP_DETAIL_GT

Line 1411: ar_line_app_detail_gt det

1407: det.ref_mf_dist_flag
1408: FROM ra_customer_trx_lines ctl,
1409: ra_cust_trx_line_gl_dist gld,
1410: ra_customer_trx_lines line,
1411: ar_line_app_detail_gt det
1412: where ctl.customer_trx_id = p_invoice_id
1413: and ctl.line_type = 'TAX'
1414: and gld.customer_trx_line_id = ctl.customer_trx_line_id
1415: and gld.account_set_flag = 'N'

Line 1576: FROM ar_line_app_detail_gt det

1572: det.from_amount ae_from_pro_amt,
1573: det.from_acctd_amount ae_from_pro_acctd_amt,
1574: det.ccid ref_dist_ccid,
1575: det.ref_mf_dist_flag ref_mf_dist_flag
1576: FROM ar_line_app_detail_gt det
1577: WHERE det.ref_customer_trx_id = p_invoice_id
1578: AND gt_id = g_id
1579: AND det.ledger_id = g_ae_sys_rec.set_of_books_id
1580: AND ref_customer_trx_line_id IN (-8);

Line 1854: ar_line_app_detail_gt det,

1850: det.ref_mf_dist_flag ref_mf_dist_flag
1851: --}
1852: from ra_customer_trx_lines ctl,
1853: ra_cust_trx_line_gl_dist gld,
1854: ar_line_app_detail_gt det,
1855: (select b4.ae_link_to_cust_trx_line_id ae_link_to_cust_trx_line_id,
1856: max(decode(g_ae_rule_rec.gl_account_source1,
1857: 'TAX_CODE_ON_INVOICE',
1858: decode(g_ae_doc_rec.source_table,

Line 2114: FROM ar_line_app_detail_gt det

2110: det.from_amount ae_from_pro_amt,
2111: det.from_acctd_amount ae_from_pro_acctd_amt,
2112: det.ccid ref_dist_ccid,
2113: det.ref_mf_dist_flag ref_mf_dist_flag
2114: FROM ar_line_app_detail_gt det
2115: WHERE det.ref_customer_trx_id = p_invoice_id
2116: AND det.ledger_id = g_ae_sys_rec.set_of_books_id
2117: AND gt_id = g_id
2118: AND ref_customer_trx_line_id IN (-6,-7,-9);