eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AP_STND_TAX_PROCESS dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 75: , Ap_Invoice_Distributions_All aida

71: SELECT
72: aila.line_number
73: FROM
74: AP_INVOICE_LINES_ALL aila
75: , Ap_Invoice_Distributions_All aida
76: WHERE aila.INVOICE_ID = aida.invoice_id (+) --rollback to original logic
77: AND aila.line_number = aida.invoice_line_number (+) --rollback to original logic
78: AND aila.invoice_id = pn_invoice_id
79: --AND aila.line_number = pn_line_number -- Added by Jia Li for inclusive tax on 2008/01/25

Line 309: INSERT INTO AP_INVOICE_DISTRIBUTIONS_ALL

305: END IF;
306:
307: FOR i IN (pn_tax_allocation_number+1) .. pn_item_allocation_number
308: LOOP
309: INSERT INTO AP_INVOICE_DISTRIBUTIONS_ALL
310: ( accounting_date
311: , accrual_posted_flag
312: , assets_addition_flag
313: , assets_tracking_flag

Line 799: ap_invoice_distributions_all

795: , xinv_parent_reversal_id
796: , recurring_payment_id
797: , release_inv_dist_derived_from
798: FROM
799: ap_invoice_distributions_all
800: WHERE invoice_id = pn_invoice_id
801: AND invoice_line_number = pn_invoice_line_number
802: AND line_type_lookup_code = GV_CONSTANT_MISCELLANEOUS
803: AND distribution_line_number = 1;

Line 880: ap_invoice_distributions_all

876: END IF;
877:
878: DELETE
879: FROM
880: ap_invoice_distributions_all
881: WHERE invoice_id = pn_invoice_id
882: AND invoice_line_number = pn_invoice_line_number
883: AND line_type_lookup_code = GV_CONSTANT_MISCELLANEOUS
884: AND distribution_line_number > pn_item_allocation_number;

Line 978: ap_invoice_distributions_all

974: , pa_addition_flag
975: , ASSET_BOOK_TYPE_CODE
976: , ASSET_CATEGORY_ID
977: FROM
978: ap_invoice_distributions_all
979: WHERE invoice_id = ln_invoice_id
980: AND invoice_line_number = pn_invoice_item_ln_number;
981:
982: CURSOR tax_line_cur (pn_invoice_item_ln_number NUMBER)

Line 1009: ap_invoice_distributions_all

1005: IS
1006: SELECT
1007: COUNT(1)
1008: FROM
1009: ap_invoice_distributions_all
1010: WHERE invoice_id = ln_invoice_id
1011: AND invoice_line_number = pn_invoice_line_number;
1012:
1013: CURSOR get_dist_total_amount_cur

Line 1022: ap_invoice_distributions_all

1018: SELECT
1019: SUM( amount )
1020: , SUM( base_amount )
1021: FROM
1022: ap_invoice_distributions_all
1023: WHERE invoice_id = ln_invoice_id
1024: AND invoice_line_number = pn_invoice_line_number
1025: AND distribution_line_number < pn_dist_line_number;
1026:

Line 1151: ap_invoice_distributions_all

1147:
1148: --allocation tax amount according to the proportion
1149: --of item dist lines
1150: UPDATE
1151: ap_invoice_distributions_all
1152: SET
1153: amount =tax_line_rec.line_amount * ln_allocation_factor
1154: /*
1155: ROUND( tax_line_rec.line_amount *

Line 1193: ap_invoice_distributions_all

1189: , ln_dist_total_base_amount;
1190: CLOSE get_dist_total_amount_cur;
1191:
1192: UPDATE
1193: ap_invoice_distributions_all
1194: SET
1195: amount =
1196: tax_line_rec.line_amount - ln_dist_total_amount
1197: , base_amount =

Line 1220: ap_invoice_distributions_all

1216: --As only one item distribution line,tax lines are not
1217: --required to be allocated.
1218:
1219: UPDATE
1220: ap_invoice_distributions_all
1221: SET
1222: amount = tax_line_rec.line_amount
1223: , base_amount = tax_line_rec.base_amount
1224: , assets_tracking_flag = item_dist_line_rec.assets_tracking_flag

Line 1397: ap_invoice_distributions_all

1393: CURSOR item_dist_account_cur IS
1394: SELECT
1395: dist_code_combination_id
1396: FROM
1397: ap_invoice_distributions_all
1398: WHERE invoice_id = pn_invoice_id
1399: AND invoice_line_number = pn_item_line_number
1400: AND distribution_line_number =1;
1401:

Line 2294: --invoice will be deleted from ap_invoice_distributions_all

2290: END IF;--( ln_proc_level >= ln_dbg_level)
2291:
2292: --Delete all exclusive taxes lines for the specified invoice id and item line
2293: --number. If invoice line number is null, all exclusive tax lines for the
2294: --invoice will be deleted from ap_invoice_distributions_all
2295: DELETE
2296: FROM
2297: ap_invoice_distributions_all aida
2298: WHERE aida.invoice_id = ln_invoice_id

Line 2297: ap_invoice_distributions_all aida

2293: --number. If invoice line number is null, all exclusive tax lines for the
2294: --invoice will be deleted from ap_invoice_distributions_all
2295: DELETE
2296: FROM
2297: ap_invoice_distributions_all aida
2298: WHERE aida.invoice_id = ln_invoice_id
2299: AND EXISTS
2300: (
2301: SELECT

Line 2316: || '.Delete from ap_invoice_distributions_all'

2312: IF ( ln_proc_level >= ln_dbg_level)
2313: THEN
2314: FND_LOG.STRING( ln_proc_level
2315: , GV_MODULE_PREFIX ||'.'|| lv_proc_name
2316: || '.Delete from ap_invoice_distributions_all'
2317: , SQL%ROWCOUNT||' ROWS DELETED '
2318: );
2319: END IF;
2320:

Line 2453: -- delete miscellaneous from ap_invoice_distributions_all

2449: );
2450: */
2451:
2452:
2453: -- delete miscellaneous from ap_invoice_distributions_all
2454: DELETE
2455: FROM
2456: ap_invoice_distributions_all aida
2457: WHERE aida.invoice_id = ln_invoice_id

Line 2456: ap_invoice_distributions_all aida

2452:
2453: -- delete miscellaneous from ap_invoice_distributions_all
2454: DELETE
2455: FROM
2456: ap_invoice_distributions_all aida
2457: WHERE aida.invoice_id = ln_invoice_id
2458: AND EXISTS
2459: (
2460: SELECT

Line 3980: ap_invoice_distributions_all

3976: , distribution_class
3977: , ASSET_BOOK_TYPE_CODE
3978: , ASSET_CATEGORY_ID
3979: FROM
3980: ap_invoice_distributions_all
3981: WHERE invoice_id = ln_invoice_id
3982: AND invoice_line_number = pn_line_number
3983: AND distribution_line_number = 1;
3984:

Line 4069: ap_invoice_distributions_all.assets_addition_flag%TYPE;

4065: ln_exp_org_id ap_invoice_lines_all.expenditure_organization_id%TYPE;
4066: ld_sys_date DATE; --Eric added on 18-Feb-2008,for bug#6824857
4067:
4068: ln_dist_asst_add_flag
4069: ap_invoice_distributions_all.assets_addition_flag%TYPE;
4070: ln_dist_asst_trck_flag
4071: ap_invoice_distributions_all.assets_tracking_flag%TYPE;
4072: ln_dist_project_id
4073: ap_invoice_distributions_all.project_id%TYPE;

Line 4071: ap_invoice_distributions_all.assets_tracking_flag%TYPE;

4067:
4068: ln_dist_asst_add_flag
4069: ap_invoice_distributions_all.assets_addition_flag%TYPE;
4070: ln_dist_asst_trck_flag
4071: ap_invoice_distributions_all.assets_tracking_flag%TYPE;
4072: ln_dist_project_id
4073: ap_invoice_distributions_all.project_id%TYPE;
4074: ln_dist_task_id
4075: ap_invoice_distributions_all.task_id%TYPE;

Line 4073: ap_invoice_distributions_all.project_id%TYPE;

4069: ap_invoice_distributions_all.assets_addition_flag%TYPE;
4070: ln_dist_asst_trck_flag
4071: ap_invoice_distributions_all.assets_tracking_flag%TYPE;
4072: ln_dist_project_id
4073: ap_invoice_distributions_all.project_id%TYPE;
4074: ln_dist_task_id
4075: ap_invoice_distributions_all.task_id%TYPE;
4076: ln_dist_exp_type
4077: ap_invoice_distributions_all.expenditure_type%TYPE;

Line 4075: ap_invoice_distributions_all.task_id%TYPE;

4071: ap_invoice_distributions_all.assets_tracking_flag%TYPE;
4072: ln_dist_project_id
4073: ap_invoice_distributions_all.project_id%TYPE;
4074: ln_dist_task_id
4075: ap_invoice_distributions_all.task_id%TYPE;
4076: ln_dist_exp_type
4077: ap_invoice_distributions_all.expenditure_type%TYPE;
4078: ld_dist_exp_item_date
4079: ap_invoice_distributions_all.expenditure_item_date%TYPE;

Line 4077: ap_invoice_distributions_all.expenditure_type%TYPE;

4073: ap_invoice_distributions_all.project_id%TYPE;
4074: ln_dist_task_id
4075: ap_invoice_distributions_all.task_id%TYPE;
4076: ln_dist_exp_type
4077: ap_invoice_distributions_all.expenditure_type%TYPE;
4078: ld_dist_exp_item_date
4079: ap_invoice_distributions_all.expenditure_item_date%TYPE;
4080: ln_dist_exp_org_id
4081: ap_invoice_distributions_all.expenditure_organization_id%TYPE;

Line 4079: ap_invoice_distributions_all.expenditure_item_date%TYPE;

4075: ap_invoice_distributions_all.task_id%TYPE;
4076: ln_dist_exp_type
4077: ap_invoice_distributions_all.expenditure_type%TYPE;
4078: ld_dist_exp_item_date
4079: ap_invoice_distributions_all.expenditure_item_date%TYPE;
4080: ln_dist_exp_org_id
4081: ap_invoice_distributions_all.expenditure_organization_id%TYPE;
4082: ln_dist_pa_context
4083: ap_invoice_distributions_all.project_accounting_context%TYPE;

Line 4081: ap_invoice_distributions_all.expenditure_organization_id%TYPE;

4077: ap_invoice_distributions_all.expenditure_type%TYPE;
4078: ld_dist_exp_item_date
4079: ap_invoice_distributions_all.expenditure_item_date%TYPE;
4080: ln_dist_exp_org_id
4081: ap_invoice_distributions_all.expenditure_organization_id%TYPE;
4082: ln_dist_pa_context
4083: ap_invoice_distributions_all.project_accounting_context%TYPE;
4084: ln_dist_pa_addition_flag
4085: ap_invoice_distributions_all.pa_addition_flag%TYPE;

Line 4083: ap_invoice_distributions_all.project_accounting_context%TYPE;

4079: ap_invoice_distributions_all.expenditure_item_date%TYPE;
4080: ln_dist_exp_org_id
4081: ap_invoice_distributions_all.expenditure_organization_id%TYPE;
4082: ln_dist_pa_context
4083: ap_invoice_distributions_all.project_accounting_context%TYPE;
4084: ln_dist_pa_addition_flag
4085: ap_invoice_distributions_all.pa_addition_flag%TYPE;
4086: lv_asset_book_type_code
4087: ap_invoice_distributions_all.asset_book_type_code%TYPE;

Line 4085: ap_invoice_distributions_all.pa_addition_flag%TYPE;

4081: ap_invoice_distributions_all.expenditure_organization_id%TYPE;
4082: ln_dist_pa_context
4083: ap_invoice_distributions_all.project_accounting_context%TYPE;
4084: ln_dist_pa_addition_flag
4085: ap_invoice_distributions_all.pa_addition_flag%TYPE;
4086: lv_asset_book_type_code
4087: ap_invoice_distributions_all.asset_book_type_code%TYPE;
4088: ln_asset_category_id
4089: ap_invoice_distributions_all.asset_category_id%TYPE;

Line 4087: ap_invoice_distributions_all.asset_book_type_code%TYPE;

4083: ap_invoice_distributions_all.project_accounting_context%TYPE;
4084: ln_dist_pa_addition_flag
4085: ap_invoice_distributions_all.pa_addition_flag%TYPE;
4086: lv_asset_book_type_code
4087: ap_invoice_distributions_all.asset_book_type_code%TYPE;
4088: ln_asset_category_id
4089: ap_invoice_distributions_all.asset_category_id%TYPE;
4090: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
4091: ln_proc_level NUMBER := FND_LOG.level_procedure;

Line 4089: ap_invoice_distributions_all.asset_category_id%TYPE;

4085: ap_invoice_distributions_all.pa_addition_flag%TYPE;
4086: lv_asset_book_type_code
4087: ap_invoice_distributions_all.asset_book_type_code%TYPE;
4088: ln_asset_category_id
4089: ap_invoice_distributions_all.asset_category_id%TYPE;
4090: ln_dbg_level NUMBER := FND_LOG.g_current_runtime_level;
4091: ln_proc_level NUMBER := FND_LOG.level_procedure;
4092: lv_proc_name VARCHAR2 (100):= 'Create_Tax_Lines';
4093: ln_user_id NUMBER := fnd_global.user_id;

Line 4281: 'INSERT INTO ap_invoice_distributions_all

4277: , :27
4278: )';
4279:
4280: lv_insert_ap_inv_dist_ln_sql :=
4281: 'INSERT INTO ap_invoice_distributions_all
4282: ( accounting_date
4283: , accrual_posted_flag
4284: , assets_addition_flag
4285: , assets_tracking_flag