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_PO_TAX_PKG dependencies on PO_HEADERS_ALL

Line 363: hdr_vendor_id PO_HEADERS_ALL.Vendor_Id%TYPE,

359: Curr JAI_PO_TAXES.CURRENCY%TYPE,
360: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
361: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
362: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE,
363: hdr_vendor_id PO_HEADERS_ALL.Vendor_Id%TYPE,
364: tax_vendor_id JAI_PO_TAXES.Vendor_Id%TYPE
365: );
366:
367:

Line 2032: , po_headers_all pha --Added by Kevin Cheng

2028: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
2029: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
2030: , pha.vendor_id hdr_vendor_id, A.Vendor_Id tax_vendor_id --Added by Kevin Cheng
2031: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B,jai_regime_tax_types_v aa
2032: , po_headers_all pha --Added by Kevin Cheng
2033: WHERE Po_Line_Id = p_line_id
2034: AND Line_Location_Id = p_line_loc_id
2035: --AND NVL( Line_Location_Id, -999 ) = p_line_loc_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
2036: AND A.Tax_Id = B.Tax_Id

Line 3112: ,p_rate PO_HEADERS_ALL.RATE%TYPE DEFAULT NULL

3108: p_Last_Update_Date date,
3109: p_Last_Updated_By number,
3110: p_Last_Update_Login number
3111: /* Brathod, For Bug# 4242351 */
3112: ,p_rate PO_HEADERS_ALL.RATE%TYPE DEFAULT NULL
3113: ,p_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL
3114: ,p_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL
3115: ,p_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
3116: /* End of Bug# 4242351 */

Line 3113: ,p_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL

3109: p_Last_Updated_By number,
3110: p_Last_Update_Login number
3111: /* Brathod, For Bug# 4242351 */
3112: ,p_rate PO_HEADERS_ALL.RATE%TYPE DEFAULT NULL
3113: ,p_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL
3114: ,p_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL
3115: ,p_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
3116: /* End of Bug# 4242351 */
3117: )

Line 3114: ,p_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL

3110: p_Last_Update_Login number
3111: /* Brathod, For Bug# 4242351 */
3112: ,p_rate PO_HEADERS_ALL.RATE%TYPE DEFAULT NULL
3113: ,p_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL
3114: ,p_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL
3115: ,p_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
3116: /* End of Bug# 4242351 */
3117: )
3118: IS

Line 3115: ,p_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL

3111: /* Brathod, For Bug# 4242351 */
3112: ,p_rate PO_HEADERS_ALL.RATE%TYPE DEFAULT NULL
3113: ,p_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL
3114: ,p_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL
3115: ,p_currency_code PO_HEADERS_ALL.CURRENCY_CODE%TYPE DEFAULT NULL
3116: /* End of Bug# 4242351 */
3117: )
3118: IS
3119: v_vendor_id NUMBER; --File.Sql.35 Cbabu := NVL( p_Vendor_Id, 0 );

Line 3221: Issue:- Cursor get_po_hdr having a select statement on table po_headers_all

3217: 2. 14/03/2005 bug#4250072 rallamse Version# 115.2
3218: Changes for VAT implementation
3219:
3220: 3. 31/03/2005 Brathod, Bug#4242351, Version 115.3
3221: Issue:- Cursor get_po_hdr having a select statement on table po_headers_all
3222: was raising mutating error.
3223: Solution:- Four new parameters are passed to the procedure
3224: to avoid select statement.
3225: 4. Kunkumar Added v_service_type_code and its manipulations for forward porting to R12.

Line 3589: FROM po_headers_all

3585: */
3586: ln_amount number; --Added by Shujuan for 10358786 on 28-Jan-2011
3587: CURSOR c_po_hdr_curr(p_po_header_id IN NUMBER) IS
3588: SELECT currency_code, org_id
3589: FROM po_headers_all
3590: WHERE po_header_id = p_po_header_id;
3591:
3592: /*cursor modified to use headers instead of lines as it is mutating in reqn triggers
3593: for bug#5877782*/

Line 3885: , po_headers_all pha --Added by Kevin Cheng

3881: B.rounding_factor rnd_factor,
3882: B.adhoc_flag adhoc_flag
3883: , pha.vendor_id hdr_vendor_id, a.vendor_id tax_vendor_id --Added by Kevin Cheng
3884: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B, jai_regime_tax_types_v aa
3885: , po_headers_all pha --Added by Kevin Cheng
3886: WHERE Po_Line_Id = p_po_line_id
3887: --AND nvl(line_location_id,-999) = p_line_location_id
3888: AND line_location_id = p_line_location_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
3889: AND A.Tax_Id = B.Tax_Id

Line 6539: from po_headers_all

6535:
6536:
6537: cursor fetch_vendor_id_cur IS
6538: select vendor_id,vendor_site_id
6539: from po_headers_all
6540: where po_header_id=p_po_hdr_id;
6541:
6542: --Added by kunkumar End
6543:

Line 6554: po_lines_all pla, po_headers_all pha

6550:
6551: CURSOR Fetch_Line_Loc_Id_Cur IS
6552: SELECT jpll.Line_Location_Id
6553: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,
6554: po_lines_all pla, po_headers_all pha
6555: WHERE pha.po_header_id = pla.po_header_id
6556: AND jpll.line_location_id = plla.line_location_id
6557: AND pha.po_header_id = plla.po_header_id
6558: AND pla.po_line_id = plla.po_line_id

Line 6567: FROM po_lines_all pla, po_headers_all pha

