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

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: merchant_document_number ap_invoice_distributions_all.merchant_document_number%TYPE, --Bug14658408: Start

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: merchant_document_number ap_invoice_distributions_all.merchant_document_number%TYPE, --Bug14658408: Start
93: merchant_name ap_invoice_distributions_all.merchant_name%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: merchant_document_number ap_invoice_distributions_all.merchant_document_number%TYPE, --Bug14658408: Start
93: merchant_name ap_invoice_distributions_all.merchant_name%TYPE,
94: merchant_reference ap_invoice_distributions_all.merchant_reference%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: merchant_document_number ap_invoice_distributions_all.merchant_document_number%TYPE, --Bug14658408: Start
93: merchant_name ap_invoice_distributions_all.merchant_name%TYPE,
94: merchant_reference ap_invoice_distributions_all.merchant_reference%TYPE,
95: merchant_tax_reg_number ap_invoice_distributions_all.merchant_tax_reg_number%TYPE,

Line 92: merchant_document_number ap_invoice_distributions_all.merchant_document_number%TYPE, --Bug14658408: Start

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: merchant_document_number ap_invoice_distributions_all.merchant_document_number%TYPE, --Bug14658408: Start
93: merchant_name ap_invoice_distributions_all.merchant_name%TYPE,
94: merchant_reference ap_invoice_distributions_all.merchant_reference%TYPE,
95: merchant_tax_reg_number ap_invoice_distributions_all.merchant_tax_reg_number%TYPE,
96: merchant_taxpayer_id ap_invoice_distributions_all.merchant_taxpayer_id%TYPE, --Bug14658408: End

Line 93: merchant_name ap_invoice_distributions_all.merchant_name%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: merchant_document_number ap_invoice_distributions_all.merchant_document_number%TYPE, --Bug14658408: Start
93: merchant_name ap_invoice_distributions_all.merchant_name%TYPE,
94: merchant_reference ap_invoice_distributions_all.merchant_reference%TYPE,
95: merchant_tax_reg_number ap_invoice_distributions_all.merchant_tax_reg_number%TYPE,
96: merchant_taxpayer_id ap_invoice_distributions_all.merchant_taxpayer_id%TYPE, --Bug14658408: End
97: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,

Line 94: merchant_reference ap_invoice_distributions_all.merchant_reference%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: merchant_document_number ap_invoice_distributions_all.merchant_document_number%TYPE, --Bug14658408: Start
93: merchant_name ap_invoice_distributions_all.merchant_name%TYPE,
94: merchant_reference ap_invoice_distributions_all.merchant_reference%TYPE,
95: merchant_tax_reg_number ap_invoice_distributions_all.merchant_tax_reg_number%TYPE,
96: merchant_taxpayer_id ap_invoice_distributions_all.merchant_taxpayer_id%TYPE, --Bug14658408: End
97: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
98: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,

Line 95: merchant_tax_reg_number ap_invoice_distributions_all.merchant_tax_reg_number%TYPE,

91: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
92: merchant_document_number ap_invoice_distributions_all.merchant_document_number%TYPE, --Bug14658408: Start
93: merchant_name ap_invoice_distributions_all.merchant_name%TYPE,
94: merchant_reference ap_invoice_distributions_all.merchant_reference%TYPE,
95: merchant_tax_reg_number ap_invoice_distributions_all.merchant_tax_reg_number%TYPE,
96: merchant_taxpayer_id ap_invoice_distributions_all.merchant_taxpayer_id%TYPE, --Bug14658408: End
97: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
98: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
99: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,

Line 96: merchant_taxpayer_id ap_invoice_distributions_all.merchant_taxpayer_id%TYPE, --Bug14658408: End

92: merchant_document_number ap_invoice_distributions_all.merchant_document_number%TYPE, --Bug14658408: Start
93: merchant_name ap_invoice_distributions_all.merchant_name%TYPE,
94: merchant_reference ap_invoice_distributions_all.merchant_reference%TYPE,
95: merchant_tax_reg_number ap_invoice_distributions_all.merchant_tax_reg_number%TYPE,
96: merchant_taxpayer_id ap_invoice_distributions_all.merchant_taxpayer_id%TYPE, --Bug14658408: End
97: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
98: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
99: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
100: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,

Line 97: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,

93: merchant_name ap_invoice_distributions_all.merchant_name%TYPE,
94: merchant_reference ap_invoice_distributions_all.merchant_reference%TYPE,
95: merchant_tax_reg_number ap_invoice_distributions_all.merchant_tax_reg_number%TYPE,
96: merchant_taxpayer_id ap_invoice_distributions_all.merchant_taxpayer_id%TYPE, --Bug14658408: End
97: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
98: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
99: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
100: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
101: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,

Line 98: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,

94: merchant_reference ap_invoice_distributions_all.merchant_reference%TYPE,
95: merchant_tax_reg_number ap_invoice_distributions_all.merchant_tax_reg_number%TYPE,
96: merchant_taxpayer_id ap_invoice_distributions_all.merchant_taxpayer_id%TYPE, --Bug14658408: End
97: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
98: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
99: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
100: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
101: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
102: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,

Line 99: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,

95: merchant_tax_reg_number ap_invoice_distributions_all.merchant_tax_reg_number%TYPE,
96: merchant_taxpayer_id ap_invoice_distributions_all.merchant_taxpayer_id%TYPE, --Bug14658408: End
97: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
98: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
99: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
100: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
101: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
102: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
103: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,

Line 100: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,

96: merchant_taxpayer_id ap_invoice_distributions_all.merchant_taxpayer_id%TYPE, --Bug14658408: End
97: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
98: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
99: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
100: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
101: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
102: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
103: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
104: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,

Line 101: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,

97: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
98: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
99: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
100: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
101: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
102: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
103: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
104: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
105: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,

Line 102: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,

98: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
99: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
100: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
101: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
102: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
103: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
104: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
105: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
106: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,

Line 103: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,

99: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
100: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
101: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
102: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
103: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
104: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
105: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
106: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
107: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,

Line 104: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,

100: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
101: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
102: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
103: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
104: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
105: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
106: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
107: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
108: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,

Line 105: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,

101: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
102: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
103: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
104: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
105: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
106: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
107: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
108: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
109: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,

Line 106: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,

102: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
103: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
104: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
105: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
106: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
107: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
108: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
109: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
110: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,

Line 107: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,

103: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
104: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
105: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
106: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
107: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
108: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
109: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
110: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,
111: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,

Line 108: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,

104: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
105: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
106: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
107: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
108: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
109: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
110: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,
111: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
112: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,

Line 109: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,

105: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
106: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
107: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
108: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
109: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
110: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,
111: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
112: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
113: accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE,

Line 110: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,

106: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
107: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
108: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
109: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
110: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,
111: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
112: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
113: accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE,
114: allow_flex_override_flag ap_system_parameters_all.allow_flex_override_flag%TYPE,

Line 111: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,

107: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
108: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
109: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
110: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,
111: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
112: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
113: accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE,
114: allow_flex_override_flag ap_system_parameters_all.allow_flex_override_flag%TYPE,
115: purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE,

Line 112: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,

108: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
109: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
110: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE,
111: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
112: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
113: accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE,
114: allow_flex_override_flag ap_system_parameters_all.allow_flex_override_flag%TYPE,
115: purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE,
116: org_id ap_invoice_distributions_all.org_id%TYPE,

Line 116: org_id ap_invoice_distributions_all.org_id%TYPE,

112: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
113: accrue_on_receipt_flag po_distributions_all.accrue_on_receipt_flag%TYPE,
114: allow_flex_override_flag ap_system_parameters_all.allow_flex_override_flag%TYPE,
115: purch_encumbrance_flag financials_system_params_all.purch_encumbrance_flag%TYPE,
116: org_id ap_invoice_distributions_all.org_id%TYPE,
117: tax_regime_id zx_rec_nrec_dist.tax_regime_id%TYPE,
118: tax_id zx_rec_nrec_dist.tax_id%TYPE,
119: tax_status_id zx_rec_nrec_dist.tax_status_id%TYPE,
120: tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE,

Line 121: par_dist_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%TYPE, -- Bug 13821160

117: tax_regime_id zx_rec_nrec_dist.tax_regime_id%TYPE,
118: tax_id zx_rec_nrec_dist.tax_id%TYPE,
119: tax_status_id zx_rec_nrec_dist.tax_status_id%TYPE,
120: tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE,
121: par_dist_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%TYPE, -- Bug 13821160
122: parent_dist_cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
123: parent_dist_reversal_flag ap_invoice_distributions_all.reversal_flag%TYPE,
124: parent_dist_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
125: reversed_tax_dist_id zx_rec_nrec_dist.reversed_tax_dist_id%TYPE,

Line 122: parent_dist_cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,

118: tax_id zx_rec_nrec_dist.tax_id%TYPE,
119: tax_status_id zx_rec_nrec_dist.tax_status_id%TYPE,
120: tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE,
121: par_dist_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%TYPE, -- Bug 13821160
122: parent_dist_cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
123: parent_dist_reversal_flag ap_invoice_distributions_all.reversal_flag%TYPE,
124: parent_dist_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
125: reversed_tax_dist_id zx_rec_nrec_dist.reversed_tax_dist_id%TYPE,
126: adjusted_doc_tax_dist_id zx_rec_nrec_dist.adjusted_doc_tax_dist_id%TYPE,

Line 123: parent_dist_reversal_flag ap_invoice_distributions_all.reversal_flag%TYPE,

119: tax_status_id zx_rec_nrec_dist.tax_status_id%TYPE,
120: tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE,
121: par_dist_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%TYPE, -- Bug 13821160
122: parent_dist_cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
123: parent_dist_reversal_flag ap_invoice_distributions_all.reversal_flag%TYPE,
124: parent_dist_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
125: reversed_tax_dist_id zx_rec_nrec_dist.reversed_tax_dist_id%TYPE,
126: adjusted_doc_tax_dist_id zx_rec_nrec_dist.adjusted_doc_tax_dist_id%TYPE,
127: applied_from_tax_dist_id zx_rec_nrec_dist.applied_from_tax_dist_id%TYPE,

Line 124: parent_dist_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,

