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.JAI_CMN_RGM_PROCESSING_PKG dependencies on JAI_AP_INVOICE_LINES

Line 1723: FROM jai_ap_invoice_lines

1719: AND line.match_type IS NOT NULL;
1720:
1721: CURSOR get_org_cur IS
1722: SELECT organization_id,location_id
1723: FROM jai_ap_invoice_lines
1724: WHERE invoice_id = p_invoice_id
1725: AND invoice_line_number = (SELECT parent_invoice_line_number
1726: FROM jai_ap_invoice_lines jail
1727: WHERE jail.invoice_line_number = p_invoice_line_number

Line 1726: FROM jai_ap_invoice_lines jail

1722: SELECT organization_id,location_id
1723: FROM jai_ap_invoice_lines
1724: WHERE invoice_id = p_invoice_id
1725: AND invoice_line_number = (SELECT parent_invoice_line_number
1726: FROM jai_ap_invoice_lines jail
1727: WHERE jail.invoice_line_number = p_invoice_line_number
1728: AND jail.invoice_id = p_invoice_id)
1729: AND parent_invoice_line_number IS NULL;
1730:

Line 1878: FROM jai_ap_invoice_lines

1874: and aid.org_id = p_org_id
1875: AND ( EXISTS
1876: (
1877: SELECT 1
1878: FROM jai_ap_invoice_lines
1879: WHERE organization_id = NVL(p_organization_id,organization_id)
1880: AND ai.invoice_id = invoice_id
1881: )
1882: OR EXISTS

Line 1949: from jai_ap_invoice_lines jail

1945: select aia.invoice_id
1946: from ap_invoices_all aia
1947: where --aia.source='Manual Invoice Entry' and/*commented by vkaranam for bug#12360337*/
1948: exists (select '1'
1949: from jai_ap_invoice_lines jail
1950: where aia.invoice_id = jail.invoice_id
1951: and jail.organization_id = p_organization_id)
1952: AND ((cp_start_date IS NULL AND aia.creation_date < cp_till_date)
1953: OR (cp_start_date IS NOT NULL AND trunc(aia.creation_date) between cp_start_date AND cp_till_date))

Line 2230: from ap_invoices_all aia , jai_ap_invoice_lines jail

2226: AND jrti.vendor_site_id = apc.vendor_site_id
2227: AND apc.org_id = p_org_id
2228: UNION --Added this union for bug#8943349 by JMEENA
2229: select aia.invoice_id
2230: from ap_invoices_all aia , jai_ap_invoice_lines jail
2231: where aia.invoice_id = jail.invoice_id
2232: -- and aia.source='Manual Invoice Entry' /*commented the condition by vkaranam for bug#12360337*/
2233: and jail.organization_id = p_organization_id
2234: )/*5694855*/

Line 2358: lv_interface_flag jai_ap_invoice_lines.interface_flag%type;

2354:
2355:
2356: --Added by zhiwei for POT change bug#13023443 on 20110930 begin
2357: -------------------------------------------------------------------------
2358: lv_interface_flag jai_ap_invoice_lines.interface_flag%type;
2359: lv_interface_event jai_ap_invoice_lines.interface_event%type;
2360: ln_regime_id number;
2361: -------------------------------------------------------------------------
2362: --Added by zhiwei for POT change bug#13023443 on 20110930 end

Line 2359: lv_interface_event jai_ap_invoice_lines.interface_event%type;

2355:
2356: --Added by zhiwei for POT change bug#13023443 on 20110930 begin
2357: -------------------------------------------------------------------------
2358: lv_interface_flag jai_ap_invoice_lines.interface_flag%type;
2359: lv_interface_event jai_ap_invoice_lines.interface_event%type;
2360: ln_regime_id number;
2361: -------------------------------------------------------------------------
2362: --Added by zhiwei for POT change bug#13023443 on 20110930 end
2363:

Line 2369: FROM jai_ap_invoice_lines

2365: ----------------------------------------------------------------------------------
2366: Cursor get_interface_info(cn_invoice_id number, cn_invoice_line_number number)
2367: IS
2368: SELECT organization_id,location_id,interface_flag,interface_event
2369: FROM jai_ap_invoice_lines
2370: WHERE invoice_id = cn_invoice_id
2371: AND invoice_line_number = (SELECT parent_invoice_line_number
2372: FROM jai_ap_invoice_lines jail
2373: WHERE jail.invoice_line_number = cn_invoice_line_number

Line 2372: FROM jai_ap_invoice_lines jail

2368: SELECT organization_id,location_id,interface_flag,interface_event
2369: FROM jai_ap_invoice_lines
2370: WHERE invoice_id = cn_invoice_id
2371: AND invoice_line_number = (SELECT parent_invoice_line_number
2372: FROM jai_ap_invoice_lines jail
2373: WHERE jail.invoice_line_number = cn_invoice_line_number
2374: AND jail.invoice_id = cn_invoice_id)
2375: AND parent_invoice_line_number IS NULL;
2376:

Line 2562: FROM jai_ap_invoice_lines

2558:
2559: /*
2560: SELECT organization_id,location_id,interface_flag,interface_event
2561: into l_organization_id,l_location_id,lv_interface_flag,lv_interface_event
2562: FROM jai_ap_invoice_lines
2563: WHERE invoice_id = ln_invoice_id
2564: AND invoice_line_number = (SELECT parent_invoice_line_number
2565: FROM jai_ap_invoice_lines jail
2566: WHERE jail.invoice_line_number = ln_invoice_line_number

Line 2565: FROM jai_ap_invoice_lines jail

2561: into l_organization_id,l_location_id,lv_interface_flag,lv_interface_event
2562: FROM jai_ap_invoice_lines
2563: WHERE invoice_id = ln_invoice_id
2564: AND invoice_line_number = (SELECT parent_invoice_line_number
2565: FROM jai_ap_invoice_lines jail
2566: WHERE jail.invoice_line_number = ln_invoice_line_number
2567: AND jail.invoice_id = ln_invoice_id)
2568: AND parent_invoice_line_number IS NULL;
2569: */--Commented by Zhiwei.Hou for Bug#13435283.

Line 4564: FROM jai_ap_invoice_lines

4560: AND SOURCE = 'AP';
4561:
4562: CURSOR get_loc_cur(pn_invoice_id NUMBER, pn_invoice_line_number NUMBER) IS
4563: SELECT location_id, service_type_code
4564: FROM jai_ap_invoice_lines
4565: WHERE invoice_id = pn_invoice_id
4566: AND invoice_line_number = (SELECT parent_invoice_line_number
4567: FROM jai_ap_invoice_lines jail
4568: WHERE jail.invoice_line_number = pn_invoice_line_number

Line 4567: FROM jai_ap_invoice_lines jail

4563: SELECT location_id, service_type_code
4564: FROM jai_ap_invoice_lines
4565: WHERE invoice_id = pn_invoice_id
4566: AND invoice_line_number = (SELECT parent_invoice_line_number
4567: FROM jai_ap_invoice_lines jail
4568: WHERE jail.invoice_line_number = pn_invoice_line_number
4569: AND jail.invoice_id = pn_invoice_id)
4570: AND parent_invoice_line_number IS NULL;
4571:

Line 4888: FROM jai_ap_invoice_lines

4884: ORDER BY 2;
4885:
4886: CURSOR get_service_type_code_cur(pn_invoice_id NUMBER, pn_invoice_line_number NUMBER) IS
4887: SELECT service_type_code
4888: FROM jai_ap_invoice_lines
4889: WHERE invoice_id = pn_invoice_id
4890: AND invoice_line_number = pn_invoice_line_number
4891: AND parent_invoice_line_number IS NULL;
4892: