APPS.AP_WORKFLOW_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1893: FROM AP_INVOICE_DISTRIBUTIONS_ALL

1889: -- Need to have an array of lines
1890: --
1891: /*SELECT Invoice_Line_Number
1892: INTO l_line_num
1893: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1894: WHERE project_id =l_ids(l_rec);*/
1895: null;
1896: ELSIF l_class(l_rec) = ame_util.costCenterItemClassName THEN
1897: -- Manoj:

Line 1902: FROM AP_INVOICE_DISTRIBUTIONS_ALL

1898: -- Need to have an array of lines
1899: --
1900: /*SELECT Invoice_Line_Number
1901: INTO l_line_num
1902: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1903: WHERE project_id =l_ids(l_rec);*/
1904: null;
1905: ELSIF l_class(l_rec) <>
1906: ame_util.lineItemItemClassName

Line 1911: FROM AP_INVOICE_DISTRIBUTIONS_ALL

1907: AND l_class(l_rec) <>
1908: ame_util.headerItemClassName THEN
1909: SELECT Invoice_Line_Number
1910: INTO l_line_num
1911: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1912: WHERE invoice_distribution_id = l_ids(l_rec);
1913: END IF; --l_class
1914: /**************/
1915: --IF l_class(l_rec) <>

Line 2062: FROM AP_INVOICE_DISTRIBUTIONS_ALL

2058: -- Need to have an array of lines
2059: --
2060: /*SELECT Invoice_Line_Number
2061: INTO l_line_num
2062: FROM AP_INVOICE_DISTRIBUTIONS_ALL
2063: WHERE project_id = l_next_approver.item_id;*/
2064: null;
2065: ELSIF l_next_approver.item_class =
2066: ame_util.costCenterItemClassName THEN

Line 2072: FROM AP_INVOICE_DISTRIBUTIONS_ALL

2068: -- Need to have an array of lines
2069: --
2070: /*SELECT Invoice_Line_Number
2071: INTO l_line_num
2072: FROM AP_INVOICE_DISTRIBUTIONS_ALL
2073: WHERE project_id = l_next_approver.item_id;*/
2074: null;
2075: ELSIF l_next_approver.item_class <>
2076: ame_util.lineItemItemClassName

Line 2081: FROM AP_INVOICE_DISTRIBUTIONS_ALL

2077: AND l_next_approver.item_class <>
2078: ame_util.headerItemClassName THEN
2079: SELECT Invoice_Line_Number
2080: INTO l_line_num
2081: FROM AP_INVOICE_DISTRIBUTIONS_ALL
2082: WHERE invoice_distribution_id = l_next_approver.item_id;
2083: END IF; --l_class
2084:
2085: /********/

Line 4847: UPDATE ap_invoice_distributions_all

4843: SET accounting_date = l_new_gl_date
4844: ,period_name = l_new_period_name
4845: WHERE invoice_id = l_invoice_id;
4846:
4847: UPDATE ap_invoice_distributions_all
4848: SET accounting_date = l_new_gl_date
4849: ,period_name = l_new_period_name
4850: WHERE invoice_id = l_invoice_id;
4851:

Line 6294: FROM ap_invoice_distributions_all

6290: ELSIF p_attribute_name= 'SUPPLIER_INVOICE_PROJECT_RELATED' THEN
6291:
6292: SELECT count(invoice_distribution_id)
6293: INTO l_count_pa_rel
6294: FROM ap_invoice_distributions_all
6295: WHERE invoice_id = p_invoice_id
6296: AND project_id is not null;
6297:
6298: IF l_count_pa_rel >0 THEN

Line 6346: FROM ap_invoice_distributions_all aid,

