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_FUNDS_CONTROL_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 591: ap_invoice_distributions_all D,

587: NULL, --status_code
588: 'N' self_assessed_flag --self_assessed_flag --bug7109594
589: FROM gl_period_statuses PER,
590: ap_invoices I,
591: ap_invoice_distributions_all D,
592: ap_invoice_lines L
593: WHERE D.invoice_id = I.invoice_id
594: AND D.invoice_line_number = L.line_number
595: AND L.invoice_id = D.invoice_id

Line 635: ap_invoice_distributions_all D,

631: NULL, --status_code
632: 'N' self_assessed_flag --self_assessed_flag --bug7109594
633: FROM gl_period_statuses PER,
634: ap_invoices I,
635: ap_invoice_distributions_all D,
636: ap_invoice_lines L,
637: po_distributions_all pod
638: WHERE D.invoice_id = I.invoice_id
639: AND D.invoice_line_number = L.line_number

Line 671: ap_invoice_distributions_all ainvd,

667: AND D.po_distribution_id = pod.po_distribution_id
668: AND NOT EXISTS ( select 'Advance Exists'
669: from po_distributions_all pod,
670: po_headers_all poh,
671: ap_invoice_distributions_all ainvd,
672: ap_invoices_all ainv,
673: po_doc_style_headers pdsa
674: where pod.po_distribution_id = D.po_distribution_id
675: and poh.po_header_id = pod.po_header_id

Line 767: ap_invoice_distributions_all ainvd,

763: AND T.po_distribution_id is NOT NULL
764: AND NOT EXISTS ( select 'Advance Exists'
765: from po_distributions_all pod,
766: po_headers_all poh,
767: ap_invoice_distributions_all ainvd,
768: ap_invoices_all ainv,
769: po_doc_style_headers pdsa
770: where pod.po_distribution_id = T.po_distribution_id
771: and poh.po_header_id = pod.po_header_id

Line 1133: UPDATE ap_invoice_distributions

1129: -- at the suggestion of the PSA team.
1130:
1131: --Bug7153696 modified the below update to catter the self accessed tax invoices
1132: /*
1133: UPDATE ap_invoice_distributions
1134: SET encumbered_flag = 'Y'
1135: WHERE invoice_distribution_id =
1136: t_funds_dist_tab(i).inv_distribution_id
1137: AND bc_event_id is not null ;*/

Line 1140: UPDATE ap_invoice_distributions_all

1136: t_funds_dist_tab(i).inv_distribution_id
1137: AND bc_event_id is not null ;*/
1138: IF nvl(t_funds_dist_tab(i).SELF_ASSESSED_FLAG , 'N') = 'N' THEN
1139:
1140: UPDATE ap_invoice_distributions_all
1141: SET encumbered_flag = 'Y'
1142: WHERE invoice_distribution_id =
1143: t_funds_dist_tab(i).inv_distribution_id
1144: AND bc_event_id is not null ;

Line 1198: UPDATE ap_invoice_distributions

1194: -- at the suggestion of the PSA team.
1195:
1196: --Bug7153696 modified the below update to catter the self accessed tax invoices
1197: /*
1198: UPDATE ap_invoice_distributions
1199: SET encumbered_flag = 'Y'
1200: WHERE invoice_distribution_id =
1201: t_funds_dist_tab(i).inv_distribution_id
1202: AND bc_event_id is not null ;*/

Line 1205: UPDATE ap_invoice_distributions_all

1201: t_funds_dist_tab(i).inv_distribution_id
1202: AND bc_event_id is not null ;*/
1203: IF nvl(t_funds_dist_tab(i).SELF_ASSESSED_FLAG , 'N') = 'N' THEN
1204:
1205: UPDATE ap_invoice_distributions_all
1206: SET encumbered_flag = 'Y'
1207: WHERE invoice_distribution_id =
1208: t_funds_dist_tab(i).inv_distribution_id
1209: AND bc_event_id is not null ;

Line 1438: FROM ap_invoice_distributions D

1434:
1435: BEGIN
1436: SELECT D.dist_code_combination_id
1437: INTO p_erv_ccid
1438: FROM ap_invoice_distributions D
1439: WHERE D.related_id = p_related_id
1440: AND D.line_type_lookup_code = 'ERV';
1441: EXCEPTION
1442: WHEN NO_DATA_FOUND THEN

Line 1754: from ap_invoice_distributions d,

1750: l_new_qty_var,
1751: l_new_base_qty_var,
1752: l_unapproved_qty,
1753: l_unapproved_amt
1754: from ap_invoice_distributions d,
1755: po_distributions pd,
1756: po_line_locations poll
1757: where pd.po_distribution_id = d.po_distribution_id
1758: and d.po_distribution_id = p_po_dist_id

Line 1827: from ap_invoice_distributions

1823: select nvl(distribution_line_number,0),
1824: nvl(invoice_line_number,0)
1825: into p_update_dist_num,
1826: p_update_line_num
1827: from ap_invoice_distributions
1828: where (invoice_line_number, distribution_line_number) =
1829: (select nvl(min(invoice_line_number),0), nvl(min(distribution_line_number),0)
1830: from ap_invoice_distributions
1831: where invoice_id = p_invoice_id

Line 1830: from ap_invoice_distributions

1826: p_update_line_num
1827: from ap_invoice_distributions
1828: where (invoice_line_number, distribution_line_number) =
1829: (select nvl(min(invoice_line_number),0), nvl(min(distribution_line_number),0)
1830: from ap_invoice_distributions
1831: where invoice_id = p_invoice_id
1832: and po_distribution_id = p_po_dist_id
1833: and nvl(encumbered_flag,'N') in ('N','H','P')
1834: and (match_status_flag is null or

Line 1838: from ap_invoice_distributions

1834: and (match_status_flag is null or
1835: match_status_flag <> 'A')
1836: and quantity_invoiced =
1837: (select min(quantity_invoiced)
1838: from ap_invoice_distributions
1839: where invoice_id = p_invoice_id
1840: and po_distribution_id = p_po_dist_id
1841: and nvl(encumbered_flag,'N') in ('N','H','P')
1842: and (match_status_flag is null or

Line 1863: from ap_invoice_distributions

1859: select nvl(distribution_line_number,0),
1860: invoice_line_number
1861: into p_update_dist_num,
1862: p_update_line_num
1863: from ap_invoice_distributions
1864: where (invoice_line_number, distribution_line_number) =
1865: (select nvl(min(invoice_line_number),0), nvl(min(distribution_line_number),0)
1866: from ap_invoice_distributions
1867: where invoice_id = p_invoice_id

Line 1866: from ap_invoice_distributions

1862: p_update_line_num
1863: from ap_invoice_distributions
1864: where (invoice_line_number, distribution_line_number) =
1865: (select nvl(min(invoice_line_number),0), nvl(min(distribution_line_number),0)
1866: from ap_invoice_distributions
1867: where invoice_id = p_invoice_id
1868: and po_distribution_id = p_po_dist_id
1869: and nvl(encumbered_flag,'N') in ('N','H','P')
1870: and (match_status_flag is null or

Line 1874: from ap_invoice_distributions

1870: and (match_status_flag is null or
1871: match_status_flag <> 'A')
1872: and quantity_invoiced =
1873: (select max(quantity_invoiced)
1874: from ap_invoice_distributions
1875: where invoice_id = p_invoice_id
1876: and po_distribution_id = p_po_dist_id
1877: and nvl(encumbered_flag,'N') in ('N','H','P')
1878: and (match_status_flag is null or

Line 2058: from ap_invoice_distributions d,

2054: l_old_base_amt_var,
2055: l_new_amt_var,
2056: l_new_base_amt_var,
2057: l_unapproved_amt
2058: from ap_invoice_distributions d,
2059: po_distributions pd,
2060: po_line_locations poll
2061: where pd.po_distribution_id = d.po_distribution_id
2062: and d.po_distribution_id = p_po_dist_id

Line 2127: from ap_invoice_distributions

2123: select nvl(distribution_line_number,0),
2124: nvl(invoice_line_number,0)
2125: into p_update_dist_num,
2126: p_update_line_num
2127: from ap_invoice_distributions
2128: where (invoice_line_number, distribution_line_number) =
2129: (select nvl(min(invoice_line_number),0), nvl(min(distribution_line_number),0)
2130: from ap_invoice_distributions
2131: where invoice_id = p_invoice_id

Line 2130: from ap_invoice_distributions

2126: p_update_line_num
2127: from ap_invoice_distributions
2128: where (invoice_line_number, distribution_line_number) =
2129: (select nvl(min(invoice_line_number),0), nvl(min(distribution_line_number),0)
2130: from ap_invoice_distributions
2131: where invoice_id = p_invoice_id
2132: and po_distribution_id = p_po_dist_id
2133: and nvl(encumbered_flag,'N') in ('N','H','P')
2134: and (match_status_flag is null or

Line 2138: from ap_invoice_distributions

2134: and (match_status_flag is null or
2135: match_status_flag <> 'A')
2136: and amount =
2137: (select min(amount)
2138: from ap_invoice_distributions
2139: where invoice_id = p_invoice_id
2140: and po_distribution_id = p_po_dist_id
2141: and nvl(encumbered_flag,'N') in ('N','H','P')
2142: and (match_status_flag is null or

Line 2163: from ap_invoice_distributions

2159: select nvl(distribution_line_number,0),
2160: invoice_line_number
2161: into p_update_dist_num,
2162: p_update_line_num
2163: from ap_invoice_distributions
2164: where (invoice_line_number, distribution_line_number) =
2165: (select nvl(min(invoice_line_number),0), nvl(min(distribution_line_number),0)
2166: from ap_invoice_distributions
2167: where invoice_id = p_invoice_id

Line 2166: from ap_invoice_distributions

2162: p_update_line_num
2163: from ap_invoice_distributions
2164: where (invoice_line_number, distribution_line_number) =
2165: (select nvl(min(invoice_line_number),0), nvl(min(distribution_line_number),0)
2166: from ap_invoice_distributions
2167: where invoice_id = p_invoice_id
2168: and po_distribution_id = p_po_dist_id
2169: and nvl(encumbered_flag,'N') in ('N','H','P')
2170: and (match_status_flag is null or

Line 2174: from ap_invoice_distributions

2170: and (match_status_flag is null or
2171: match_status_flag <> 'A')
2172: and amount =
2173: (select max(amount)
2174: from ap_invoice_distributions
2175: where invoice_id = p_invoice_id
2176: and po_distribution_id = p_po_dist_id
2177: and nvl(encumbered_flag,'N') in ('N','H','P')
2178: and (match_status_flag is null or

Line 2269: FROM ap_invoice_distributions_all aid,

2265: AID.org_id, -- org_id
2266: NULL, --result_code
2267: NULL, --status_code
2268: 'N' self_assessed_flag --self_assessed_flag --bug7109594
2269: FROM ap_invoice_distributions_all aid,
2270: ap_invoices_all ai,
2271: ap_invoice_lines_all ail,
2272: gl_period_statuses per
2273: WHERE ai.invoice_id = p_invoice_id

Line 2307: FROM ap_invoice_distributions_all aid,

2303: AID.org_id, -- org_id
2304: NULL, -- result_code
2305: NULL, -- status_code
2306: 'N' self_assessed_flag -- self_assessed_flag --bug7109594
2307: FROM ap_invoice_distributions_all aid,
2308: ap_invoices_all ai,
2309: ap_invoice_lines_all ail,
2310: gl_period_statuses per,
2311: po_distributions_all pod

Line 2339: ap_invoice_distributions_all ainvd,

2335: AND aid.po_distribution_id = pod.po_distribution_id
2336: AND NOT EXISTS ( select 'Advance Exists'
2337: from po_distributions_all pod,
2338: po_headers_all poh,
2339: ap_invoice_distributions_all ainvd,
2340: ap_invoices_all ainv,
2341: po_doc_style_headers pdsa
2342: where pod.po_distribution_id = aid.po_distribution_id
2343: and poh.po_header_id = pod.po_header_id

Line 2423: ap_invoice_distributions_all ainvd,

2419: AND t.po_distribution_id is NOT NULL
2420: AND NOT EXISTS ( select 'Advance Exists'
2421: from po_distributions_all pod,
2422: po_headers_all poh,
2423: ap_invoice_distributions_all ainvd,
2424: ap_invoices_all ainv,
2425: po_doc_style_headers pdsa
2426: where pod.po_distribution_id = t.po_distribution_id
2427: and poh.po_header_id = pod.po_header_id