120: tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE,
121: par_dist_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%TYPE, -- Bug 13821160
122: parent_dist_cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
123: parent_dist_reversal_flag ap_invoice_distributions_all.reversal_flag%TYPE,
124: parent_dist_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
125: reversed_tax_dist_id zx_rec_nrec_dist.reversed_tax_dist_id%TYPE,
126: adjusted_doc_tax_dist_id zx_rec_nrec_dist.adjusted_doc_tax_dist_id%TYPE,
127: applied_from_tax_dist_id zx_rec_nrec_dist.applied_from_tax_dist_id%TYPE,
128: prepay_distribution_id ap_invoice_distributions_all.prepay_distribution_id%TYPE,

Line 128: prepay_distribution_id ap_invoice_distributions_all.prepay_distribution_id%TYPE,

124: parent_dist_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
125: reversed_tax_dist_id zx_rec_nrec_dist.reversed_tax_dist_id%TYPE,
126: adjusted_doc_tax_dist_id zx_rec_nrec_dist.adjusted_doc_tax_dist_id%TYPE,
127: applied_from_tax_dist_id zx_rec_nrec_dist.applied_from_tax_dist_id%TYPE,
128: prepay_distribution_id ap_invoice_distributions_all.prepay_distribution_id%TYPE,
129: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
130: invoice_id ap_invoice_distributions_all.invoice_id%TYPE,
131: batch_id ap_invoice_distributions_all.batch_id%TYPE,
132: set_of_books_id ap_invoice_distributions_all.set_of_books_id%TYPE,

Line 129: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,

125: reversed_tax_dist_id zx_rec_nrec_dist.reversed_tax_dist_id%TYPE,
126: adjusted_doc_tax_dist_id zx_rec_nrec_dist.adjusted_doc_tax_dist_id%TYPE,
127: applied_from_tax_dist_id zx_rec_nrec_dist.applied_from_tax_dist_id%TYPE,
128: prepay_distribution_id ap_invoice_distributions_all.prepay_distribution_id%TYPE,
129: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
130: invoice_id ap_invoice_distributions_all.invoice_id%TYPE,
131: batch_id ap_invoice_distributions_all.batch_id%TYPE,
132: set_of_books_id ap_invoice_distributions_all.set_of_books_id%TYPE,
133: pay_awt_group_id ap_invoice_distributions_all.pay_awt_group_id%TYPE, --bug8345264

Line 130: invoice_id ap_invoice_distributions_all.invoice_id%TYPE,

126: adjusted_doc_tax_dist_id zx_rec_nrec_dist.adjusted_doc_tax_dist_id%TYPE,
127: applied_from_tax_dist_id zx_rec_nrec_dist.applied_from_tax_dist_id%TYPE,
128: prepay_distribution_id ap_invoice_distributions_all.prepay_distribution_id%TYPE,
129: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
130: invoice_id ap_invoice_distributions_all.invoice_id%TYPE,
131: batch_id ap_invoice_distributions_all.batch_id%TYPE,
132: set_of_books_id ap_invoice_distributions_all.set_of_books_id%TYPE,
133: pay_awt_group_id ap_invoice_distributions_all.pay_awt_group_id%TYPE, --bug8345264
134: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE

Line 131: batch_id ap_invoice_distributions_all.batch_id%TYPE,

127: applied_from_tax_dist_id zx_rec_nrec_dist.applied_from_tax_dist_id%TYPE,
128: prepay_distribution_id ap_invoice_distributions_all.prepay_distribution_id%TYPE,
129: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
130: invoice_id ap_invoice_distributions_all.invoice_id%TYPE,
131: batch_id ap_invoice_distributions_all.batch_id%TYPE,
132: set_of_books_id ap_invoice_distributions_all.set_of_books_id%TYPE,
133: pay_awt_group_id ap_invoice_distributions_all.pay_awt_group_id%TYPE, --bug8345264
134: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE
135: );

Line 132: set_of_books_id ap_invoice_distributions_all.set_of_books_id%TYPE,

128: prepay_distribution_id ap_invoice_distributions_all.prepay_distribution_id%TYPE,
129: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
130: invoice_id ap_invoice_distributions_all.invoice_id%TYPE,
131: batch_id ap_invoice_distributions_all.batch_id%TYPE,
132: set_of_books_id ap_invoice_distributions_all.set_of_books_id%TYPE,
133: pay_awt_group_id ap_invoice_distributions_all.pay_awt_group_id%TYPE, --bug8345264
134: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE
135: );
136:

Line 133: pay_awt_group_id ap_invoice_distributions_all.pay_awt_group_id%TYPE, --bug8345264

129: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
130: invoice_id ap_invoice_distributions_all.invoice_id%TYPE,
131: batch_id ap_invoice_distributions_all.batch_id%TYPE,
132: set_of_books_id ap_invoice_distributions_all.set_of_books_id%TYPE,
133: pay_awt_group_id ap_invoice_distributions_all.pay_awt_group_id%TYPE, --bug8345264
134: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE
135: );
136:
137: --bug 12728634 Added new function

