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.AP_ETAX_UTILITY_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 28: -- This record type is used for ap_invoice_distributions_all and ap_self_assessed_tax_dist_all

24: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
25: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
26: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'AP.PLSQL.AP_ETAX_UTILITY_PKG.';
27:
28: -- This record type is used for ap_invoice_distributions_all and ap_self_assessed_tax_dist_all
29:
30: TYPE r_ins_tax_dist_info IS RECORD (
31: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
32: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,

Line 31: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,

27:
28: -- This record type is used for ap_invoice_distributions_all and ap_self_assessed_tax_dist_all
29:
30: TYPE r_ins_tax_dist_info IS RECORD (
31: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
32: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
33: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
34: period_name ap_invoice_distributions_all.period_name%TYPE,
35: amount ap_invoice_distributions_all.amount%TYPE,

Line 32: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,

28: -- This record type is used for ap_invoice_distributions_all and ap_self_assessed_tax_dist_all
29:
30: TYPE r_ins_tax_dist_info IS RECORD (
31: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
32: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
33: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
34: period_name ap_invoice_distributions_all.period_name%TYPE,
35: amount ap_invoice_distributions_all.amount%TYPE,
36: base_amount ap_invoice_distributions_all.base_amount%TYPE,

Line 33: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,

29:
30: TYPE r_ins_tax_dist_info IS RECORD (
31: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
32: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
33: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
34: period_name ap_invoice_distributions_all.period_name%TYPE,
35: amount ap_invoice_distributions_all.amount%TYPE,
36: base_amount ap_invoice_distributions_all.base_amount%TYPE,
37: description ap_invoice_distributions_all.description%TYPE,

Line 34: period_name ap_invoice_distributions_all.period_name%TYPE,

30: TYPE r_ins_tax_dist_info IS RECORD (
31: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
32: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
33: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
34: period_name ap_invoice_distributions_all.period_name%TYPE,
35: amount ap_invoice_distributions_all.amount%TYPE,
36: base_amount ap_invoice_distributions_all.base_amount%TYPE,
37: description ap_invoice_distributions_all.description%TYPE,
38: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,

Line 35: amount ap_invoice_distributions_all.amount%TYPE,

31: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
32: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
33: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
34: period_name ap_invoice_distributions_all.period_name%TYPE,
35: amount ap_invoice_distributions_all.amount%TYPE,
36: base_amount ap_invoice_distributions_all.base_amount%TYPE,
37: description ap_invoice_distributions_all.description%TYPE,
38: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
39: po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE,

Line 36: base_amount ap_invoice_distributions_all.base_amount%TYPE,

32: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
33: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
34: period_name ap_invoice_distributions_all.period_name%TYPE,
35: amount ap_invoice_distributions_all.amount%TYPE,
36: base_amount ap_invoice_distributions_all.base_amount%TYPE,
37: description ap_invoice_distributions_all.description%TYPE,
38: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
39: po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE,
40: type_1099 ap_invoice_distributions_all.type_1099%TYPE,

Line 37: description ap_invoice_distributions_all.description%TYPE,

33: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
34: period_name ap_invoice_distributions_all.period_name%TYPE,
35: amount ap_invoice_distributions_all.amount%TYPE,
36: base_amount ap_invoice_distributions_all.base_amount%TYPE,
37: description ap_invoice_distributions_all.description%TYPE,
38: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
39: po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE,
40: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
41: attribute1 ap_invoice_distributions_all.attribute1%TYPE,

Line 38: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,

34: period_name ap_invoice_distributions_all.period_name%TYPE,
35: amount ap_invoice_distributions_all.amount%TYPE,
36: base_amount ap_invoice_distributions_all.base_amount%TYPE,
37: description ap_invoice_distributions_all.description%TYPE,
38: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
39: po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE,
40: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
41: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
42: attribute10 ap_invoice_distributions_all.attribute10%TYPE,

Line 39: po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE,

35: amount ap_invoice_distributions_all.amount%TYPE,
36: base_amount ap_invoice_distributions_all.base_amount%TYPE,
37: description ap_invoice_distributions_all.description%TYPE,
38: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
39: po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE,
40: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
41: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
42: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
43: attribute11 ap_invoice_distributions_all.attribute11%TYPE,

Line 40: type_1099 ap_invoice_distributions_all.type_1099%TYPE,

36: base_amount ap_invoice_distributions_all.base_amount%TYPE,
37: description ap_invoice_distributions_all.description%TYPE,
38: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
39: po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE,
40: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
41: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
42: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
43: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
44: attribute12 ap_invoice_distributions_all.attribute12%TYPE,

Line 41: attribute1 ap_invoice_distributions_all.attribute1%TYPE,

37: description ap_invoice_distributions_all.description%TYPE,
38: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
39: po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE,
40: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
41: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
42: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
43: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
44: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
45: attribute13 ap_invoice_distributions_all.attribute13%TYPE,

Line 42: attribute10 ap_invoice_distributions_all.attribute10%TYPE,

38: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
39: po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE,
40: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
41: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
42: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
43: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
44: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
45: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
46: attribute14 ap_invoice_distributions_all.attribute14%TYPE,

Line 43: attribute11 ap_invoice_distributions_all.attribute11%TYPE,

39: po_distribution_id ap_invoice_distributions_all.po_distribution_id%TYPE,
40: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
41: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
42: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
43: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
44: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
45: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
46: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
47: attribute15 ap_invoice_distributions_all.attribute15%TYPE,

Line 44: attribute12 ap_invoice_distributions_all.attribute12%TYPE,

40: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
41: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
42: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
43: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
44: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
45: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
46: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
47: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
48: attribute2 ap_invoice_distributions_all.attribute2%TYPE,

Line 45: attribute13 ap_invoice_distributions_all.attribute13%TYPE,

41: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
42: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
43: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
44: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
45: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
46: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
47: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
48: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
49: attribute3 ap_invoice_distributions_all.attribute3%TYPE,

Line 46: attribute14 ap_invoice_distributions_all.attribute14%TYPE,

42: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
43: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
44: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
45: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
46: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
47: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
48: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
49: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
50: attribute4 ap_invoice_distributions_all.attribute4%TYPE,

Line 47: attribute15 ap_invoice_distributions_all.attribute15%TYPE,

43: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
44: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
45: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
46: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
47: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
48: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
49: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
50: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
51: attribute5 ap_invoice_distributions_all.attribute5%TYPE,

Line 48: attribute2 ap_invoice_distributions_all.attribute2%TYPE,

44: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
45: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
46: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
47: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
48: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
49: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
50: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
51: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
52: attribute6 ap_invoice_distributions_all.attribute6%TYPE,

Line 49: attribute3 ap_invoice_distributions_all.attribute3%TYPE,

45: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
46: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
47: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
48: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
49: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
50: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
51: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
52: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
53: attribute7 ap_invoice_distributions_all.attribute7%TYPE,

Line 50: attribute4 ap_invoice_distributions_all.attribute4%TYPE,

46: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
47: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
48: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
49: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
50: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
51: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
52: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
53: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
54: attribute8 ap_invoice_distributions_all.attribute8%TYPE,

Line 51: attribute5 ap_invoice_distributions_all.attribute5%TYPE,

47: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
48: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
49: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
50: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
51: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
52: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
53: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
54: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
55: attribute9 ap_invoice_distributions_all.attribute9%TYPE,

Line 52: attribute6 ap_invoice_distributions_all.attribute6%TYPE,

48: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
49: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
50: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
51: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
52: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
53: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
54: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
55: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
56: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,

Line 53: attribute7 ap_invoice_distributions_all.attribute7%TYPE,

49: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
50: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
51: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
52: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
53: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
54: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
55: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
56: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
57: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,

Line 54: attribute8 ap_invoice_distributions_all.attribute8%TYPE,

50: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
51: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
52: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
53: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
54: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
55: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
56: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
57: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
58: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,

Line 55: attribute9 ap_invoice_distributions_all.attribute9%TYPE,

51: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
52: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
53: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
54: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
55: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
56: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
57: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
58: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
59: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,

Line 56: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,

52: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
53: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
54: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
55: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
56: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
57: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
58: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
59: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
60: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,

Line 57: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,

53: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
54: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
55: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
56: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
57: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
58: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
59: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
60: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
61: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,

Line 58: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,

54: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
55: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
56: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
57: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
58: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
59: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
60: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
61: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
62: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,

Line 59: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,

55: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
56: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
57: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
58: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
59: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
60: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
61: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
62: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
63: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,

Line 60: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,

56: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
57: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
58: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
59: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
60: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
61: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
62: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
63: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
64: project_id ap_invoice_distributions_all.project_id%TYPE,

Line 61: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,

57: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
58: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
59: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
60: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
61: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
62: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
63: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
64: project_id ap_invoice_distributions_all.project_id%TYPE,
65: task_id ap_invoice_distributions_all.task_id%TYPE,

Line 62: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,

58: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
59: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
60: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
61: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
62: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
63: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
64: project_id ap_invoice_distributions_all.project_id%TYPE,
65: task_id ap_invoice_distributions_all.task_id%TYPE,
66: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,

Line 63: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,

59: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
60: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
61: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
62: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
63: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
64: project_id ap_invoice_distributions_all.project_id%TYPE,
65: task_id ap_invoice_distributions_all.task_id%TYPE,
66: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
67: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,

Line 64: project_id ap_invoice_distributions_all.project_id%TYPE,

60: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
61: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
62: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
63: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
64: project_id ap_invoice_distributions_all.project_id%TYPE,
65: task_id ap_invoice_distributions_all.task_id%TYPE,
66: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
67: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
68: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,

Line 65: task_id ap_invoice_distributions_all.task_id%TYPE,

61: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
62: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
63: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
64: project_id ap_invoice_distributions_all.project_id%TYPE,
65: task_id ap_invoice_distributions_all.task_id%TYPE,
66: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
67: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
68: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
69: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,

Line 66: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,

62: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
63: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
64: project_id ap_invoice_distributions_all.project_id%TYPE,
65: task_id ap_invoice_distributions_all.task_id%TYPE,
66: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
67: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
68: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
69: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
70: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,

Line 67: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,

63: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
64: project_id ap_invoice_distributions_all.project_id%TYPE,
65: task_id ap_invoice_distributions_all.task_id%TYPE,
66: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
67: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
68: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
69: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
70: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
71: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,

Line 68: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,

64: project_id ap_invoice_distributions_all.project_id%TYPE,
65: task_id ap_invoice_distributions_all.task_id%TYPE,
66: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
67: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
68: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
69: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
70: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
71: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
72: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,

Line 69: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,

65: task_id ap_invoice_distributions_all.task_id%TYPE,
66: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
67: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
68: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
69: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
70: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
71: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
72: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
73: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,

Line 70: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,

66: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
67: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
68: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
69: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
70: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
71: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
72: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
73: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
74: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,

Line 71: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,

67: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
68: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
69: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
70: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
71: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
72: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
73: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
74: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
75: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,

Line 72: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,

68: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
69: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
70: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
71: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
72: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
73: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
74: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
75: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
76: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,

Line 73: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,

69: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
70: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
71: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
72: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
73: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
74: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
75: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
76: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
77: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,

Line 74: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,

70: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
71: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
72: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
73: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
74: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
75: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
76: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
77: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
78: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,

Line 75: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,

71: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
72: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
73: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
74: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
75: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
76: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
77: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
78: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
79: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,

Line 76: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,

72: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
73: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
74: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
75: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
76: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
77: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
78: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
79: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
80: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,

Line 77: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,

73: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
74: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
75: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
76: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
77: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
78: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
79: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
80: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
81: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,

Line 78: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,

74: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
75: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
76: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
77: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
78: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
79: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
80: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
81: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
82: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,

Line 79: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,

75: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
76: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
77: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
78: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
79: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
80: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
81: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
82: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
83: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,

Line 80: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,

76: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
77: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
78: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
79: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
80: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
81: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
82: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
83: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
84: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,

Line 81: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,

77: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
78: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
79: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
80: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
81: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
82: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
83: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
84: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
85: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,

Line 82: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,

78: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
79: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
80: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
81: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
82: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
83: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
84: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
85: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
86: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,

Line 83: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,

79: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
80: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
81: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
82: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
83: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
84: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
85: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
86: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
87: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,

Line 84: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,

80: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
81: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
82: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
83: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
84: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
85: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
86: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
87: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
88: award_id ap_invoice_distributions_all.award_id%TYPE,

Line 85: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,

81: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
82: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
83: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
84: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
85: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
86: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
87: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
88: award_id ap_invoice_distributions_all.award_id%TYPE,
89: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,

Line 86: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,

82: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
83: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
84: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
85: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
86: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
87: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
88: award_id ap_invoice_distributions_all.award_id%TYPE,
89: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
90: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,

Line 87: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,

83: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
84: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
85: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
86: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
87: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
88: award_id ap_invoice_distributions_all.award_id%TYPE,
89: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
90: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
91: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,

Line 88: award_id ap_invoice_distributions_all.award_id%TYPE,

84: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
85: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
86: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
87: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
88: award_id ap_invoice_distributions_all.award_id%TYPE,
89: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
90: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
91: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
92: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,

Line 89: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,

85: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
86: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
87: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
88: award_id ap_invoice_distributions_all.award_id%TYPE,
89: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
90: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
91: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
92: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
93: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,

Line 90: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,

86: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
87: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
88: award_id ap_invoice_distributions_all.award_id%TYPE,
89: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
90: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
91: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
92: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
93: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
94: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,

Line 91: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,

87: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
88: award_id ap_invoice_distributions_all.award_id%TYPE,
89: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
90: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
91: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
92: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
93: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
94: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
95: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,

Line 92: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,

88: award_id ap_invoice_distributions_all.award_id%TYPE,
89: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
90: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
91: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
92: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
93: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
94: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
95: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
96: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,

Line 93: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,

89: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
90: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
91: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
92: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
93: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
94: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
95: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
96: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
97: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,

Line 94: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,

90: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
91: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
92: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
93: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
94: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
95: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
96: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
97: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
98: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,

Line 95: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,

91: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
92: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
93: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
94: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
95: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
96: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
97: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
98: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
99: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,

Line 96: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,

92: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
93: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
94: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
95: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
96: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
97: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
98: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
99: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
100: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,

Line 97: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,

93: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
94: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
95: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
96: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
97: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
98: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
99: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
100: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
101: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,

Line 98: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,

94: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
95: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
96: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
97: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
98: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
99: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
100: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
101: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
102: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,

Line 99: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,

95: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
96: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
97: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
98: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
99: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
100: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
101: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
102: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
103: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,

Line 100: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,

96: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
97: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
98: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
99: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
100: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
101: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
102: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
103: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
104: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,

Line 101: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,

97: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
98: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
99: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
100: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
101: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
102: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
103: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
104: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
105: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,

Line 102: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,

98: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
99: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
100: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
101: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
102: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
103: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
104: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
105: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,
106: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,

Line 103: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,

99: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
100: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
101: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
102: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
103: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
104: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
105: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,
106: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
107: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,

Line 104: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,

100: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
101: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
102: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
103: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
104: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
105: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,
106: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
107: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
108: accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE,

Line 105: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,

101: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
102: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
103: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
104: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
105: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,
106: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
107: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
108: accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE,
109: allow_flex_override_flag ap_system_parameters_all.allow_flex_override_flag%TYPE,

Line 106: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,

102: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
103: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
104: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
105: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,
106: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
107: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
108: accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE,
109: allow_flex_override_flag ap_system_parameters_all.allow_flex_override_flag%TYPE,
110: purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE,

Line 107: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,

103: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
104: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
105: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,
106: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
107: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
108: accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE,
109: allow_flex_override_flag ap_system_parameters_all.allow_flex_override_flag%TYPE,
110: purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE,
111: org_id ap_invoice_distributions_all.org_id%TYPE,

Line 111: org_id ap_invoice_distributions_all.org_id%TYPE,

107: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
108: accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE,
109: allow_flex_override_flag ap_system_parameters_all.allow_flex_override_flag%TYPE,
110: purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE,
111: org_id ap_invoice_distributions_all.org_id%TYPE,
112: tax_regime_id zx_rec_nrec_dist.tax_regime_id%TYPE,
113: tax_id zx_rec_nrec_dist.tax_id%TYPE,
114: tax_status_id zx_rec_nrec_dist.tax_status_id%TYPE,
115: tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE,

Line 116: parent_dist_cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,

112: tax_regime_id zx_rec_nrec_dist.tax_regime_id%TYPE,
113: tax_id zx_rec_nrec_dist.tax_id%TYPE,
114: tax_status_id zx_rec_nrec_dist.tax_status_id%TYPE,
115: tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE,
116: parent_dist_cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
117: parent_dist_reversal_flag ap_invoice_distributions_all.reversal_flag%TYPE,
118: parent_dist_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
119: reversed_tax_dist_id zx_rec_nrec_dist.reversed_tax_dist_id%TYPE,
120: adjusted_doc_tax_dist_id zx_rec_nrec_dist.adjusted_doc_tax_dist_id%TYPE,

Line 117: parent_dist_reversal_flag ap_invoice_distributions_all.reversal_flag%TYPE,

113: tax_id zx_rec_nrec_dist.tax_id%TYPE,
114: tax_status_id zx_rec_nrec_dist.tax_status_id%TYPE,
115: tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE,
116: parent_dist_cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
117: parent_dist_reversal_flag ap_invoice_distributions_all.reversal_flag%TYPE,
118: parent_dist_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
119: reversed_tax_dist_id zx_rec_nrec_dist.reversed_tax_dist_id%TYPE,
120: adjusted_doc_tax_dist_id zx_rec_nrec_dist.adjusted_doc_tax_dist_id%TYPE,
121: applied_from_tax_dist_id zx_rec_nrec_dist.applied_from_tax_dist_id%TYPE,

Line 118: parent_dist_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,

114: tax_status_id zx_rec_nrec_dist.tax_status_id%TYPE,
115: tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE,
116: parent_dist_cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
117: parent_dist_reversal_flag ap_invoice_distributions_all.reversal_flag%TYPE,
118: parent_dist_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
119: reversed_tax_dist_id zx_rec_nrec_dist.reversed_tax_dist_id%TYPE,
120: adjusted_doc_tax_dist_id zx_rec_nrec_dist.adjusted_doc_tax_dist_id%TYPE,
121: applied_from_tax_dist_id zx_rec_nrec_dist.applied_from_tax_dist_id%TYPE,
122: prepay_distribution_id ap_invoice_distributions_all.prepay_distribution_id%TYPE,

Line 122: prepay_distribution_id ap_invoice_distributions_all.prepay_distribution_id%TYPE,

118: parent_dist_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
119: reversed_tax_dist_id zx_rec_nrec_dist.reversed_tax_dist_id%TYPE,
120: adjusted_doc_tax_dist_id zx_rec_nrec_dist.adjusted_doc_tax_dist_id%TYPE,
121: applied_from_tax_dist_id zx_rec_nrec_dist.applied_from_tax_dist_id%TYPE,
122: prepay_distribution_id ap_invoice_distributions_all.prepay_distribution_id%TYPE,
123: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
124: invoice_id ap_invoice_distributions_all.invoice_id%TYPE,
125: batch_id ap_invoice_distributions_all.batch_id%TYPE,
126: set_of_books_id ap_invoice_distributions_all.set_of_books_id%TYPE,

Line 123: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,

119: reversed_tax_dist_id zx_rec_nrec_dist.reversed_tax_dist_id%TYPE,
120: adjusted_doc_tax_dist_id zx_rec_nrec_dist.adjusted_doc_tax_dist_id%TYPE,
121: applied_from_tax_dist_id zx_rec_nrec_dist.applied_from_tax_dist_id%TYPE,
122: prepay_distribution_id ap_invoice_distributions_all.prepay_distribution_id%TYPE,
123: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
124: invoice_id ap_invoice_distributions_all.invoice_id%TYPE,
125: batch_id ap_invoice_distributions_all.batch_id%TYPE,
126: set_of_books_id ap_invoice_distributions_all.set_of_books_id%TYPE,
127: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE

Line 124: invoice_id ap_invoice_distributions_all.invoice_id%TYPE,

120: adjusted_doc_tax_dist_id zx_rec_nrec_dist.adjusted_doc_tax_dist_id%TYPE,
121: applied_from_tax_dist_id zx_rec_nrec_dist.applied_from_tax_dist_id%TYPE,
122: prepay_distribution_id ap_invoice_distributions_all.prepay_distribution_id%TYPE,
123: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
124: invoice_id ap_invoice_distributions_all.invoice_id%TYPE,
125: batch_id ap_invoice_distributions_all.batch_id%TYPE,
126: set_of_books_id ap_invoice_distributions_all.set_of_books_id%TYPE,
127: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE
128: );

Line 125: batch_id ap_invoice_distributions_all.batch_id%TYPE,

121: applied_from_tax_dist_id zx_rec_nrec_dist.applied_from_tax_dist_id%TYPE,
122: prepay_distribution_id ap_invoice_distributions_all.prepay_distribution_id%TYPE,
123: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
124: invoice_id ap_invoice_distributions_all.invoice_id%TYPE,
125: batch_id ap_invoice_distributions_all.batch_id%TYPE,
126: set_of_books_id ap_invoice_distributions_all.set_of_books_id%TYPE,
127: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE
128: );
129:

Line 126: set_of_books_id ap_invoice_distributions_all.set_of_books_id%TYPE,

122: prepay_distribution_id ap_invoice_distributions_all.prepay_distribution_id%TYPE,
123: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
124: invoice_id ap_invoice_distributions_all.invoice_id%TYPE,
125: batch_id ap_invoice_distributions_all.batch_id%TYPE,
126: set_of_books_id ap_invoice_distributions_all.set_of_books_id%TYPE,
127: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE
128: );
129:
130: PROCEDURE insert_tax_distributions

Line 875: FROM ap_invoice_distributions_all aid,

871: l_curr_calling_sequence VARCHAR2(4000);
872:
873: CURSOR prepay_awt_group_id (c_prepay_dist_id IN NUMBER) IS
874: SELECT ail.awt_group_id
875: FROM ap_invoice_distributions_all aid,
876: ap_invoice_lines_all ail
877: WHERE aid.invoice_distribution_id = c_prepay_dist_id
878: AND aid.invoice_id = ail.invoice_id
879: AND aid.invoice_line_number = ail.line_number;

Line 1016: FROM ap_invoice_distributions_all aid

1012: AND NVL(ls.reporting_only_flag, 'N') = 'N'
1013: )
1014: AND EXISTS
1015: (SELECT 'Invoice Distributions Exist'
1016: FROM ap_invoice_distributions_all aid
1017: WHERE aid.invoice_id = ail.invoice_id
1018: AND aid.invoice_line_number = ail.line_number
1019: AND (aid.accounting_event_id IS NOT NULL
1020: OR NVL(aid.match_status_flag,'N') IN ('A','T')

Line 1998: -- This record type is used for ap_invoice_distributions_all and ap_self_assessed_tax_dist_all

1994:
1995: l_dist_ccid_rec zx_api_pub.distccid_det_facts_rec_type;
1996: l_dist_count NUMBER;
1997:
1998: -- This record type is used for ap_invoice_distributions_all and ap_self_assessed_tax_dist_all
1999:
2000: TYPE r_upd_tax_dist_info IS RECORD (
2001: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
2002: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,

Line 2001: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,

1997:
1998: -- This record type is used for ap_invoice_distributions_all and ap_self_assessed_tax_dist_all
1999:
2000: TYPE r_upd_tax_dist_info IS RECORD (
2001: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
2002: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
2003: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
2004: period_name ap_invoice_distributions_all.period_name%TYPE,
2005: amount ap_invoice_distributions_all.amount%TYPE,

Line 2002: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,

1998: -- This record type is used for ap_invoice_distributions_all and ap_self_assessed_tax_dist_all
1999:
2000: TYPE r_upd_tax_dist_info IS RECORD (
2001: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
2002: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
2003: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
2004: period_name ap_invoice_distributions_all.period_name%TYPE,
2005: amount ap_invoice_distributions_all.amount%TYPE,
2006: base_amount ap_invoice_distributions_all.base_amount%TYPE,

Line 2003: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,

1999:
2000: TYPE r_upd_tax_dist_info IS RECORD (
2001: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
2002: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
2003: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
2004: period_name ap_invoice_distributions_all.period_name%TYPE,
2005: amount ap_invoice_distributions_all.amount%TYPE,
2006: base_amount ap_invoice_distributions_all.base_amount%TYPE,
2007: description ap_invoice_distributions_all.description%TYPE,

Line 2004: period_name ap_invoice_distributions_all.period_name%TYPE,

2000: TYPE r_upd_tax_dist_info IS RECORD (
2001: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
2002: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
2003: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
2004: period_name ap_invoice_distributions_all.period_name%TYPE,
2005: amount ap_invoice_distributions_all.amount%TYPE,
2006: base_amount ap_invoice_distributions_all.base_amount%TYPE,
2007: description ap_invoice_distributions_all.description%TYPE,
2008: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,

Line 2005: amount ap_invoice_distributions_all.amount%TYPE,

2001: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
2002: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
2003: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
2004: period_name ap_invoice_distributions_all.period_name%TYPE,
2005: amount ap_invoice_distributions_all.amount%TYPE,
2006: base_amount ap_invoice_distributions_all.base_amount%TYPE,
2007: description ap_invoice_distributions_all.description%TYPE,
2008: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
2009: type_1099 ap_invoice_distributions_all.type_1099%TYPE,

Line 2006: base_amount ap_invoice_distributions_all.base_amount%TYPE,

2002: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
2003: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
2004: period_name ap_invoice_distributions_all.period_name%TYPE,
2005: amount ap_invoice_distributions_all.amount%TYPE,
2006: base_amount ap_invoice_distributions_all.base_amount%TYPE,
2007: description ap_invoice_distributions_all.description%TYPE,
2008: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
2009: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
2010: attribute1 ap_invoice_distributions_all.attribute1%TYPE,

Line 2007: description ap_invoice_distributions_all.description%TYPE,

2003: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
2004: period_name ap_invoice_distributions_all.period_name%TYPE,
2005: amount ap_invoice_distributions_all.amount%TYPE,
2006: base_amount ap_invoice_distributions_all.base_amount%TYPE,
2007: description ap_invoice_distributions_all.description%TYPE,
2008: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
2009: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
2010: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
2011: attribute10 ap_invoice_distributions_all.attribute10%TYPE,

Line 2008: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,

2004: period_name ap_invoice_distributions_all.period_name%TYPE,
2005: amount ap_invoice_distributions_all.amount%TYPE,
2006: base_amount ap_invoice_distributions_all.base_amount%TYPE,
2007: description ap_invoice_distributions_all.description%TYPE,
2008: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
2009: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
2010: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
2011: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
2012: attribute11 ap_invoice_distributions_all.attribute11%TYPE,

Line 2009: type_1099 ap_invoice_distributions_all.type_1099%TYPE,

2005: amount ap_invoice_distributions_all.amount%TYPE,
2006: base_amount ap_invoice_distributions_all.base_amount%TYPE,
2007: description ap_invoice_distributions_all.description%TYPE,
2008: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
2009: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
2010: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
2011: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
2012: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
2013: attribute12 ap_invoice_distributions_all.attribute12%TYPE,

Line 2010: attribute1 ap_invoice_distributions_all.attribute1%TYPE,

2006: base_amount ap_invoice_distributions_all.base_amount%TYPE,
2007: description ap_invoice_distributions_all.description%TYPE,
2008: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
2009: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
2010: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
2011: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
2012: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
2013: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
2014: attribute13 ap_invoice_distributions_all.attribute13%TYPE,

Line 2011: attribute10 ap_invoice_distributions_all.attribute10%TYPE,

2007: description ap_invoice_distributions_all.description%TYPE,
2008: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
2009: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
2010: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
2011: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
2012: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
2013: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
2014: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
2015: attribute14 ap_invoice_distributions_all.attribute14%TYPE,

Line 2012: attribute11 ap_invoice_distributions_all.attribute11%TYPE,

2008: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
2009: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
2010: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
2011: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
2012: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
2013: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
2014: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
2015: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
2016: attribute15 ap_invoice_distributions_all.attribute15%TYPE,

Line 2013: attribute12 ap_invoice_distributions_all.attribute12%TYPE,

2009: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
2010: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
2011: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
2012: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
2013: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
2014: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
2015: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
2016: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
2017: attribute2 ap_invoice_distributions_all.attribute2%TYPE,

Line 2014: attribute13 ap_invoice_distributions_all.attribute13%TYPE,

2010: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
2011: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
2012: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
2013: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
2014: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
2015: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
2016: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
2017: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
2018: attribute3 ap_invoice_distributions_all.attribute3%TYPE,

Line 2015: attribute14 ap_invoice_distributions_all.attribute14%TYPE,

2011: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
2012: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
2013: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
2014: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
2015: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
2016: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
2017: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
2018: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
2019: attribute4 ap_invoice_distributions_all.attribute4%TYPE,

Line 2016: attribute15 ap_invoice_distributions_all.attribute15%TYPE,

2012: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
2013: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
2014: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
2015: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
2016: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
2017: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
2018: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
2019: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
2020: attribute5 ap_invoice_distributions_all.attribute5%TYPE,

Line 2017: attribute2 ap_invoice_distributions_all.attribute2%TYPE,

2013: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
2014: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
2015: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
2016: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
2017: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
2018: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
2019: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
2020: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
2021: attribute6 ap_invoice_distributions_all.attribute6%TYPE,

Line 2018: attribute3 ap_invoice_distributions_all.attribute3%TYPE,

2014: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
2015: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
2016: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
2017: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
2018: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
2019: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
2020: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
2021: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
2022: attribute7 ap_invoice_distributions_all.attribute7%TYPE,

Line 2019: attribute4 ap_invoice_distributions_all.attribute4%TYPE,

2015: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
2016: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
2017: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
2018: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
2019: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
2020: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
2021: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
2022: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
2023: attribute8 ap_invoice_distributions_all.attribute8%TYPE,

Line 2020: attribute5 ap_invoice_distributions_all.attribute5%TYPE,

2016: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
2017: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
2018: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
2019: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
2020: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
2021: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
2022: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
2023: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
2024: attribute9 ap_invoice_distributions_all.attribute9%TYPE,

Line 2021: attribute6 ap_invoice_distributions_all.attribute6%TYPE,

2017: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
2018: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
2019: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
2020: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
2021: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
2022: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
2023: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
2024: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
2025: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,

Line 2022: attribute7 ap_invoice_distributions_all.attribute7%TYPE,

2018: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
2019: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
2020: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
2021: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
2022: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
2023: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
2024: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
2025: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
2026: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,

Line 2023: attribute8 ap_invoice_distributions_all.attribute8%TYPE,

2019: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
2020: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
2021: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
2022: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
2023: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
2024: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
2025: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
2026: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
2027: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,

Line 2024: attribute9 ap_invoice_distributions_all.attribute9%TYPE,

2020: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
2021: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
2022: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
2023: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
2024: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
2025: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
2026: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
2027: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
2028: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,

Line 2025: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,

2021: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
2022: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
2023: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
2024: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
2025: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
2026: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
2027: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
2028: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
2029: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,

Line 2026: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,

2022: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
2023: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
2024: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
2025: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
2026: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
2027: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
2028: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
2029: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
2030: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,

Line 2027: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,

2023: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
2024: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
2025: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
2026: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
2027: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
2028: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
2029: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
2030: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
2031: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,

Line 2028: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,

2024: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
2025: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
2026: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
2027: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
2028: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
2029: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
2030: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
2031: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
2032: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,

Line 2029: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,

2025: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
2026: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
2027: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
2028: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
2029: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
2030: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
2031: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
2032: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
2033: project_id ap_invoice_distributions_all.project_id%TYPE,

Line 2030: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,

2026: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
2027: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
2028: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
2029: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
2030: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
2031: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
2032: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
2033: project_id ap_invoice_distributions_all.project_id%TYPE,
2034: task_id ap_invoice_distributions_all.task_id%TYPE,

Line 2031: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,

2027: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
2028: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
2029: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
2030: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
2031: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
2032: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
2033: project_id ap_invoice_distributions_all.project_id%TYPE,
2034: task_id ap_invoice_distributions_all.task_id%TYPE,
2035: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,

Line 2032: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,

2028: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
2029: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
2030: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
2031: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
2032: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
2033: project_id ap_invoice_distributions_all.project_id%TYPE,
2034: task_id ap_invoice_distributions_all.task_id%TYPE,
2035: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
2036: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,

Line 2033: project_id ap_invoice_distributions_all.project_id%TYPE,

2029: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
2030: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
2031: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
2032: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
2033: project_id ap_invoice_distributions_all.project_id%TYPE,
2034: task_id ap_invoice_distributions_all.task_id%TYPE,
2035: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
2036: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
2037: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,

Line 2034: task_id ap_invoice_distributions_all.task_id%TYPE,

2030: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
2031: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
2032: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
2033: project_id ap_invoice_distributions_all.project_id%TYPE,
2034: task_id ap_invoice_distributions_all.task_id%TYPE,
2035: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
2036: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
2037: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
2038: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,

Line 2035: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,

2031: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
2032: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
2033: project_id ap_invoice_distributions_all.project_id%TYPE,
2034: task_id ap_invoice_distributions_all.task_id%TYPE,
2035: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
2036: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
2037: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
2038: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
2039: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,

Line 2036: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,

2032: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
2033: project_id ap_invoice_distributions_all.project_id%TYPE,
2034: task_id ap_invoice_distributions_all.task_id%TYPE,
2035: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
2036: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
2037: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
2038: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
2039: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
2040: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,

Line 2037: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,

2033: project_id ap_invoice_distributions_all.project_id%TYPE,
2034: task_id ap_invoice_distributions_all.task_id%TYPE,
2035: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
2036: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
2037: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
2038: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
2039: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
2040: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
2041: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,

Line 2038: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,

2034: task_id ap_invoice_distributions_all.task_id%TYPE,
2035: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
2036: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
2037: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
2038: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
2039: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
2040: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
2041: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
2042: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,

Line 2039: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,

2035: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
2036: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
2037: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
2038: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
2039: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
2040: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
2041: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
2042: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
2043: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,

Line 2040: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,

2036: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
2037: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
2038: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
2039: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
2040: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
2041: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
2042: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
2043: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
2044: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,

Line 2041: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,

2037: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
2038: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
2039: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
2040: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
2041: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
2042: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
2043: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
2044: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
2045: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,

Line 2042: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,

2038: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
2039: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
2040: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
2041: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
2042: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
2043: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
2044: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
2045: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
2046: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,

Line 2043: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,

2039: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
2040: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
2041: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
2042: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
2043: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
2044: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
2045: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
2046: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
2047: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,

Line 2044: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,

2040: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
2041: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
2042: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
2043: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
2044: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
2045: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
2046: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
2047: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
2048: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,

Line 2045: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,

2041: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
2042: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
2043: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
2044: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
2045: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
2046: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
2047: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
2048: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
2049: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,

Line 2046: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,

2042: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
2043: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
2044: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
2045: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
2046: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
2047: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
2048: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
2049: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
2050: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,

Line 2047: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,

2043: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
2044: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
2045: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
2046: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
2047: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
2048: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
2049: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
2050: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
2051: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,

Line 2048: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,

2044: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
2045: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
2046: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
2047: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
2048: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
2049: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
2050: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
2051: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
2052: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,

Line 2049: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,

2045: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
2046: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
2047: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
2048: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
2049: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
2050: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
2051: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
2052: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
2053: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,

Line 2050: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,

2046: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
2047: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
2048: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
2049: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
2050: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
2051: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
2052: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
2053: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
2054: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,

Line 2051: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,

2047: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
2048: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
2049: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
2050: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
2051: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
2052: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
2053: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
2054: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
2055: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,

Line 2052: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,

2048: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
2049: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
2050: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
2051: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
2052: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
2053: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
2054: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
2055: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
2056: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,

Line 2053: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,

2049: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
2050: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
2051: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
2052: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
2053: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
2054: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
2055: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
2056: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
2057: award_id ap_invoice_distributions_all.award_id%TYPE,

Line 2054: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,

2050: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
2051: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
2052: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
2053: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
2054: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
2055: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
2056: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
2057: award_id ap_invoice_distributions_all.award_id%TYPE,
2058: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,

Line 2055: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,

2051: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
2052: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
2053: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
2054: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
2055: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
2056: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
2057: award_id ap_invoice_distributions_all.award_id%TYPE,
2058: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
2059: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,

Line 2056: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,

2052: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
2053: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
2054: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
2055: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
2056: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
2057: award_id ap_invoice_distributions_all.award_id%TYPE,
2058: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
2059: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
2060: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,

Line 2057: award_id ap_invoice_distributions_all.award_id%TYPE,

2053: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
2054: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
2055: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
2056: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
2057: award_id ap_invoice_distributions_all.award_id%TYPE,
2058: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
2059: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
2060: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
2061: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,

Line 2058: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,

2054: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
2055: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
2056: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
2057: award_id ap_invoice_distributions_all.award_id%TYPE,
2058: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
2059: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
2060: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
2061: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
2062: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,

Line 2059: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,

2055: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
2056: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
2057: award_id ap_invoice_distributions_all.award_id%TYPE,
2058: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
2059: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
2060: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
2061: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
2062: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
2063: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,

Line 2060: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,

2056: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
2057: award_id ap_invoice_distributions_all.award_id%TYPE,
2058: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
2059: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
2060: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
2061: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
2062: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
2063: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
2064: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,

Line 2061: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,

2057: award_id ap_invoice_distributions_all.award_id%TYPE,
2058: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
2059: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
2060: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
2061: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
2062: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
2063: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
2064: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
2065: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,

Line 2062: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,

2058: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
2059: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
2060: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
2061: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
2062: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
2063: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
2064: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
2065: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
2066: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,

Line 2063: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,

2059: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
2060: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
2061: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
2062: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
2063: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
2064: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
2065: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
2066: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
2067: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,

Line 2064: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,

2060: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
2061: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
2062: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
2063: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
2064: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
2065: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
2066: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
2067: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
2068: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,

Line 2065: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,

2061: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
2062: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
2063: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
2064: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
2065: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
2066: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
2067: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
2068: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
2069: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,

Line 2066: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,

2062: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
2063: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
2064: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
2065: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
2066: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
2067: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
2068: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
2069: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
2070: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,

Line 2067: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,

2063: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
2064: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
2065: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
2066: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
2067: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
2068: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
2069: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
2070: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
2071: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,

Line 2068: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,

2064: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
2065: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
2066: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
2067: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
2068: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
2069: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
2070: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
2071: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
2072: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,

Line 2069: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,

2065: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
2066: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
2067: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
2068: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
2069: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
2070: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
2071: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
2072: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
2073: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,

Line 2070: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,

2066: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
2067: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
2068: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
2069: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
2070: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
2071: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
2072: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
2073: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
2074: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,

Line 2071: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,

2067: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
2068: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
2069: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
2070: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
2071: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
2072: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
2073: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
2074: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
2075: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,

Line 2072: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,

2068: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
2069: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
2070: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
2071: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
2072: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
2073: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
2074: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
2075: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
2076: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,

Line 2073: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,

2069: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
2070: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
2071: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
2072: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
2073: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
2074: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
2075: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
2076: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,
2077: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,

Line 2074: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,

2070: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
2071: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
2072: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
2073: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
2074: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
2075: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
2076: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,
2077: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
2078: invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,

Line 2075: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,

2071: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
2072: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
2073: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
2074: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
2075: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
2076: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,
2077: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
2078: invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,
2079: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE);

Line 2076: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,

2072: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
2073: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
2074: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
2075: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
2076: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,
2077: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
2078: invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,
2079: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE);
2080:

Line 2077: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,

2073: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
2074: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
2075: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
2076: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,
2077: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
2078: invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,
2079: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE);
2080:
2081:

Line 2078: invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,

2074: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
2075: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
2076: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,
2077: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
2078: invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,
2079: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE);
2080:
2081:
2082: TYPE ins_tax_dist_type IS TABLE OF r_ins_tax_dist_info;

Line 2084: TYPE del_tax_dist_type IS TABLE OF ap_invoice_distributions_all.invoice_distribution_id%TYPE;

2080:
2081:
2082: TYPE ins_tax_dist_type IS TABLE OF r_ins_tax_dist_info;
2083: TYPE upd_tax_dist_type IS TABLE OF r_upd_tax_dist_info;
2084: TYPE del_tax_dist_type IS TABLE OF ap_invoice_distributions_all.invoice_distribution_id%TYPE;
2085:
2086: l_inv_dist_ins ins_tax_dist_type;
2087: l_inv_self_ins ins_tax_dist_type;
2088:

Line 2317: ap_invoice_distributions_all parent_taxable_dist

2313: financials_system_params_all fsp,
2314: po_distributions_all pd,
2315: ap_invoice_lines_all parent_tax_line,
2316: ap_invoice_lines_all parent_item_line,
2317: ap_invoice_distributions_all parent_taxable_dist
2318: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
2319: AND gt.ENTITY_CODE = zd.ENTITY_CODE
2320: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE
2321: AND gt.TRX_ID = zd.TRX_ID

Line 2356: FROM ap_invoice_distributions_all aid

2352: parent_item_line.match_type, zd.unit_price))))
2353: -- AND ((zd.recoverable_flag = 'N' AND zd.rec_nrec_rate<>0) OR zd.recoverable_flag = 'Y') --bug 6350100 -- commented out the condition for bug fix 6695517
2354: AND NOT EXISTS
2355: (SELECT aid.detail_tax_dist_id
2356: FROM ap_invoice_distributions_all aid
2357: WHERE aid.invoice_id = zd.trx_id
2358: AND aid.detail_tax_dist_id = zd.rec_nrec_tax_dist_id
2359: AND aid.line_type_lookup_code IN ('REC_TAX','NONREC_TAX'))
2360: AND (parent_taxable_dist.dist_match_type is null

Line 2367: from ap_invoice_distributions_all aid

2363: AND (parent_taxable_dist.prepay_distribution_id IS NULL
2364: or (parent_taxable_dist.prepay_distribution_id IS NOT NULL
2365: and (parent_item_line.line_number IS NOT NULL
2366: or zd.trx_line_id = (select -1 * (aid.invoice_id || aid.invoice_line_number || parent_taxable_dist.invoice_line_number)
2367: from ap_invoice_distributions_all aid
2368: where aid.invoice_distribution_id = parent_taxable_dist.prepay_distribution_id))))
2369: -- Bug 7462582
2370: -- Reverting the fixes done in bugs 6805527 and 7389822 as Etax bug 7515711 will take care of these fixes.
2371: /* Added by schitlap, epajaril to fix the issue in Bug 6805527 */

Line 2630: ap_invoice_distributions_all parent_taxable_dist,

2626: financials_system_params_all fsp,
2627: po_distributions_all pd,
2628: ap_invoice_lines_all parent_tax_line,
2629: ap_invoice_lines_all parent_item_line,
2630: ap_invoice_distributions_all parent_taxable_dist,
2631: ap_line_temp_gt dist
2632: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
2633: AND gt.ENTITY_CODE = zd.ENTITY_CODE
2634: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE

Line 2657: FROM ap_invoice_distributions_all aid

2653: AND parent_item_line.line_type_lookup_code(+) <> 'PREPAY'
2654: AND parent_taxable_dist.line_type_lookup_code <> 'PREPAY'
2655: AND NOT EXISTS
2656: (SELECT aid.detail_tax_dist_id
2657: FROM ap_invoice_distributions_all aid
2658: WHERE aid.invoice_id = zd.trx_id
2659: AND aid.detail_tax_dist_id = zd.rec_nrec_tax_dist_id
2660: AND aid.line_type_lookup_code IN ('TIPV', 'TERV', 'TRV'))
2661: AND ((dist.line_type = 'TIPV'

Line 2882: ap_invoice_distributions_all aid,

2878: FROM zx_trx_headers_gt gt,
2879: zx_rec_nrec_dist zd,
2880: zx_lines zl,
2881: ap_invoices_all ai,
2882: ap_invoice_distributions_all aid,
2883: ap_supplier_sites_all pvs,
2884: ap_system_parameters_all asp,
2885: financials_system_params_all fsp,
2886: po_distributions_all pd,

Line 2889: ap_invoice_distributions_all parent_taxable_dist

2885: financials_system_params_all fsp,
2886: po_distributions_all pd,
2887: ap_invoice_lines_all parent_tax_line,
2888: ap_invoice_lines_all parent_item_line,
2889: ap_invoice_distributions_all parent_taxable_dist
2890: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
2891: AND gt.ENTITY_CODE = zd.ENTITY_CODE
2892: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE
2893: AND gt.TRX_ID = zd.TRX_ID

Line 3112: ap_invoice_distributions_all aid,

3108: FROM zx_trx_headers_gt gt,
3109: zx_rec_nrec_dist zd,
3110: zx_lines zl,
3111: ap_invoices_all ai,
3112: ap_invoice_distributions_all aid,
3113: ap_supplier_sites_all pvs,
3114: ap_system_parameters_all asp,
3115: financials_system_params_all fsp,
3116: po_distributions_all pd,

Line 3119: ap_invoice_distributions_all parent_taxable_dist

3115: financials_system_params_all fsp,
3116: po_distributions_all pd,
3117: ap_invoice_lines_all parent_tax_line,
3118: ap_invoice_lines_all parent_item_line,
3119: ap_invoice_distributions_all parent_taxable_dist
3120: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3121: AND gt.ENTITY_CODE = zd.ENTITY_CODE
3122: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE
3123: AND gt.TRX_ID = zd.TRX_ID

Line 3320: ap_invoice_distributions_all parent_taxable_dist

3316: ap_system_parameters_all asp,
3317: financials_system_params_all fsp,
3318: po_distributions_all pd,
3319: ap_invoice_lines_all parent_item_line,
3320: ap_invoice_distributions_all parent_taxable_dist
3321: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3322: AND gt.ENTITY_CODE = zd.ENTITY_CODE
3323: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE
3324: AND gt.TRX_ID = zd.TRX_ID

Line 3517: ap_invoice_distributions_all parent_taxable_dist

3513: financials_system_params_all fsp,
3514: po_distributions_all pd,
3515: ap_invoice_lines_all parent_tax_line,
3516: ap_invoice_lines_all parent_item_line,
3517: ap_invoice_distributions_all parent_taxable_dist
3518: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3519: AND gt.ENTITY_CODE = zd.ENTITY_CODE
3520: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE
3521: AND gt.TRX_ID = zd.TRX_ID

Line 3542: l_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE;

3538: AND zd.trx_id = parent_taxable_dist.invoice_id(+)
3539: AND zd.trx_line_dist_id = parent_taxable_dist.invoice_distribution_id(+);
3540:
3541:
3542: l_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE;
3543: l_allow_pa_override VARCHAR2(1);
3544:
3545: -- Variables for the eTax API to get the default ccids
3546:

Line 3550: l_tax_liab_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;

3546:
3547: l_return_status_service VARCHAR2(4000);
3548: l_msg_count NUMBER;
3549: l_msg_data VARCHAR2(4000);
3550: l_tax_liab_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
3551:
3552: l_trx_id NUMBER;
3553: l_trx_line_id NUMBER;
3554: l_trx_line_dist_id NUMBER;

Line 3624: UPDATE ap_invoice_distributions_all

3620: FOR j IN l_inv_dist_upd.FIRST..l_inv_dist_upd.LAST LOOP
3621:
3622:
3623:
3624: UPDATE ap_invoice_distributions_all
3625: SET accounting_date = l_inv_dist_upd(j).accounting_date,
3626: last_updated_by = l_user_id,
3627: last_update_date = l_sysdate,
3628: line_type_lookup_code = l_inv_dist_upd(j).line_type_lookup_code,

Line 3740: UPDATE ap_invoice_distributions_all

3736: IF (l_inv_dist_upd.COUNT <> 0) THEN
3737:
3738: FOR j IN l_inv_dist_upd.FIRST..l_inv_dist_upd.LAST LOOP
3739:
3740: UPDATE ap_invoice_distributions_all
3741: SET accounting_date = l_inv_dist_upd(j).accounting_date,
3742: last_updated_by = l_user_id,
3743: last_update_date = l_sysdate,
3744: line_type_lookup_code = l_inv_dist_upd(j).line_type_lookup_code,

Line 4024: FROM ap_invoice_distributions_all

4020:
4021: --Bug fix 6653070, bug fix 6687031
4022: SELECT dist_code_combination_id
4023: INTO l_dist_code_combination_id
4024: FROM ap_invoice_distributions_all
4025: WHERE detail_tax_dist_id = l_inv_dist_ins(i).reversed_tax_dist_id
4026: AND line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX','TIPV', 'TRV', 'TERV')
4027: AND rownum =1;--Bug7241425
4028:

Line 4041: FROM ap_invoice_distributions_all

4037: END IF;
4038:
4039: SELECT dist_code_combination_id
4040: INTO l_dist_code_combination_id
4041: FROM ap_invoice_distributions_all
4042: WHERE detail_tax_dist_id = l_inv_dist_ins(i).adjusted_doc_tax_dist_id
4043: AND line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TIPV','TRV','TERV')--Bug7241425
4044: AND rownum =1;--Bug7241425
4045: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4733: DELETE FROM ap_invoice_distributions_all aid

4729: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4730: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4731: END IF;
4732:
4733: DELETE FROM ap_invoice_distributions_all aid
4734: WHERE aid.invoice_distribution_id IN
4735: (SELECT /*+ leading(gt) cardinality(gt,1) */
4736: dist.invoice_distribution_id
4737: FROM zx_trx_headers_gt gt,

Line 4738: ap_invoice_distributions_all dist

4734: WHERE aid.invoice_distribution_id IN
4735: (SELECT /*+ leading(gt) cardinality(gt,1) */
4736: dist.invoice_distribution_id
4737: FROM zx_trx_headers_gt gt,
4738: ap_invoice_distributions_all dist
4739: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
4740: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
4741: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
4742: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

Line 4788: UPDATE ap_invoice_distributions_all aid

4784: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4785: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
4786: END IF;
4787:
4788: UPDATE ap_invoice_distributions_all aid
4789: SET invoice_line_number = (SELECT line_number
4790: FROM ap_invoice_lines_all ail
4791: WHERE ail.invoice_id = aid.invoice_id
4792: AND ail.summary_tax_line_id = aid.summary_tax_line_id

Line 4798: ap_invoice_distributions_all dist

4794: WHERE aid.invoice_distribution_id IN
4795: (SELECT /*+ leading(gt) cardinality(gt,1) */
4796: dist.invoice_distribution_id
4797: FROM zx_trx_headers_gt gt,
4798: ap_invoice_distributions_all dist
4799: WHERE gt.application_id = 200
4800: AND gt.entity_code = 'AP_INVOICES'
4801: AND gt.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
4802: AND gt.trx_id = dist.invoice_id

Line 5469: FROM ap_invoice_distributions_all

5465:
5466: -- Modified this select to include the TAX only case
5467: CURSOR etax_already_distributed IS
5468: SELECT 'Y'
5469: FROM ap_invoice_distributions_all
5470: WHERE invoice_id = p_invoice_id
5471: AND line_type_lookup_code <> 'AWT'
5472: AND (tax_already_distributed_flag = 'Y'
5473: OR detail_tax_dist_id IS NOT NULL)

Line 5550: ap_invoice_distributions_all.invoice_distribution_id%TYPE;

5546:
5547: l_debug_info VARCHAR2(240);
5548: l_curr_calling_sequence VARCHAR2(4000);
5549: l_invoice_distribution_id
5550: ap_invoice_distributions_all.invoice_distribution_id%TYPE;
5551:
5552: CURSOR invoice_dist_id IS
5553: SELECT invoice_distribution_id
5554: FROM ap_invoice_distributions_all

Line 5554: FROM ap_invoice_distributions_all

5550: ap_invoice_distributions_all.invoice_distribution_id%TYPE;
5551:
5552: CURSOR invoice_dist_id IS
5553: SELECT invoice_distribution_id
5554: FROM ap_invoice_distributions_all
5555: WHERE detail_tax_dist_id = P_Tax_Dist_Id;
5556:
5557: BEGIN
5558:

Line 7029: l_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE;

7025: l_api_name VARCHAR2(80);
7026:
7027: -- Bug 7126676
7028: l_awt_success Varchar2(1000);
7029: l_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE;
7030: BEGIN
7031:
7032: l_api_name := 'Insert_Tax_Distributions';
7033:

Line 7049: INSERT INTO ap_invoice_distributions_all (

7045:
7046: -- bug 7126676
7047: select ap_invoice_distributions_s.NEXTVAL into l_invoice_distribution_id from dual;
7048:
7049: INSERT INTO ap_invoice_distributions_all (
7050: accounting_date,
7051: accrual_posted_flag,
7052: assets_addition_flag,
7053: assets_tracking_flag,

Line 7551: FROM ap_invoice_distributions_all

7547:
7548: -- Modified this select to include the TAX only case
7549: CURSOR etax_already_distributed IS
7550: SELECT 'Y'
7551: FROM ap_invoice_distributions_all
7552: WHERE invoice_id = p_invoice_id
7553: AND line_type_lookup_code <> 'AWT'
7554: AND (tax_already_distributed_flag = 'Y'
7555: OR detail_tax_dist_id IS NOT NULL)

Line 7613: FROM ap_invoice_distributions_all D,

7609: pll.match_option match_option,
7610: pl.unit_meas_lookup_code po_uom,
7611: D.matched_uom_lookup_code rcv_uom,
7612: rsl.item_id rcv_item_id
7613: FROM ap_invoice_distributions_all D,
7614: po_distributions_all PD,
7615: po_lines_all PL,
7616: po_line_locations_all PLL,
7617: rcv_transactions RTXN,