6342: SELECT employee_number
6343: INTO l_return_val
6344: FROM per_all_people_f pap
6345: WHERE person_id = (SELECT ph.agent_id
6346: FROM ap_invoice_distributions_all aid,
6347: po_distributions_all pd,
6348: po_headers_all ph
6349: WHERE pd.po_distribution_id =
6350: aid.po_distribution_id

Line 6366: FROM ap_invoice_distributions_all aid,

6362: INTO l_return_val
6363: FROM per_all_people_f pap
6364: WHERE person_id = (
6365: SELECT pd.deliver_to_person_id
6366: FROM ap_invoice_distributions_all aid,
6367: po_distributions_all pd
6368: WHERE pd.po_distribution_id =
6369: aid.po_distribution_id
6370: AND aid.invoice_distribution_id =

Line 6424: FROM ap_invoice_distributions_all

6420: END IF;
6421:
6422: SELECT dist_code_combination_id,set_of_books_id
6423: INTO l_ccid,l_sob
6424: FROM ap_invoice_distributions_all
6425: WHERE invoice_distribution_id=p_dist_id;
6426:
6427: SELECT chart_of_accounts_id
6428: INTO l_chart_of_accounts_id

Line 6879: FROM AP_INVOICE_DISTRIBUTIONS_ALL

6875: ELSIF l_class(l_rec) = 'project code' THEN
6876:
6877: SELECT Invoice_Line_Number
6878: INTO l_line_num
6879: FROM AP_INVOICE_DISTRIBUTIONS_ALL
6880: WHERE project_id =l_ids(l_rec);
6881: ELSIF l_class(l_rec) =
6882: ame_util.costCenterItemClassName THEN
6883:

Line 6886: FROM AP_INVOICE_DISTRIBUTIONS_ALL

6882: ame_util.costCenterItemClassName THEN
6883:
6884: SELECT Invoice_Line_Number
6885: INTO l_line_num
6886: FROM AP_INVOICE_DISTRIBUTIONS_ALL
6887: WHERE project_id =l_ids(l_rec);
6888: --distributions
6889: ELSIF l_class(l_rec) <>
6890: ame_util.lineItemItemClassName

Line 6896: FROM AP_INVOICE_DISTRIBUTIONS_ALL

6892: ame_util.headerItemClassName THEN
6893:
6894: SELECT Invoice_Line_Number
6895: INTO l_line_num
6896: FROM AP_INVOICE_DISTRIBUTIONS_ALL
6897: WHERE invoice_distribution_id = l_ids(l_rec);
6898:
6899: END IF; --l_class
6900:

Line 6959: FROM AP_INVOICE_DISTRIBUTIONS_ALL

6955: ELSIF l_next_approver.item_class = 'project code' THEN
6956:
6957: SELECT Invoice_Line_Number
6958: INTO l_line_num
6959: FROM AP_INVOICE_DISTRIBUTIONS_ALL
6960: WHERE project_id = l_next_approver.item_id;
6961: ELSIF l_next_approver.item_class =
6962: ame_util.costCenterItemClassName THEN
6963:

Line 6966: FROM AP_INVOICE_DISTRIBUTIONS_ALL

6962: ame_util.costCenterItemClassName THEN
6963:
6964: SELECT Invoice_Line_Number
6965: INTO l_line_num
6966: FROM AP_INVOICE_DISTRIBUTIONS_ALL
6967: WHERE project_id = l_next_approver.item_id;
6968: --distributions
6969: ELSIF l_next_approver.item_class <>
6970: ame_util.lineItemItemClassName

Line 6976: FROM AP_INVOICE_DISTRIBUTIONS_ALL

6972: ame_util.headerItemClassName THEN
6973:
6974: SELECT Invoice_Line_Number
6975: INTO l_line_num
6976: FROM AP_INVOICE_DISTRIBUTIONS_ALL
6977: WHERE invoice_distribution_id = l_next_approver.item_id;
6978:
6979: END IF; --l_class
6980: -- Bug 5590138. Modified table to AP_APPROVERS_LIST_GT

Line 7297: and exists( select 1 from ap_invoice_distributions_all aid

7293: END IF;
7294: update ap_invoice_lines_all ail
7295: set generate_dists = decode(ail.generate_dists, 'Y', 'D', ail.generate_dists)
7296: where ail.invoice_id = l_invoice_id
7297: and exists( select 1 from ap_invoice_distributions_all aid
7298: where aid.invoice_id = l_invoice_id
7299: and aid.invoice_line_number = ail.line_number) ;
7300:
7301: -- End bug 6845397