Line 141: ( p_invoice_id IN ap_invoice_distributions_all.invoice_id%TYPE,

137: --bug 12728634 Added new function
138:
139: /* Bug13399833: Commented this and made the function public by declaring in spec*/
140: /*FUNCTION GET_CCID_FROM_PROJECTS
141: ( p_invoice_id IN ap_invoice_distributions_all.invoice_id%TYPE,
142: p_line_number IN ap_invoice_distributions_all.invoice_line_number%TYPE,
143: p_ccid OUT NOCOPY AP_INVOICE_DISTRIBUTIONS_ALL.DIST_CODE_COMBINATION_ID%TYPE ) RETURN BOOLEAN; */
144:
145: PROCEDURE insert_tax_distributions

Line 142: p_line_number IN ap_invoice_distributions_all.invoice_line_number%TYPE,

138:
139: /* Bug13399833: Commented this and made the function public by declaring in spec*/
140: /*FUNCTION GET_CCID_FROM_PROJECTS
141: ( p_invoice_id IN ap_invoice_distributions_all.invoice_id%TYPE,
142: p_line_number IN ap_invoice_distributions_all.invoice_line_number%TYPE,
143: p_ccid OUT NOCOPY AP_INVOICE_DISTRIBUTIONS_ALL.DIST_CODE_COMBINATION_ID%TYPE ) RETURN BOOLEAN; */
144:
145: PROCEDURE insert_tax_distributions
146: (p_invoice_header_rec IN ap_invoices_all%ROWTYPE,

Line 143: p_ccid OUT NOCOPY AP_INVOICE_DISTRIBUTIONS_ALL.DIST_CODE_COMBINATION_ID%TYPE ) RETURN BOOLEAN; */

139: /* Bug13399833: Commented this and made the function public by declaring in spec*/
140: /*FUNCTION GET_CCID_FROM_PROJECTS
141: ( p_invoice_id IN ap_invoice_distributions_all.invoice_id%TYPE,
142: p_line_number IN ap_invoice_distributions_all.invoice_line_number%TYPE,
143: p_ccid OUT NOCOPY AP_INVOICE_DISTRIBUTIONS_ALL.DIST_CODE_COMBINATION_ID%TYPE ) RETURN BOOLEAN; */
144:
145: PROCEDURE insert_tax_distributions
146: (p_invoice_header_rec IN ap_invoices_all%ROWTYPE,
147: p_inv_dist_rec IN r_ins_tax_dist_info,

Line 1091: FROM ap_invoice_distributions_all aid

1087: l_api_name CONSTANT VARCHAR2(100) := 'Get_Prepay_Awt_Group_Id';
1088:
1089: CURSOR prepay_awt_group_id (c_prepay_dist_id IN NUMBER) IS
1090: SELECT aid.awt_group_id
1091: FROM ap_invoice_distributions_all aid
1092: -- ,ap_invoice_lines_all ail
1093: WHERE aid.invoice_distribution_id = c_prepay_dist_id;
1094: -- AND aid.invoice_id = ail.invoice_id
1095: -- AND aid.invoice_line_number = ail.line_number;

Line 1096: --Bug8334059 Awt_group_id will be retrieved from ap_invoice_distributions_all

1092: -- ,ap_invoice_lines_all ail
1093: WHERE aid.invoice_distribution_id = c_prepay_dist_id;
1094: -- AND aid.invoice_id = ail.invoice_id
1095: -- AND aid.invoice_line_number = ail.line_number;
1096: --Bug8334059 Awt_group_id will be retrieved from ap_invoice_distributions_all
1097:
1098: l_awt_group_id ap_invoice_lines_all.awt_group_id%TYPE;
1099:
1100: BEGIN

Line 1247: FROM ap_invoice_distributions_all aid

1243: AND NVL(ls.reporting_only_flag, 'N') = 'N'
1244: )
1245: AND EXISTS
1246: (SELECT 'Invoice Distributions Exist'
1247: FROM ap_invoice_distributions_all aid
1248: WHERE aid.invoice_id = ail.invoice_id
1249: AND aid.invoice_line_number = ail.line_number
1250: AND (aid.accounting_event_id IS NOT NULL
1251: OR NVL(aid.match_status_flag,'N') IN ('A','T')

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

2296: l_frozen_tax_dist_id NUMBER;
2297: l_frozen_summary_tax_line_id NUMBER;
2298: --Bug9021265
2299:
2300: -- This record type is used for ap_invoice_distributions_all and ap_self_assessed_tax_dist_all
2301:
2302: TYPE r_upd_tax_dist_info IS RECORD (
2303: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
2304: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,

Line 2303: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,

2299:
2300: -- This record type is used for ap_invoice_distributions_all and ap_self_assessed_tax_dist_all
2301:
2302: TYPE r_upd_tax_dist_info IS RECORD (
2303: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
2304: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
2305: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
2306: period_name ap_invoice_distributions_all.period_name%TYPE,
2307: amount ap_invoice_distributions_all.amount%TYPE,

Line 2304: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,

2300: -- This record type is used for ap_invoice_distributions_all and ap_self_assessed_tax_dist_all
2301:
2302: TYPE r_upd_tax_dist_info IS RECORD (
2303: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
2304: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
2305: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
2306: period_name ap_invoice_distributions_all.period_name%TYPE,
2307: amount ap_invoice_distributions_all.amount%TYPE,
2308: base_amount ap_invoice_distributions_all.base_amount%TYPE,

Line 2305: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,

2301:
2302: TYPE r_upd_tax_dist_info IS RECORD (
2303: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
2304: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
2305: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
2306: period_name ap_invoice_distributions_all.period_name%TYPE,
2307: amount ap_invoice_distributions_all.amount%TYPE,
2308: base_amount ap_invoice_distributions_all.base_amount%TYPE,
2309: description ap_invoice_distributions_all.description%TYPE,

Line 2306: period_name ap_invoice_distributions_all.period_name%TYPE,

2302: TYPE r_upd_tax_dist_info IS RECORD (
2303: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
2304: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
2305: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
2306: period_name ap_invoice_distributions_all.period_name%TYPE,
2307: amount ap_invoice_distributions_all.amount%TYPE,
2308: base_amount ap_invoice_distributions_all.base_amount%TYPE,
2309: description ap_invoice_distributions_all.description%TYPE,
2310: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,

Line 2307: amount ap_invoice_distributions_all.amount%TYPE,

2303: accounting_date ap_invoice_distributions_all.accounting_date%TYPE,
2304: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
2305: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
2306: period_name ap_invoice_distributions_all.period_name%TYPE,
2307: amount ap_invoice_distributions_all.amount%TYPE,
2308: base_amount ap_invoice_distributions_all.base_amount%TYPE,
2309: description ap_invoice_distributions_all.description%TYPE,
2310: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
2311: type_1099 ap_invoice_distributions_all.type_1099%TYPE,

Line 2308: base_amount ap_invoice_distributions_all.base_amount%TYPE,

2304: dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE,
2305: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
2306: period_name ap_invoice_distributions_all.period_name%TYPE,
2307: amount ap_invoice_distributions_all.amount%TYPE,
2308: base_amount ap_invoice_distributions_all.base_amount%TYPE,
2309: description ap_invoice_distributions_all.description%TYPE,
2310: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
2311: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
2312: attribute1 ap_invoice_distributions_all.attribute1%TYPE,

Line 2309: description ap_invoice_distributions_all.description%TYPE,

2305: line_type_lookup_code ap_invoice_distributions_all.line_type_lookup_code%TYPE,
2306: period_name ap_invoice_distributions_all.period_name%TYPE,
2307: amount ap_invoice_distributions_all.amount%TYPE,
2308: base_amount ap_invoice_distributions_all.base_amount%TYPE,
2309: description ap_invoice_distributions_all.description%TYPE,
2310: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
2311: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
2312: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
2313: attribute10 ap_invoice_distributions_all.attribute10%TYPE,

Line 2310: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,

2306: period_name ap_invoice_distributions_all.period_name%TYPE,
2307: amount ap_invoice_distributions_all.amount%TYPE,
2308: base_amount ap_invoice_distributions_all.base_amount%TYPE,
2309: description ap_invoice_distributions_all.description%TYPE,
2310: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
2311: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
2312: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
2313: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
2314: attribute11 ap_invoice_distributions_all.attribute11%TYPE,

Line 2311: type_1099 ap_invoice_distributions_all.type_1099%TYPE,

2307: amount ap_invoice_distributions_all.amount%TYPE,
2308: base_amount ap_invoice_distributions_all.base_amount%TYPE,
2309: description ap_invoice_distributions_all.description%TYPE,
2310: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
2311: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
2312: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
2313: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
2314: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
2315: attribute12 ap_invoice_distributions_all.attribute12%TYPE,

Line 2312: attribute1 ap_invoice_distributions_all.attribute1%TYPE,

2308: base_amount ap_invoice_distributions_all.base_amount%TYPE,
2309: description ap_invoice_distributions_all.description%TYPE,
2310: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
2311: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
2312: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
2313: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
2314: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
2315: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
2316: attribute13 ap_invoice_distributions_all.attribute13%TYPE,

Line 2313: attribute10 ap_invoice_distributions_all.attribute10%TYPE,

2309: description ap_invoice_distributions_all.description%TYPE,
2310: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
2311: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
2312: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
2313: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
2314: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
2315: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
2316: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
2317: attribute14 ap_invoice_distributions_all.attribute14%TYPE,

Line 2314: attribute11 ap_invoice_distributions_all.attribute11%TYPE,

2310: income_tax_region ap_invoice_distributions_all.income_tax_region%TYPE,
2311: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
2312: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
2313: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
2314: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
2315: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
2316: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
2317: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
2318: attribute15 ap_invoice_distributions_all.attribute15%TYPE,

Line 2315: attribute12 ap_invoice_distributions_all.attribute12%TYPE,

2311: type_1099 ap_invoice_distributions_all.type_1099%TYPE,
2312: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
2313: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
2314: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
2315: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
2316: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
2317: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
2318: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
2319: attribute2 ap_invoice_distributions_all.attribute2%TYPE,

Line 2316: attribute13 ap_invoice_distributions_all.attribute13%TYPE,

2312: attribute1 ap_invoice_distributions_all.attribute1%TYPE,
2313: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
2314: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
2315: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
2316: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
2317: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
2318: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
2319: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
2320: attribute3 ap_invoice_distributions_all.attribute3%TYPE,

Line 2317: attribute14 ap_invoice_distributions_all.attribute14%TYPE,

2313: attribute10 ap_invoice_distributions_all.attribute10%TYPE,
2314: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
2315: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
2316: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
2317: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
2318: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
2319: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
2320: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
2321: attribute4 ap_invoice_distributions_all.attribute4%TYPE,

Line 2318: attribute15 ap_invoice_distributions_all.attribute15%TYPE,

2314: attribute11 ap_invoice_distributions_all.attribute11%TYPE,
2315: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
2316: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
2317: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
2318: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
2319: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
2320: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
2321: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
2322: attribute5 ap_invoice_distributions_all.attribute5%TYPE,

Line 2319: attribute2 ap_invoice_distributions_all.attribute2%TYPE,

2315: attribute12 ap_invoice_distributions_all.attribute12%TYPE,
2316: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
2317: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
2318: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
2319: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
2320: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
2321: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
2322: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
2323: attribute6 ap_invoice_distributions_all.attribute6%TYPE,

Line 2320: attribute3 ap_invoice_distributions_all.attribute3%TYPE,

2316: attribute13 ap_invoice_distributions_all.attribute13%TYPE,
2317: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
2318: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
2319: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
2320: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
2321: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
2322: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
2323: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
2324: attribute7 ap_invoice_distributions_all.attribute7%TYPE,

Line 2321: attribute4 ap_invoice_distributions_all.attribute4%TYPE,

2317: attribute14 ap_invoice_distributions_all.attribute14%TYPE,
2318: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
2319: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
2320: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
2321: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
2322: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
2323: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
2324: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
2325: attribute8 ap_invoice_distributions_all.attribute8%TYPE,

Line 2322: attribute5 ap_invoice_distributions_all.attribute5%TYPE,

2318: attribute15 ap_invoice_distributions_all.attribute15%TYPE,
2319: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
2320: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
2321: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
2322: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
2323: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
2324: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
2325: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
2326: attribute9 ap_invoice_distributions_all.attribute9%TYPE,

Line 2323: attribute6 ap_invoice_distributions_all.attribute6%TYPE,

2319: attribute2 ap_invoice_distributions_all.attribute2%TYPE,
2320: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
2321: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
2322: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
2323: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
2324: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
2325: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
2326: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
2327: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,

Line 2324: attribute7 ap_invoice_distributions_all.attribute7%TYPE,

2320: attribute3 ap_invoice_distributions_all.attribute3%TYPE,
2321: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
2322: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
2323: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
2324: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
2325: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
2326: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
2327: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
2328: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,

Line 2325: attribute8 ap_invoice_distributions_all.attribute8%TYPE,

2321: attribute4 ap_invoice_distributions_all.attribute4%TYPE,
2322: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
2323: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
2324: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
2325: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
2326: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
2327: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
2328: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
2329: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,

Line 2326: attribute9 ap_invoice_distributions_all.attribute9%TYPE,

2322: attribute5 ap_invoice_distributions_all.attribute5%TYPE,
2323: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
2324: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
2325: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
2326: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
2327: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
2328: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
2329: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
2330: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,

Line 2327: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,

2323: attribute6 ap_invoice_distributions_all.attribute6%TYPE,
2324: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
2325: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
2326: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
2327: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
2328: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
2329: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
2330: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
2331: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,

Line 2328: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,

2324: attribute7 ap_invoice_distributions_all.attribute7%TYPE,
2325: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
2326: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
2327: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
2328: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
2329: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
2330: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
2331: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
2332: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,

Line 2329: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,

2325: attribute8 ap_invoice_distributions_all.attribute8%TYPE,
2326: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
2327: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
2328: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
2329: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
2330: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
2331: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
2332: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
2333: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,

Line 2330: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,

2326: attribute9 ap_invoice_distributions_all.attribute9%TYPE,
2327: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
2328: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
2329: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
2330: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
2331: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
2332: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
2333: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
2334: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,

Line 2331: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,

2327: attribute_category ap_invoice_distributions_all.attribute_category%TYPE,
2328: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
2329: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
2330: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
2331: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
2332: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
2333: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
2334: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
2335: project_id ap_invoice_distributions_all.project_id%TYPE,

Line 2332: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,

2328: expenditure_item_date ap_invoice_distributions_all.expenditure_item_date%TYPE,
2329: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
2330: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
2331: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
2332: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
2333: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
2334: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
2335: project_id ap_invoice_distributions_all.project_id%TYPE,
2336: task_id ap_invoice_distributions_all.task_id%TYPE,

Line 2333: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,

2329: expenditure_organization_id ap_invoice_distributions_all.expenditure_organization_id%TYPE,
2330: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
2331: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
2332: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
2333: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
2334: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
2335: project_id ap_invoice_distributions_all.project_id%TYPE,
2336: task_id ap_invoice_distributions_all.task_id%TYPE,
2337: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,

Line 2334: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,

2330: expenditure_type ap_invoice_distributions_all.expenditure_type%TYPE,
2331: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
2332: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
2333: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
2334: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
2335: project_id ap_invoice_distributions_all.project_id%TYPE,
2336: task_id ap_invoice_distributions_all.task_id%TYPE,
2337: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
2338: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,

Line 2335: project_id ap_invoice_distributions_all.project_id%TYPE,

2331: parent_invoice_id ap_invoice_distributions_all.parent_invoice_id%TYPE,
2332: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
2333: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
2334: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
2335: project_id ap_invoice_distributions_all.project_id%TYPE,
2336: task_id ap_invoice_distributions_all.task_id%TYPE,
2337: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
2338: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
2339: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,

Line 2336: task_id ap_invoice_distributions_all.task_id%TYPE,

2332: pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%TYPE,
2333: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
2334: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
2335: project_id ap_invoice_distributions_all.project_id%TYPE,
2336: task_id ap_invoice_distributions_all.task_id%TYPE,
2337: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
2338: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
2339: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
2340: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,

Line 2337: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,

2333: pa_quantity ap_invoice_distributions_all.pa_quantity%TYPE,
2334: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
2335: project_id ap_invoice_distributions_all.project_id%TYPE,
2336: task_id ap_invoice_distributions_all.task_id%TYPE,
2337: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
2338: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
2339: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
2340: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
2341: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,

Line 2338: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,

2334: project_accounting_context ap_invoice_distributions_all.project_accounting_context%TYPE,
2335: project_id ap_invoice_distributions_all.project_id%TYPE,
2336: task_id ap_invoice_distributions_all.task_id%TYPE,
2337: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
2338: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
2339: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
2340: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
2341: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
2342: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,

Line 2339: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,

2335: project_id ap_invoice_distributions_all.project_id%TYPE,
2336: task_id ap_invoice_distributions_all.task_id%TYPE,
2337: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
2338: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
2339: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
2340: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
2341: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
2342: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
2343: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,

Line 2340: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,

2336: task_id ap_invoice_distributions_all.task_id%TYPE,
2337: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
2338: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
2339: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
2340: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
2341: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
2342: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
2343: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
2344: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,

Line 2341: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,

2337: awt_group_id ap_invoice_distributions_all.awt_group_id%TYPE,
2338: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
2339: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
2340: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
2341: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
2342: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
2343: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
2344: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
2345: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,

Line 2342: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,

2338: global_attribute_category ap_invoice_distributions_all.global_attribute_category%TYPE,
2339: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
2340: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
2341: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
2342: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
2343: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
2344: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
2345: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
2346: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,

Line 2343: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,

2339: global_attribute1 ap_invoice_distributions_all.global_attribute1%TYPE,
2340: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
2341: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
2342: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
2343: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
2344: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
2345: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
2346: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
2347: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,

Line 2344: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,

2340: global_attribute2 ap_invoice_distributions_all.global_attribute2%TYPE,
2341: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
2342: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
2343: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
2344: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
2345: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
2346: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
2347: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
2348: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,

Line 2345: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,

2341: global_attribute3 ap_invoice_distributions_all.global_attribute3%TYPE,
2342: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
2343: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
2344: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
2345: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
2346: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
2347: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
2348: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
2349: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,

Line 2346: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,

2342: global_attribute4 ap_invoice_distributions_all.global_attribute4%TYPE,
2343: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
2344: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
2345: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
2346: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
2347: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
2348: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
2349: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
2350: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,

Line 2347: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,

2343: global_attribute5 ap_invoice_distributions_all.global_attribute5%TYPE,
2344: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
2345: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
2346: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
2347: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
2348: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
2349: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
2350: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
2351: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,

Line 2348: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,

2344: global_attribute6 ap_invoice_distributions_all.global_attribute6%TYPE,
2345: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
2346: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
2347: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
2348: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
2349: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
2350: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
2351: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
2352: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,

Line 2349: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,

2345: global_attribute7 ap_invoice_distributions_all.global_attribute7%TYPE,
2346: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
2347: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
2348: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
2349: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
2350: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
2351: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
2352: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
2353: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,

Line 2350: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,

2346: global_attribute8 ap_invoice_distributions_all.global_attribute8%TYPE,
2347: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
2348: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
2349: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
2350: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
2351: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
2352: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
2353: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
2354: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,

Line 2351: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,

2347: global_attribute9 ap_invoice_distributions_all.global_attribute9%TYPE,
2348: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
2349: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
2350: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
2351: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
2352: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
2353: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
2354: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
2355: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,

Line 2352: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,

2348: global_attribute10 ap_invoice_distributions_all.global_attribute10%TYPE,
2349: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
2350: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
2351: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
2352: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
2353: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
2354: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
2355: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
2356: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,

Line 2353: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,

2349: global_attribute11 ap_invoice_distributions_all.global_attribute11%TYPE,
2350: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
2351: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
2352: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
2353: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
2354: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
2355: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
2356: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
2357: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,

Line 2354: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,

2350: global_attribute12 ap_invoice_distributions_all.global_attribute12%TYPE,
2351: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
2352: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
2353: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
2354: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
2355: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
2356: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
2357: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
2358: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,

Line 2355: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,

2351: global_attribute13 ap_invoice_distributions_all.global_attribute13%TYPE,
2352: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
2353: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
2354: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
2355: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
2356: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
2357: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
2358: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
2359: award_id ap_invoice_distributions_all.award_id%TYPE,

Line 2356: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,

2352: global_attribute14 ap_invoice_distributions_all.global_attribute14%TYPE,
2353: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
2354: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
2355: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
2356: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
2357: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
2358: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
2359: award_id ap_invoice_distributions_all.award_id%TYPE,
2360: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,

Line 2357: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,

2353: global_attribute15 ap_invoice_distributions_all.global_attribute15%TYPE,
2354: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
2355: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
2356: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
2357: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
2358: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
2359: award_id ap_invoice_distributions_all.award_id%TYPE,
2360: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
2361: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,

Line 2358: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,

2354: global_attribute16 ap_invoice_distributions_all.global_attribute16%TYPE,
2355: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
2356: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
2357: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
2358: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
2359: award_id ap_invoice_distributions_all.award_id%TYPE,
2360: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
2361: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
2362: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,

Line 2359: award_id ap_invoice_distributions_all.award_id%TYPE,

2355: global_attribute17 ap_invoice_distributions_all.global_attribute17%TYPE,
2356: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
2357: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
2358: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
2359: award_id ap_invoice_distributions_all.award_id%TYPE,
2360: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
2361: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
2362: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
2363: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,

Line 2360: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,

2356: global_attribute18 ap_invoice_distributions_all.global_attribute18%TYPE,
2357: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
2358: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
2359: award_id ap_invoice_distributions_all.award_id%TYPE,
2360: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
2361: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
2362: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
2363: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
2364: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,

Line 2361: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,

2357: global_attribute19 ap_invoice_distributions_all.global_attribute19%TYPE,
2358: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
2359: award_id ap_invoice_distributions_all.award_id%TYPE,
2360: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
2361: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
2362: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
2363: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
2364: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
2365: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,

Line 2362: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,

2358: global_attribute20 ap_invoice_distributions_all.global_attribute20%TYPE,
2359: award_id ap_invoice_distributions_all.award_id%TYPE,
2360: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
2361: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
2362: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
2363: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
2364: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
2365: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
2366: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,

Line 2363: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,

2359: award_id ap_invoice_distributions_all.award_id%TYPE,
2360: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
2361: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
2362: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
2363: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
2364: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
2365: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
2366: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
2367: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,

Line 2364: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,

2360: dist_match_type ap_invoice_distributions_all.dist_match_type%TYPE,
2361: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
2362: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
2363: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
2364: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
2365: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
2366: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
2367: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
2368: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,

Line 2365: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,

2361: rcv_transaction_id ap_invoice_distributions_all.rcv_transaction_id%TYPE,
2362: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
2363: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
2364: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
2365: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
2366: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
2367: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
2368: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
2369: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,

Line 2366: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,

2362: tax_recoverable_flag ap_invoice_distributions_all.tax_recoverable_flag%TYPE,
2363: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
2364: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
2365: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
2366: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
2367: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
2368: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
2369: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
2370: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,

Line 2367: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,

2363: cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
2364: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
2365: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
2366: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
2367: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
2368: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
2369: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
2370: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
2371: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,

Line 2368: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,

2364: invoice_line_number ap_invoice_distributions_all.invoice_line_number%TYPE,
2365: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
2366: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
2367: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
2368: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
2369: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
2370: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
2371: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
2372: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,

Line 2369: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,

2365: corrected_invoice_dist_id ap_invoice_distributions_all.corrected_invoice_dist_id%TYPE,
2366: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
2367: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
2368: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
2369: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
2370: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
2371: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
2372: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
2373: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,

Line 2370: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,

2366: rounding_amt ap_invoice_distributions_all.rounding_amt%TYPE,
2367: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
2368: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
2369: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
2370: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
2371: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
2372: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
2373: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
2374: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,

Line 2371: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,

2367: charge_applicable_to_dist_id ap_invoice_distributions_all.charge_applicable_to_dist_id%TYPE,
2368: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
2369: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
2370: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
2371: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
2372: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
2373: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
2374: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
2375: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,

Line 2372: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,

2368: distribution_class ap_invoice_distributions_all.distribution_class%TYPE,
2369: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
2370: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
2371: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
2372: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
2373: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
2374: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
2375: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
2376: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,

Line 2373: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,

2369: tax_code_id ap_invoice_distributions_all.tax_code_id%TYPE,
2370: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
2371: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
2372: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
2373: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
2374: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
2375: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
2376: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
2377: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,

Line 2374: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,

2370: detail_tax_dist_id ap_invoice_distributions_all.detail_tax_dist_id%TYPE,
2371: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
2372: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
2373: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
2374: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
2375: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
2376: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
2377: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
2378: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,

Line 2375: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,

2371: rec_nrec_rate ap_invoice_distributions_all.rec_nrec_rate%TYPE,
2372: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
2373: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
2374: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
2375: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
2376: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
2377: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
2378: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,
2379: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,

Line 2376: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,

2372: recovery_rate_id ap_invoice_distributions_all.recovery_rate_id%TYPE,
2373: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
2374: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
2375: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
2376: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
2377: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
2378: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,
2379: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
2380: invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,

Line 2377: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,

2373: recovery_rate_name ap_invoice_distributions_all.recovery_rate_name%TYPE,
2374: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
2375: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
2376: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
2377: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
2378: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,
2379: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
2380: invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,
2381: pay_awt_group_id ap_invoice_distributions_all.pay_awt_group_id%TYPE, --Bug8345264

Line 2378: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,

2374: recovery_type_code ap_invoice_distributions_all.recovery_type_code%TYPE,
2375: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
2376: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
2377: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
2378: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,
2379: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
2380: invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,
2381: pay_awt_group_id ap_invoice_distributions_all.pay_awt_group_id%TYPE, --Bug8345264
2382: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE);

Line 2379: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,

2375: taxable_amount ap_invoice_distributions_all.taxable_amount%TYPE,
2376: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
2377: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
2378: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,
2379: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
2380: invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,
2381: pay_awt_group_id ap_invoice_distributions_all.pay_awt_group_id%TYPE, --Bug8345264
2382: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE);
2383:

Line 2380: invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,

2376: taxable_base_amount ap_invoice_distributions_all.taxable_base_amount%TYPE,
2377: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
2378: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,
2379: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
2380: invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,
2381: pay_awt_group_id ap_invoice_distributions_all.pay_awt_group_id%TYPE, --Bug8345264
2382: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE);
2383:
2384:

Line 2381: pay_awt_group_id ap_invoice_distributions_all.pay_awt_group_id%TYPE, --Bug8345264

2377: summary_tax_line_id ap_invoice_distributions_all.summary_tax_line_id%TYPE,
2378: extra_po_erv ap_invoice_distributions_all.extra_po_erv%TYPE ,
2379: prepay_tax_diff_amount ap_invoice_distributions_all.prepay_tax_diff_amount%TYPE,
2380: invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE,
2381: pay_awt_group_id ap_invoice_distributions_all.pay_awt_group_id%TYPE, --Bug8345264
2382: account_source_tax_rate_id zx_rec_nrec_dist.account_source_tax_rate_id%TYPE);
2383:
2384:
2385: TYPE ins_tax_dist_type IS TABLE OF r_ins_tax_dist_info;

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

2383:
2384:
2385: TYPE ins_tax_dist_type IS TABLE OF r_ins_tax_dist_info;
2386: TYPE upd_tax_dist_type IS TABLE OF r_upd_tax_dist_info;
2387: TYPE del_tax_dist_type IS TABLE OF ap_invoice_distributions_all.invoice_distribution_id%TYPE;
2388:
2389: l_inv_dist_ins ins_tax_dist_type;
2390: l_inv_self_ins ins_tax_dist_type;
2391:

Line 2403: FROM ap_invoice_distributions_all aid,

2399:
2400: cursor frozen_dist_del IS
2401: SELECT /*+ leading(GT) index(GT ZX_TRX_HEADERS_GT_U1) cardinality(GT, 1) use_nl(AID) */ -- 9485828
2402: detail_tax_dist_id,aid.summary_tax_line_id , invoice_id
2403: FROM ap_invoice_distributions_all aid,
2404: zx_trx_headers_gt gt
2405: WHERE aid.line_type_lookup_code IN ('NONREC_TAX','REC_TAX','TRV','TERV','TIPV')
2406: AND (aid.accounting_event_id IS NOT NULL OR
2407: NVL(aid.match_status_flag,'N') IN ('A','T') OR

Line 2706: ap_invoice_distributions_all parent_taxable_dist

2702: financials_system_params_all fsp,
2703: po_distributions_all pd,
2704: ap_invoice_lines_all parent_tax_line,
2705: ap_invoice_lines_all parent_item_line,
2706: ap_invoice_distributions_all parent_taxable_dist
2707: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
2708: AND gt.ENTITY_CODE = zd.ENTITY_CODE
2709: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE
2710: AND gt.TRX_ID = zd.TRX_ID

Line 2745: FROM ap_invoice_distributions_all aid

2741: -- 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
2742: --BUG11656125 END --
2743: AND NOT EXISTS
2744: (SELECT aid.detail_tax_dist_id
2745: FROM ap_invoice_distributions_all aid
2746: WHERE aid.invoice_id = zd.trx_id
2747: AND aid.detail_tax_dist_id = zd.rec_nrec_tax_dist_id
2748: AND aid.line_type_lookup_code IN ('REC_TAX','NONREC_TAX'))
2749: AND NOT EXISTS

Line 2751: FROM ap_invoice_distributions_all aid

2747: AND aid.detail_tax_dist_id = zd.rec_nrec_tax_dist_id
2748: AND aid.line_type_lookup_code IN ('REC_TAX','NONREC_TAX'))
2749: AND NOT EXISTS
2750: (SELECT aid.detail_tax_dist_id
2751: FROM ap_invoice_distributions_all aid
2752: WHERE aid.invoice_id = zd.trx_id
2753: AND aid.detail_tax_dist_id = zd.rec_nrec_tax_dist_id
2754: AND aid.line_type_lookup_code IN ('TRV','TERV','TIPV')
2755: AND (NVL(aid.posted_flag,'N') = 'Y' OR

Line 2768: from ap_invoice_distributions_all aid

2764: AND (parent_taxable_dist.prepay_distribution_id IS NULL
2765: or (parent_taxable_dist.prepay_distribution_id IS NOT NULL
2766: and (parent_item_line.line_number IS NOT NULL
2767: or zd.trx_line_id = (select -1 * (aid.invoice_id || aid.invoice_line_number || parent_taxable_dist.invoice_line_number)
2768: from ap_invoice_distributions_all aid
2769: where aid.invoice_distribution_id = parent_taxable_dist.prepay_distribution_id))))
2770: -- Bug 7462582
2771: -- Reverting the fixes done in bugs 6805527 and 7389822 as Etax bug 7515711 will take care of these fixes.
2772: /* Added by schitlap, epajaril to fix the issue in Bug 6805527 */

Line 3053: ap_invoice_distributions_all parent_taxable_dist,

3049: financials_system_params_all fsp,
3050: po_distributions_all pd,
3051: ap_invoice_lines_all parent_tax_line,
3052: ap_invoice_lines_all parent_item_line,
3053: ap_invoice_distributions_all parent_taxable_dist,
3054: ap_line_temp_gt dist
3055: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3056: AND gt.ENTITY_CODE = zd.ENTITY_CODE
3057: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE

Line 3083: FROM ap_invoice_distributions_all aid

3079: AND parent_item_line.line_type_lookup_code(+) <> 'PREPAY'
3080: AND parent_taxable_dist.line_type_lookup_code <> 'PREPAY'
3081: AND NOT EXISTS
3082: (SELECT aid.detail_tax_dist_id
3083: FROM ap_invoice_distributions_all aid
3084: WHERE aid.invoice_id = zd.trx_id
3085: AND aid.detail_tax_dist_id = zd.rec_nrec_tax_dist_id
3086: AND aid.line_type_lookup_code IN ('TIPV', 'TERV', 'TRV'))
3087: AND NOT EXISTS

Line 3089: FROM ap_invoice_distributions_all aid

3085: AND aid.detail_tax_dist_id = zd.rec_nrec_tax_dist_id
3086: AND aid.line_type_lookup_code IN ('TIPV', 'TERV', 'TRV'))
3087: AND NOT EXISTS
3088: (SELECT aid.detail_tax_dist_id
3089: FROM ap_invoice_distributions_all aid
3090: WHERE aid.invoice_id = zd.trx_id
3091: AND aid.detail_tax_dist_id = zd.rec_nrec_tax_dist_id
3092: AND aid.line_type_lookup_code = 'NONREC_TAX'
3093: AND (NVL(aid.posted_flag,'N') = 'Y' OR

Line 3325: ap_invoice_distributions_all aid,

3321: FROM zx_trx_headers_gt gt,
3322: zx_rec_nrec_dist zd,
3323: zx_lines zl,
3324: ap_invoices_all ai,
3325: ap_invoice_distributions_all aid,
3326: ap_supplier_sites_all pvs,
3327: ap_system_parameters_all asp,
3328: financials_system_params_all fsp,
3329: po_distributions_all pd,

Line 3332: ap_invoice_distributions_all parent_taxable_dist

3328: financials_system_params_all fsp,
3329: po_distributions_all pd,
3330: ap_invoice_lines_all parent_tax_line,
3331: ap_invoice_lines_all parent_item_line,
3332: ap_invoice_distributions_all parent_taxable_dist
3333: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3334: AND gt.ENTITY_CODE = zd.ENTITY_CODE
3335: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE
3336: AND gt.TRX_ID = zd.TRX_ID

Line 3566: ap_invoice_distributions_all aid,

3562: FROM zx_trx_headers_gt gt,
3563: zx_rec_nrec_dist zd,
3564: zx_lines zl,
3565: ap_invoices_all ai,
3566: ap_invoice_distributions_all aid,
3567: ap_supplier_sites_all pvs,
3568: ap_system_parameters_all asp,
3569: financials_system_params_all fsp,
3570: po_distributions_all pd,

Line 3573: ap_invoice_distributions_all parent_taxable_dist

3569: financials_system_params_all fsp,
3570: po_distributions_all pd,
3571: ap_invoice_lines_all parent_tax_line,
3572: ap_invoice_lines_all parent_item_line,
3573: ap_invoice_distributions_all parent_taxable_dist
3574: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3575: AND gt.ENTITY_CODE = zd.ENTITY_CODE
3576: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE
3577: AND gt.TRX_ID = zd.TRX_ID

Line 3791: ap_invoice_distributions_all parent_taxable_dist

3787: ap_system_parameters_all asp,
3788: financials_system_params_all fsp,
3789: po_distributions_all pd,
3790: ap_invoice_lines_all parent_item_line,
3791: ap_invoice_distributions_all parent_taxable_dist
3792: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3793: AND gt.ENTITY_CODE = zd.ENTITY_CODE
3794: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE
3795: AND gt.TRX_ID = zd.TRX_ID

Line 3992: ap_invoice_distributions_all parent_taxable_dist

3988: financials_system_params_all fsp,
3989: po_distributions_all pd,
3990: ap_invoice_lines_all parent_tax_line,
3991: ap_invoice_lines_all parent_item_line,
3992: ap_invoice_distributions_all parent_taxable_dist
3993: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3994: AND gt.ENTITY_CODE = zd.ENTITY_CODE
3995: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE
3996: AND gt.TRX_ID = zd.TRX_ID

Line 4017: l_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE;

4013: AND zd.trx_id = parent_taxable_dist.invoice_id(+)
4014: AND zd.trx_line_dist_id = parent_taxable_dist.invoice_distribution_id(+);
4015:
4016:
4017: l_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%TYPE;
4018: l_allow_pa_override VARCHAR2(1);
4019:
4020: -- Variables for the eTax API to get the default ccids
4021:

Line 4025: l_tax_liab_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;

4021:
4022: l_return_status_service VARCHAR2(4000);
4023: l_msg_count NUMBER;
4024: l_msg_data VARCHAR2(4000);
4025: l_tax_liab_ccid ap_invoice_distributions_all.dist_code_combination_id%TYPE;
4026:
4027: l_trx_id NUMBER;
4028: l_trx_line_id NUMBER;
4029: l_trx_line_dist_id NUMBER;

Line 4044: p_ccid AP_INVOICE_DISTRIBUTIONS_ALL.DIST_CODE_COMBINATION_ID%TYPE; --bug12728634

4040: l_last NUMBER;
4041:
4042: l_tax_only_line_flag VARCHAR2(1); --bug12728634
4043: l_pa_success BOOLEAN; --bug12728634
4044: p_ccid AP_INVOICE_DISTRIBUTIONS_ALL.DIST_CODE_COMBINATION_ID%TYPE; --bug12728634
4045: l_pa_called VARCHAR2(1):='N'; --bug12728634
4046:
4047:
4048: -- Project LCM 7588322

Line 4143: UPDATE ap_invoice_distributions_all

4139: END IF;
4140: END IF;
4141: --bug 10621602 ends
4142: */ --Update flow should not update pa_addition_flag
4143: UPDATE ap_invoice_distributions_all
4144: SET accounting_date = l_inv_dist_upd(j).accounting_date,
4145: last_updated_by = l_user_id,
4146: last_update_date = sysdate, /*Bug10101457: replaced l_sysdate with sysdate*/
4147: line_type_lookup_code = l_inv_dist_upd(j).line_type_lookup_code,

Line 4294: UPDATE ap_invoice_distributions_all

4290: END IF;
4291: END IF;
4292: --bug 10621602 ends
4293: */
4294: UPDATE ap_invoice_distributions_all
4295: SET accounting_date = l_inv_dist_upd(j).accounting_date,
4296: last_updated_by = l_user_id,
4297: last_update_date = sysdate, /*Bug10101457: replaced l_sysdate with sysdate*/
4298: line_type_lookup_code = l_inv_dist_upd(j).line_type_lookup_code,

Line 4580: FROM ap_invoice_distributions_all aid

4576: l_inv_dist_ins(i).charge_applicable_to_dist_id is not null then
4577:
4578: SELECT aid.line_type_lookup_code , aid.retained_invoice_dist_id
4579: INTO l_par_line_type_lookup_code , l_par_retained_invoice_dist_id
4580: FROM ap_invoice_distributions_all aid
4581: WHERE aid.invoice_distribution_id = l_inv_dist_ins(i).charge_applicable_to_dist_id
4582: AND aid.po_distribution_id = l_inv_dist_ins(i).po_distribution_id
4583: AND aid.invoice_id = l_inv_dist_ins(i).invoice_id ;
4584:

Line 4599: FROM ap_invoice_distributions_all aid , ap_invoice_distributions_all aid1

4595: IF (l_par_line_type_lookup_code = 'RETAINAGE' AND l_par_retained_invoice_dist_id IS NOT NULL) THEN
4596:
4597: SELECT aid.dist_code_combination_id
4598: INTO l_dist_code_combination_id
4599: FROM ap_invoice_distributions_all aid , ap_invoice_distributions_all aid1
4600: WHERE aid1.invoice_distribution_id = l_par_retained_invoice_dist_id
4601: AND aid1.line_type_lookup_code = 'RETAINAGE'
4602: AND aid.invoice_distribution_id = aid1.related_retainage_dist_id
4603: AND aid1.invoice_id = aid.invoice_id ;

Line 4760: FROM ap_invoice_distributions_all

4756:
4757: --Bug fix 6653070, bug fix 6687031
4758: SELECT dist_code_combination_id
4759: INTO l_dist_code_combination_id
4760: FROM ap_invoice_distributions_all
4761: WHERE detail_tax_dist_id = l_inv_dist_ins(i).reversed_tax_dist_id
4762: AND line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX','TIPV', 'TRV', 'TERV')
4763: AND rownum =1;--Bug7241425
4764:

Line 4782: FROM ap_invoice_distributions_all

4778: END IF;
4779:
4780: SELECT dist_code_combination_id
4781: INTO l_dist_code_combination_id
4782: FROM ap_invoice_distributions_all
4783: WHERE detail_tax_dist_id = l_inv_dist_ins(i).adjusted_doc_tax_dist_id
4784: AND line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TIPV','TRV','TERV')--Bug7241425
4785: AND rownum =1;--Bug7241425
4786: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 4816: FROM ap_invoice_distributions_all

4812:
4813: BEGIN
4814: SELECT dist_code_combination_id
4815: INTO l_dist_code_combination_id
4816: FROM ap_invoice_distributions_all
4817: WHERE invoice_distribution_id = AP_ETAX_UTILITY_PKG.Get_Dist_Id_For_Tax_Dist_Id
4818: (l_inv_dist_ins(i).applied_from_tax_dist_id);
4819: END;
4820:

Line 5658: ap_invoice_distributions_s.NEXTVAL, -- invoice_distribution_id

5654: l_inv_self_ins(i).award_id, -- award_id
5655: NULL, -- credit_card_trx_id
5656: l_inv_self_ins(i).dist_match_type, -- dist_match_type
5657: l_inv_self_ins(i).rcv_transaction_id, -- rcv_transaction_id
5658: ap_invoice_distributions_s.NEXTVAL, -- invoice_distribution_id
5659: NULL, -- parent_reversal_id
5660: l_inv_self_ins(i).tax_recoverable_flag,
5661: -- tax_recoverable_flag
5662: l_inv_self_ins(i).merchant_document_number, -- merchant_document_number --Bug14658408: Start

Line 5813: DELETE FROM ap_invoice_distributions_all aid

5809: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
5810: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
5811: END IF;
5812:
5813: DELETE FROM ap_invoice_distributions_all aid
5814: WHERE aid.invoice_distribution_id IN
5815: (SELECT /*+ leading(gt) cardinality(gt,1) */
5816: dist.invoice_distribution_id
5817: FROM zx_trx_headers_gt gt,

Line 5818: ap_invoice_distributions_all dist

5814: WHERE aid.invoice_distribution_id IN
5815: (SELECT /*+ leading(gt) cardinality(gt,1) */
5816: dist.invoice_distribution_id
5817: FROM zx_trx_headers_gt gt,
5818: ap_invoice_distributions_all dist
5819: WHERE gt.application_id = AP_ETAX_PKG.AP_APPLICATION_ID
5820: AND gt.entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
5821: AND gt.event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
5822: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

Line 5936: UPDATE ap_invoice_distributions_all aid

5932: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
5933: END IF;
5934:
5935: BEGIN -- Bug 9777752
5936: UPDATE ap_invoice_distributions_all aid
5937: SET invoice_line_number = (SELECT line_number
5938: FROM ap_invoice_lines_all ail
5939: WHERE ail.invoice_id = aid.invoice_id
5940: AND ail.summary_tax_line_id = aid.summary_tax_line_id

Line 5946: ap_invoice_distributions_all dist

5942: WHERE aid.invoice_distribution_id IN
5943: (SELECT /*+ leading(gt) cardinality(gt,1) */
5944: dist.invoice_distribution_id
5945: FROM zx_trx_headers_gt gt,
5946: ap_invoice_distributions_all dist
5947: WHERE gt.application_id = 200
5948: AND gt.entity_code = 'AP_INVOICES'
5949: AND gt.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
5950: AND gt.trx_id = dist.invoice_id

Line 6676: FROM ap_invoice_distributions_all

6672:
6673: -- Modified this select to include the TAX only case
6674: CURSOR etax_already_distributed IS
6675: SELECT 'Y'
6676: FROM ap_invoice_distributions_all
6677: WHERE invoice_id = p_invoice_id
6678: AND line_type_lookup_code <> 'AWT'
6679: AND (tax_already_distributed_flag = 'Y'
6680: OR detail_tax_dist_id IS NOT NULL)

Line 6770: ap_invoice_distributions_all.invoice_distribution_id%TYPE;

6766:
6767: l_debug_info VARCHAR2(240);
6768: l_curr_calling_sequence VARCHAR2(4000);
6769: l_invoice_distribution_id
6770: ap_invoice_distributions_all.invoice_distribution_id%TYPE;
6771: l_api_name CONSTANT VARCHAR2(100) := 'Get_Dist_Id_For_Tax_Dist_Id';
6772:
6773: CURSOR invoice_dist_id IS
6774: SELECT invoice_distribution_id

Line 6775: FROM ap_invoice_distributions_all

6771: l_api_name CONSTANT VARCHAR2(100) := 'Get_Dist_Id_For_Tax_Dist_Id';
6772:
6773: CURSOR invoice_dist_id IS
6774: SELECT invoice_distribution_id
6775: FROM ap_invoice_distributions_all
6776: WHERE detail_tax_dist_id = P_Tax_Dist_Id
6777: UNION /*Bug 13102935:added self assessed tax table*/
6778: SELECT invoice_distribution_id
6779: FROM AP_SELF_ASSESSED_TAX_DIST_ALL

Line 6852: l_posted_flag ap_invoice_distributions.posted_flag%TYPE;

6848: FUNCTION Is_Tax_Dist_Frozen(P_Invoice_Id IN NUMBER,
6849: P_Tax_Dist_Id IN NUMBER,
6850: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN IS
6851:
6852: l_posted_flag ap_invoice_distributions.posted_flag%TYPE;
6853: l_encumbered_flag ap_invoice_distributions.encumbered_flag%TYPE;
6854: l_parent_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
6855: l_prepay_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
6856: l_pa_addition_flag ap_invoice_distributions.pa_addition_flag%TYPE;

Line 6853: l_encumbered_flag ap_invoice_distributions.encumbered_flag%TYPE;

6849: P_Tax_Dist_Id IN NUMBER,
6850: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN IS
6851:
6852: l_posted_flag ap_invoice_distributions.posted_flag%TYPE;
6853: l_encumbered_flag ap_invoice_distributions.encumbered_flag%TYPE;
6854: l_parent_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
6855: l_prepay_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
6856: l_pa_addition_flag ap_invoice_distributions.pa_addition_flag%TYPE;
6857: l_match_status_flag ap_invoice_distributions.match_status_flag%TYPE;

Line 6854: l_parent_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

6850: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN IS
6851:
6852: l_posted_flag ap_invoice_distributions.posted_flag%TYPE;
6853: l_encumbered_flag ap_invoice_distributions.encumbered_flag%TYPE;
6854: l_parent_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
6855: l_prepay_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
6856: l_pa_addition_flag ap_invoice_distributions.pa_addition_flag%TYPE;
6857: l_match_status_flag ap_invoice_distributions.match_status_flag%TYPE;
6858: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;

Line 6855: l_prepay_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

6851:
6852: l_posted_flag ap_invoice_distributions.posted_flag%TYPE;
6853: l_encumbered_flag ap_invoice_distributions.encumbered_flag%TYPE;
6854: l_parent_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
6855: l_prepay_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
6856: l_pa_addition_flag ap_invoice_distributions.pa_addition_flag%TYPE;
6857: l_match_status_flag ap_invoice_distributions.match_status_flag%TYPE;
6858: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
6859: l_line_type_lookup_code ap_invoice_lines.line_type_lookup_code%TYPE;

Line 6856: l_pa_addition_flag ap_invoice_distributions.pa_addition_flag%TYPE;

6852: l_posted_flag ap_invoice_distributions.posted_flag%TYPE;
6853: l_encumbered_flag ap_invoice_distributions.encumbered_flag%TYPE;
6854: l_parent_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
6855: l_prepay_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
6856: l_pa_addition_flag ap_invoice_distributions.pa_addition_flag%TYPE;
6857: l_match_status_flag ap_invoice_distributions.match_status_flag%TYPE;
6858: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
6859: l_line_type_lookup_code ap_invoice_lines.line_type_lookup_code%TYPE;
6860: l_parent_line_type_lookup_code ap_invoice_lines.line_type_lookup_code%TYPE;

Line 6857: l_match_status_flag ap_invoice_distributions.match_status_flag%TYPE;

6853: l_encumbered_flag ap_invoice_distributions.encumbered_flag%TYPE;
6854: l_parent_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
6855: l_prepay_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
6856: l_pa_addition_flag ap_invoice_distributions.pa_addition_flag%TYPE;
6857: l_match_status_flag ap_invoice_distributions.match_status_flag%TYPE;
6858: l_invoice_type_lookup_code ap_invoices.invoice_type_lookup_code%TYPE;
6859: l_line_type_lookup_code ap_invoice_lines.line_type_lookup_code%TYPE;
6860: l_parent_line_type_lookup_code ap_invoice_lines.line_type_lookup_code%TYPE;
6861: l_parent_line_number ap_invoice_lines.line_number%TYPE;

Line 6863: l_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;

6859: l_line_type_lookup_code ap_invoice_lines.line_type_lookup_code%TYPE;
6860: l_parent_line_type_lookup_code ap_invoice_lines.line_type_lookup_code%TYPE;
6861: l_parent_line_number ap_invoice_lines.line_number%TYPE;
6862: l_discarded_flag ap_invoice_lines.discarded_flag%TYPE;
6863: l_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;
6864: l_po_distribution_id po_distributions.po_distribution_id%TYPE;
6865: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
6866: l_parent_dist_amount ap_invoice_distributions.amount%TYPE;
6867: l_prepay_amount_remaining ap_invoice_distributions.prepay_amount_remaining%TYPE;

Line 6866: l_parent_dist_amount ap_invoice_distributions.amount%TYPE;

6862: l_discarded_flag ap_invoice_lines.discarded_flag%TYPE;
6863: l_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;
6864: l_po_distribution_id po_distributions.po_distribution_id%TYPE;
6865: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
6866: l_parent_dist_amount ap_invoice_distributions.amount%TYPE;
6867: l_prepay_amount_remaining ap_invoice_distributions.prepay_amount_remaining%TYPE;
6868: l_debug_info VARCHAR2(1000);
6869: l_tax_dist_frozen VARCHAR2(1) := 'N';
6870: l_curr_calling_sequence VARCHAR2(2000);

Line 6867: l_prepay_amount_remaining ap_invoice_distributions.prepay_amount_remaining%TYPE;

6863: l_reversal_flag ap_invoice_distributions.reversal_flag%TYPE;
6864: l_po_distribution_id po_distributions.po_distribution_id%TYPE;
6865: l_rcv_transaction_id rcv_transactions.transaction_id%TYPE;
6866: l_parent_dist_amount ap_invoice_distributions.amount%TYPE;
6867: l_prepay_amount_remaining ap_invoice_distributions.prepay_amount_remaining%TYPE;
6868: l_debug_info VARCHAR2(1000);
6869: l_tax_dist_frozen VARCHAR2(1) := 'N';
6870: l_curr_calling_sequence VARCHAR2(2000);
6871: BEGIN

Line 6875: l_debug_info := 'Select values from ap_invoice_distributions for tax distribution id';

6871: BEGIN
6872:
6873: l_curr_calling_sequence := p_calling_sequence || ' -> AP_Etax_Utility_Pkg.Is_Tax_Dist_Frozen';
6874:
6875: l_debug_info := 'Select values from ap_invoice_distributions for tax distribution id';
6876:
6877: SELECT aid1.invoice_distribution_id parent_distribution_id,
6878: ai.invoice_type_lookup_code ,
6879: ail.line_type_lookup_code,

Line 6909: FROM ap_invoice_distributions aid,

6905: l_po_distribution_id,
6906: l_rcv_transaction_id,
6907: l_parent_dist_amount,
6908: l_prepay_amount_remaining
6909: FROM ap_invoice_distributions aid,
6910: ap_invoice_distributions aid1,
6911: ap_invoices ai,
6912: ap_invoice_lines ail,
6913: ap_invoice_lines ail1

Line 6910: ap_invoice_distributions aid1,

6906: l_rcv_transaction_id,
6907: l_parent_dist_amount,
6908: l_prepay_amount_remaining
6909: FROM ap_invoice_distributions aid,
6910: ap_invoice_distributions aid1,
6911: ap_invoices ai,
6912: ap_invoice_lines ail,
6913: ap_invoice_lines ail1
6914: WHERE ai.invoice_id = p_invoice_id

Line 6946: ap_invoice_distributions aid

6942: SELECT zl.discarded_flag
6943: INTO l_discarded_flag
6944: FROM zx_lines zl,
6945: zx_rec_nrec_dist zd,
6946: ap_invoice_distributions aid
6947: WHERE zl.tax_line_id = zd.tax_line_id
6948: AND nvl(zl.reporting_only_flag, 'N') = 'N'
6949: AND zd.rec_nrec_tax_dist_id = aid.detail_tax_dist_id
6950: AND aid.invoice_distribution_id = p_tax_dist_id; */

Line 7132: FROM ap_invoice_distributions aid,

7128: P_Calling_Sequence IN VARCHAR2) RETURN BOOLEAN IS
7129:
7130: CURSOR Tax_Distributions IS
7131: SELECT aid.invoice_distribution_id
7132: FROM ap_invoice_distributions aid,
7133: zx_rec_nrec_dist zd
7134: WHERE aid.invoice_id = p_invoice_id
7135: AND aid.detail_tax_dist_id = zd.rec_nrec_tax_dist_id
7136: AND zd.tax_line_id = p_detail_tax_line_id;

Line 7138: l_tax_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;

7134: WHERE aid.invoice_id = p_invoice_id
7135: AND aid.detail_tax_dist_id = zd.rec_nrec_tax_dist_id
7136: AND zd.tax_line_id = p_detail_tax_line_id;
7137:
7138: l_tax_invoice_distribution_id ap_invoice_distributions.invoice_distribution_id%TYPE;
7139: l_tax_line_delete_allowed varchar2(1) := 'Y';
7140: l_debug_info varchar2(1000);
7141: l_curr_calling_sequence varchar2(2000);
7142: l_api_name CONSTANT VARCHAR2(100) := 'IS_TAX_LINE_DELETE_ALLOWED';

Line 9165: l_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE;

9161: l_api_name VARCHAR2(80);
9162:
9163: -- Bug 7126676
9164: l_awt_success Varchar2(1000);
9165: l_invoice_distribution_id ap_invoice_distributions_all.invoice_distribution_id%TYPE;
9166: l_dist_line_num NUMBER; /*bug 10282701*/
9167: BEGIN
9168:
9169: l_api_name := 'Insert_Tax_Distributions';

Line 9184: select ap_invoice_distributions_s.NEXTVAL into l_invoice_distribution_id from dual;

9180: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
9181: END IF;
9182:
9183: -- bug 7126676
9184: select ap_invoice_distributions_s.NEXTVAL into l_invoice_distribution_id from dual;
9185:
9186: l_dist_line_num := AP_INVOICE_LINES_PKG.get_max_dist_line_num(
9187: p_inv_dist_rec.invoice_id,
9188: p_inv_dist_rec.invoice_line_number)+1; /*bug 10282701*/

Line 9190: INSERT INTO ap_invoice_distributions_all (

9186: l_dist_line_num := AP_INVOICE_LINES_PKG.get_max_dist_line_num(
9187: p_inv_dist_rec.invoice_id,
9188: p_inv_dist_rec.invoice_line_number)+1; /*bug 10282701*/
9189:
9190: INSERT INTO ap_invoice_distributions_all (
9191: accounting_date,
9192: accrual_posted_flag,
9193: assets_addition_flag,
9194: assets_tracking_flag,

Line 9725: FROM ap_invoice_distributions_all

9721:
9722: -- Modified this select to include the TAX only case
9723: CURSOR etax_already_distributed IS
9724: SELECT 'Y'
9725: FROM ap_invoice_distributions_all
9726: WHERE invoice_id = p_invoice_id
9727: AND line_type_lookup_code <> 'AWT'
9728: AND (tax_already_distributed_flag = 'Y'
9729: OR detail_tax_dist_id IS NOT NULL)

Line 9801: FROM ap_invoice_distributions_all D,

9797: pll.match_option match_option,
9798: pl.unit_meas_lookup_code po_uom,
9799: D.matched_uom_lookup_code rcv_uom,
9800: rsl.item_id rcv_item_id
9801: FROM ap_invoice_distributions_all D,
9802: po_distributions_all PD,
9803: po_lines_all PL,
9804: po_line_locations_all PLL,
9805: rcv_transactions RTXN,

Line 9913: FROM ap_invoice_distributions_all aid

9909: l_api_name CONSTANT VARCHAR2(100) := 'Get_Prepay_Pay_Awt_Group_Id';
9910:
9911: CURSOR prepay_pay_awt_group_id (c_prepay_dist_id IN NUMBER) IS
9912: SELECT aid.pay_awt_group_id
9913: FROM ap_invoice_distributions_all aid
9914: WHERE aid.invoice_distribution_id = c_prepay_dist_id;
9915:
9916: l_pay_awt_group_id ap_invoice_distributions_all.pay_awt_group_id%TYPE;
9917:

Line 9916: l_pay_awt_group_id ap_invoice_distributions_all.pay_awt_group_id%TYPE;

9912: SELECT aid.pay_awt_group_id
9913: FROM ap_invoice_distributions_all aid
9914: WHERE aid.invoice_distribution_id = c_prepay_dist_id;
9915:
9916: l_pay_awt_group_id ap_invoice_distributions_all.pay_awt_group_id%TYPE;
9917:
9918: BEGIN
9919:
9920: l_curr_calling_sequence := 'AP_ETAX_UTILITY_PKG.Get_Prepay_Pay_Awt_Group_Id<-'||

Line 10036: FROM ap_invoice_distributions_all

10032: l_debug_info := 'Step 1: Check Posted Distributions Count ';
10033: -------------------------------------------------------------------
10034: SELECT COUNT(posted_flag)
10035: INTO l_Posted_count
10036: FROM ap_invoice_distributions_all
10037: WHERE invoice_id = p_invoice_id
10038: AND invoice_line_number = p_line_number
10039: AND NVL(posted_flag,'N') = 'Y';
10040:

Line 10063: FROM ap_invoice_distributions_all

10059:
10060: IF l_Prepay_line_count = 0 THEN
10061: SELECT count(prepay_distribution_id)
10062: INTO l_Prepay_dist_count
10063: FROM ap_invoice_distributions_all
10064: WHERE invoice_id = p_invoice_id
10065: AND prepay_distribution_id IS NOT NULL
10066: AND (NVL(reversal_flag,'N') <> 'Y');
10067: END IF;

Line 10157: FROM ap_invoice_distributions_all aid

10153: AND line_type_lookup_code ='AWT'
10154: AND (NVL(discarded_flag,'N') <> 'Y')
10155: AND line_source = 'MANUAL LINE ENTRY'
10156: AND NOT EXISTS (SELECT 1
10157: FROM ap_invoice_distributions_all aid
10158: WHERE ail.invoice_id = aid.invoice_id
10159: AND ail.line_number = aid.invoice_line_number);
10160: SELECT COUNT(1)
10161: INTO l_Awt_line_count

Line 10162: FROM ap_invoice_distributions_all aid

10158: WHERE ail.invoice_id = aid.invoice_id
10159: AND ail.line_number = aid.invoice_line_number);
10160: SELECT COUNT(1)
10161: INTO l_Awt_line_count
10162: FROM ap_invoice_distributions_all aid
10163: WHERE aid.invoice_id = p_invoice_id
10164: AND NVL(aid.reversal_flag,'N') <> 'Y'
10165: AND aid.line_type_lookup_code = 'AWT'
10166: AND aid.awt_related_id IN

Line 10168: FROM ap_invoice_distributions_all aid1

10164: AND NVL(aid.reversal_flag,'N') <> 'Y'
10165: AND aid.line_type_lookup_code = 'AWT'
10166: AND aid.awt_related_id IN
10167: (SELECT aid1.invoice_distribution_id
10168: FROM ap_invoice_distributions_all aid1
10169: WHERE aid1.invoice_id = aid.invoice_id
10170: AND aid1.invoice_line_number = p_line_number
10171: AND aid1.line_type_lookup_code <> 'AWT');
10172:

Line 10192: FROM ap_invoice_distributions_all

10188: l_debug_info := 'Step 7: Check Encumbered Distributions Count ';
10189: -------------------------------------------------------------------
10190: SELECT COUNT(1)
10191: INTO l_Encumbered_count
10192: FROM ap_invoice_distributions_all
10193: WHERE invoice_id = p_invoice_id
10194: AND invoice_line_number = p_line_number
10195: AND NVL(encumbered_flag,'N') = 'Y';
10196:

Line 10211: FROM ap_invoice_distributions_all

10207: l_debug_info := 'Step 8: Check PO Matched Distributions Count ';
10208: -------------------------------------------------------------------
10209: SELECT COUNT(po_distribution_id)
10210: INTO l_Po_Dist_id_count
10211: FROM ap_invoice_distributions_all
10212: WHERE invoice_id = p_invoice_id
10213: AND invoice_line_number = p_line_number
10214: AND po_distribution_id IS NOT NULL;
10215:

Line 10311: FROM ap_invoice_distributions AID

10307: AND ZD.trx_id = p_invoice_id
10308: AND ZD.inclusive_flag = 'Y'
10309: AND ZD.rec_nrec_tax_dist_id IN
10310: ( SELECT AID.detail_tax_dist_id
10311: FROM ap_invoice_distributions AID
10312: WHERE AID.invoice_id = p_invoice_id
10313: AND AID.invoice_line_number = p_line_number
10314: AND AID.line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TERV','TIPV')
10315: AND AID.detail_tax_dist_id IS NOT NULL

Line 10317: FROM ap_invoice_distributions AID1

10313: AND AID.invoice_line_number = p_line_number
10314: AND AID.line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TERV','TIPV')
10315: AND AID.detail_tax_dist_id IS NOT NULL
10316: AND EXISTS ( SELECT 'LINE HAS ANY POSTED DIST'
10317: FROM ap_invoice_distributions AID1
10318: WHERE AID1.invoice_id = AID.invoice_id
10319: AND AID1.invoice_line_number = AID.invoice_line_number
10320: AND AID1.line_type_lookup_code <> AID.line_type_lookup_code
10321: AND AID1.invoice_distribution_id = AID.charge_applicable_to_dist_id

Line 10339: FROM ap_invoice_distributions AID

10335: AND ZD.trx_id = p_invoice_id
10336: AND ZD.inclusive_flag = 'Y'
10337: AND ZD.rec_nrec_tax_dist_id IN
10338: ( SELECT AID.detail_tax_dist_id
10339: FROM ap_invoice_distributions AID
10340: WHERE AID.invoice_id = p_invoice_id
10341: AND AID.line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TERV','TIPV')
10342: AND AID.detail_tax_dist_id IS NOT NULL
10343: AND EXISTS ( SELECT 'LINE HAS ANY POSTED DIST'

Line 10344: FROM ap_invoice_distributions AID1

10340: WHERE AID.invoice_id = p_invoice_id
10341: AND AID.line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TERV','TIPV')
10342: AND AID.detail_tax_dist_id IS NOT NULL
10343: AND EXISTS ( SELECT 'LINE HAS ANY POSTED DIST'
10344: FROM ap_invoice_distributions AID1
10345: WHERE AID1.invoice_id = AID.invoice_id
10346: AND AID1.invoice_line_number = AID.invoice_line_number
10347: AND AID1.line_type_lookup_code <> AID.line_type_lookup_code
10348: AND AID1.invoice_distribution_id = AID.charge_applicable_to_dist_id

Line 10394: FROM ap_invoice_distributions_all

10390: END IF;
10391:
10392: /* SELECT 'Tax Only Line Exist'
10393: INTO l_dummy
10394: FROM ap_invoice_distributions_all
10395: WHERE invoice_id = p_invoice_id
10396: AND line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TIPV', 'TRV', 'TERV')
10397: AND charge_applicable_to_dist_id IS NULL
10398: AND rownum = 1; */

Line 10670: FUNCTION GET_CCID_FROM_PROJECTS( p_invoice_id IN ap_invoice_distributions_all.invoice_id%TYPE,

10666: |
10667: ============================================================================*/
10668: --bug 12728634 Added new function
10669:
10670: FUNCTION GET_CCID_FROM_PROJECTS( p_invoice_id IN ap_invoice_distributions_all.invoice_id%TYPE,
10671: p_line_number IN ap_invoice_distributions_all.invoice_line_number%TYPE,
10672: p_ccid OUT NOCOPY AP_INVOICE_DISTRIBUTIONS_ALL.DIST_CODE_COMBINATION_ID%TYPE) RETURN BOOLEAN
10673: IS
10674:

Line 10671: p_line_number IN ap_invoice_distributions_all.invoice_line_number%TYPE,

10667: ============================================================================*/
10668: --bug 12728634 Added new function
10669:
10670: FUNCTION GET_CCID_FROM_PROJECTS( p_invoice_id IN ap_invoice_distributions_all.invoice_id%TYPE,
10671: p_line_number IN ap_invoice_distributions_all.invoice_line_number%TYPE,
10672: p_ccid OUT NOCOPY AP_INVOICE_DISTRIBUTIONS_ALL.DIST_CODE_COMBINATION_ID%TYPE) RETURN BOOLEAN
10673: IS
10674:
10675: CURSOR line_rec IS

Line 10672: p_ccid OUT NOCOPY AP_INVOICE_DISTRIBUTIONS_ALL.DIST_CODE_COMBINATION_ID%TYPE) RETURN BOOLEAN

10668: --bug 12728634 Added new function
10669:
10670: FUNCTION GET_CCID_FROM_PROJECTS( p_invoice_id IN ap_invoice_distributions_all.invoice_id%TYPE,
10671: p_line_number IN ap_invoice_distributions_all.invoice_line_number%TYPE,
10672: p_ccid OUT NOCOPY AP_INVOICE_DISTRIBUTIONS_ALL.DIST_CODE_COMBINATION_ID%TYPE) RETURN BOOLEAN
10673: IS
10674:
10675: CURSOR line_rec IS
10676: SELECT INVOICE_ID,

Line 10838: l_dist_ccid AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;

10834: WHERE invoice_id = p_invoice_id
10835: AND line_number = p_line_number;
10836:
10837: l_invoice_line_rec AP_INVOICES_PKG.r_invoice_line_rec;
10838: l_dist_ccid AP_INVOICE_DISTRIBUTIONS.DIST_CODE_COMBINATION_ID%TYPE;
10839: debug_info VARCHAR2(2000);
10840: debug_context VARCHAR2(2000);
10841: l_dist_code_concat VARCHAR2(2000);
10842: l_invoice_attribute_rec AP_UTILITIES_PKG.r_invoice_attribute_rec;

Line 11435: FROM ap_invoice_distributions_all AId

11431: -------------------------------------------------------------------------------
11432:
11433: SELECT COUNT('DISTS POSTED OR ENCUMBERED')
11434: INTO l_dont_allow_update
11435: FROM ap_invoice_distributions_all AId
11436: WHERE AID.invoice_id = p_invoice_id
11437: AND AID.invoice_line_number = p_line_number
11438: AND (AID.posted_flag = 'Y' OR
11439: NVL(AID.encumbered_flag, 'N' ) IN ('Y', 'D', 'W', 'X'))