6563:
6564: -- Cursor definition for picking po_line_id from po_lines_all
6565: CURSOR fetch_line_id_cur IS
6566: SELECT pla.Po_Line_Id
6567: FROM po_lines_all pla, po_headers_all pha
6568: WHERE pha.Po_Header_Id = p_from_hdr_id
6569: AND pla.line_num = p_line_num -- Vijay Shankar for Bug# 3466223
6570: AND pha.po_header_id =pla.po_header_id;
6571:

Line 6941: FROM po_headers_all

6937: --Added by Ravi for vat assessable vlue
6938: CURSOR cur_vendor
6939: IS
6940: SELECT vendor_id,vendor_site_id
6941: FROM po_headers_all
6942: WHERE po_header_id = p_po_hdr_id;
6943:
6944: CURSOR cur_item
6945: IS

Line 7337: FROM Po_Headers_All

7333: AND Tax_Type <> jai_constants.tax_type_tds; --'TDS';
7334:
7335: CURSOR Get_Assessable_Val_Cur IS
7336: SELECT Vendor_Id, Vendor_Site_Id, Currency_Code
7337: FROM Po_Headers_All
7338: WHERE Po_Header_Id = v_po_hdr_id;
7339:
7340: CURSOR Get_Item_Id_Cur IS
7341: SELECT Item_Id

Line 7372: lv_curr PO_HEADERS_ALL.CURRENCY_CODE%TYPE ;

7368: lv_last_upd_by NUMBER;
7369: lv_last_upd_login NUMBER;
7370: lv_price NUMBER;
7371: lv_org_id NUMBER ;
7372: lv_curr PO_HEADERS_ALL.CURRENCY_CODE%TYPE ;
7373: lv_conv_rate number ;
7374: lv_type_lookup_code VARCHAR2(30);
7375: lv_quot_class_code VARCHAR2(30);
7376: lv_rate PO_HEADERS_ALL.RATE%TYPE ;

Line 7376: lv_rate PO_HEADERS_ALL.RATE%TYPE ;

7372: lv_curr PO_HEADERS_ALL.CURRENCY_CODE%TYPE ;
7373: lv_conv_rate number ;
7374: lv_type_lookup_code VARCHAR2(30);
7375: lv_quot_class_code VARCHAR2(30);
7376: lv_rate PO_HEADERS_ALL.RATE%TYPE ;
7377: lv_ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%type ;
7378:
7379: lv_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL ;
7380: lv_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL ;

Line 7377: lv_ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%type ;

7373: lv_conv_rate number ;
7374: lv_type_lookup_code VARCHAR2(30);
7375: lv_quot_class_code VARCHAR2(30);
7376: lv_rate PO_HEADERS_ALL.RATE%TYPE ;
7377: lv_ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%type ;
7378:
7379: lv_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL ;
7380: lv_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL ;
7381: lv_func_curr VARCHAR2(15);

Line 7379: lv_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL ;

7375: lv_quot_class_code VARCHAR2(30);
7376: lv_rate PO_HEADERS_ALL.RATE%TYPE ;
7377: lv_ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%type ;
7378:
7379: lv_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL ;
7380: lv_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL ;
7381: lv_func_curr VARCHAR2(15);
7382:
7383: flag1 VARCHAR2(10);

Line 7380: lv_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL ;

7376: lv_rate PO_HEADERS_ALL.RATE%TYPE ;
7377: lv_ship_to_location_id PO_HEADERS_ALL.ship_to_location_id%type ;
7378:
7379: lv_rate_type PO_HEADERS_ALL.RATE_TYPE%TYPE DEFAULT NULL ;
7380: lv_rate_date PO_HEADERS_ALL.RATE_DATE%TYPE DEFAULT NULL ;
7381: lv_func_curr VARCHAR2(15);
7382:
7383: flag1 VARCHAR2(10);
7384:

Line 7391: cursor fetch_vendor_id_cur(p_po_hdr_id po_headers_all.po_header_id%type ) IS

7387: FROM JAI_CMN_VENDOR_SITES
7388: WHERE vendor_id = c_vendor_id
7389: AND vendor_site_id = nvl(c_vendor_site_id,0) ;
7390:
7391: cursor fetch_vendor_id_cur(p_po_hdr_id po_headers_all.po_header_id%type ) IS
7392: select vendor_id,vendor_site_id , currency_code , rate ,RATE_TYPE , RATE_DATE ,ship_to_location_id
7393: from po_headers_all
7394: where po_header_id=p_po_hdr_id;
7395:

Line 7393: from po_headers_all

7389: AND vendor_site_id = nvl(c_vendor_site_id,0) ;
7390:
7391: cursor fetch_vendor_id_cur(p_po_hdr_id po_headers_all.po_header_id%type ) IS
7392: select vendor_id,vendor_site_id , currency_code , rate ,RATE_TYPE , RATE_DATE ,ship_to_location_id
7393: from po_headers_all
7394: where po_header_id=p_po_hdr_id;
7395:
7396: CURSOR Fetch_Dtls1_Cur( lineid IN NUMBER, linelocid IN NUMBER ) IS
7397: SELECT Price_Override ,Unit_Meas_Lookup_Code

Line 8695: FROM po_headers_all h

8691: lv_ship_to_loc_id NUMBER;
8692:
8693: CURSOR cur_ship_to_loc IS
8694: SELECT ship_to_location_id
8695: FROM po_headers_all h
8696: WHERE h.po_header_id = v_po_hdr_id;
8697: */
8698: --added by peng.zheng for bug 10043656, ends
8699: