APPS.AP_WORKFLOW_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1939: FROM AP_INVOICE_DISTRIBUTIONS_ALL

1935: -- Need to have an array of lines
1936: --
1937: /*SELECT Invoice_Line_Number
1938: INTO l_line_num
1939: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1940: WHERE project_id =l_ids(l_rec);*/
1941: null;
1942: ELSIF l_class(l_rec) = ame_util.costCenterItemClassName THEN
1943: -- Manoj:

Line 1948: FROM AP_INVOICE_DISTRIBUTIONS_ALL

1944: -- Need to have an array of lines
1945: --
1946: /*SELECT Invoice_Line_Number
1947: INTO l_line_num
1948: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1949: WHERE project_id =l_ids(l_rec);*/
1950: null;
1951: ELSIF l_class(l_rec) <>
1952: ame_util.lineItemItemClassName

Line 1957: FROM AP_INVOICE_DISTRIBUTIONS_ALL

1953: AND l_class(l_rec) <>
1954: ame_util.headerItemClassName THEN
1955: SELECT Invoice_Line_Number
1956: INTO l_line_num
1957: FROM AP_INVOICE_DISTRIBUTIONS_ALL
1958: WHERE invoice_distribution_id = l_ids(l_rec);
1959: END IF; --l_class
1960: /**************/
1961: --IF l_class(l_rec) <>

Line 2133: FROM AP_INVOICE_DISTRIBUTIONS_ALL

2129: -- Need to have an array of lines
2130: --
2131: /*SELECT Invoice_Line_Number
2132: INTO l_line_num
2133: FROM AP_INVOICE_DISTRIBUTIONS_ALL
2134: WHERE project_id = l_next_approver.item_id;*/
2135: null;
2136: ELSIF l_next_approver.item_class =
2137: ame_util.costCenterItemClassName THEN

Line 2143: FROM AP_INVOICE_DISTRIBUTIONS_ALL

2139: -- Need to have an array of lines
2140: --
2141: /*SELECT Invoice_Line_Number
2142: INTO l_line_num
2143: FROM AP_INVOICE_DISTRIBUTIONS_ALL
2144: WHERE project_id = l_next_approver.item_id;*/
2145: null;
2146: ELSIF l_next_approver.item_class <>
2147: ame_util.lineItemItemClassName

Line 2152: FROM AP_INVOICE_DISTRIBUTIONS_ALL

2148: AND l_next_approver.item_class <>
2149: ame_util.headerItemClassName THEN
2150: SELECT Invoice_Line_Number
2151: INTO l_line_num
2152: FROM AP_INVOICE_DISTRIBUTIONS_ALL
2153: WHERE invoice_distribution_id = l_next_approver.item_id;
2154: END IF; --l_class
2155:
2156: /********/

Line 4982: UPDATE ap_invoice_distributions_all

4978: SET accounting_date = l_new_gl_date
4979: ,period_name = l_new_period_name
4980: WHERE invoice_id = l_invoice_id;
4981:
4982: UPDATE ap_invoice_distributions_all
4983: SET accounting_date = l_new_gl_date
4984: ,period_name = l_new_period_name
4985: WHERE invoice_id = l_invoice_id;
4986:

Line 6561: FROM ap_invoice_distributions_all

6557: ELSIF p_attribute_name= 'SUPPLIER_INVOICE_PROJECT_RELATED' THEN
6558:
6559: SELECT count(invoice_distribution_id)
6560: INTO l_count_pa_rel
6561: FROM ap_invoice_distributions_all
6562: WHERE invoice_id = p_invoice_id
6563: AND project_id is not null;
6564:
6565: IF l_count_pa_rel >0 THEN

Line 6614: FROM ap_invoice_distributions_all aid,

6610: SELECT employee_number
6611: INTO l_return_val
6612: FROM per_all_people_f pap
6613: WHERE person_id = (SELECT ph.agent_id
6614: FROM ap_invoice_distributions_all aid,
6615: po_distributions_all pd,
6616: po_headers_all ph
6617: WHERE pd.po_distribution_id =
6618: aid.po_distribution_id

Line 6634: FROM ap_invoice_distributions_all aid,

6630: INTO l_return_val
6631: FROM per_all_people_f pap
6632: WHERE person_id = (
6633: SELECT pd.deliver_to_person_id
6634: FROM ap_invoice_distributions_all aid,
6635: po_distributions_all pd
6636: WHERE pd.po_distribution_id =
6637: aid.po_distribution_id
6638: AND aid.invoice_distribution_id =

Line 6692: FROM ap_invoice_distributions_all

6688: END IF;
6689:
6690: SELECT dist_code_combination_id,set_of_books_id
6691: INTO l_ccid,l_sob
6692: FROM ap_invoice_distributions_all
6693: WHERE invoice_distribution_id=p_dist_id;
6694:
6695: SELECT chart_of_accounts_id
6696: INTO l_chart_of_accounts_id

Line 7188: FROM AP_INVOICE_DISTRIBUTIONS_ALL

7184: ELSIF l_class(l_rec) = 'project code' THEN
7185:
7186: SELECT Invoice_Line_Number
7187: INTO l_line_num
7188: FROM AP_INVOICE_DISTRIBUTIONS_ALL
7189: WHERE project_id =l_ids(l_rec);
7190: ELSIF l_class(l_rec) =
7191: ame_util.costCenterItemClassName THEN
7192:

Line 7195: FROM AP_INVOICE_DISTRIBUTIONS_ALL

7191: ame_util.costCenterItemClassName THEN
7192:
7193: SELECT Invoice_Line_Number
7194: INTO l_line_num
7195: FROM AP_INVOICE_DISTRIBUTIONS_ALL
7196: WHERE project_id =l_ids(l_rec);
7197: --distributions
7198: ELSIF l_class(l_rec) <>
7199: ame_util.lineItemItemClassName

Line 7205: FROM AP_INVOICE_DISTRIBUTIONS_ALL

7201: ame_util.headerItemClassName THEN
7202:
7203: SELECT Invoice_Line_Number
7204: INTO l_line_num
7205: FROM AP_INVOICE_DISTRIBUTIONS_ALL
7206: WHERE invoice_distribution_id = l_ids(l_rec);
7207:
7208: END IF; --l_class
7209:

Line 7268: FROM AP_INVOICE_DISTRIBUTIONS_ALL

7264: ELSIF l_next_approver.item_class = 'project code' THEN
7265:
7266: SELECT Invoice_Line_Number
7267: INTO l_line_num
7268: FROM AP_INVOICE_DISTRIBUTIONS_ALL
7269: WHERE project_id = l_next_approver.item_id;
7270: ELSIF l_next_approver.item_class =
7271: ame_util.costCenterItemClassName THEN
7272:

Line 7275: FROM AP_INVOICE_DISTRIBUTIONS_ALL

7271: ame_util.costCenterItemClassName THEN
7272:
7273: SELECT Invoice_Line_Number
7274: INTO l_line_num
7275: FROM AP_INVOICE_DISTRIBUTIONS_ALL
7276: WHERE project_id = l_next_approver.item_id;
7277: --distributions
7278: ELSIF l_next_approver.item_class <>
7279: ame_util.lineItemItemClassName

Line 7285: FROM AP_INVOICE_DISTRIBUTIONS_ALL

7281: ame_util.headerItemClassName THEN
7282:
7283: SELECT Invoice_Line_Number
7284: INTO l_line_num
7285: FROM AP_INVOICE_DISTRIBUTIONS_ALL
7286: WHERE invoice_distribution_id = l_next_approver.item_id;
7287:
7288: END IF; --l_class
7289: -- Bug 5590138. Modified table to AP_APPROVERS_LIST_GT

Line 7659: and exists( select 1 from ap_invoice_distributions_all aid

7655: END IF;
7656: update ap_invoice_lines_all ail
7657: set generate_dists = decode(ail.generate_dists, 'Y', 'D', ail.generate_dists)
7658: where ail.invoice_id = l_invoice_id
7659: and exists( select 1 from ap_invoice_distributions_all aid
7660: where aid.invoice_id = l_invoice_id
7661: and aid.invoice_line_number = ail.line_number) ;
7662:
7663: -- End bug 6845397