APPS.ASO_TAX_INT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 47

	SELECT tax_code from AR_VAT_TAX
	WHERE vat_tax_id = c_tax_id;

Line: 93

    IF p_tax_control_rec.update_DB = 'Y' THEN

    IF  p_tax_control_rec.tax_level = 'SHIPPING' THEN
    DELETE FROM aso_tax_details
	WHERE quote_shipment_id = p_tax_detail_rec.quote_shipment_id and
        quote_line_id = p_tax_detail_rec.quote_line_id and
	quote_header_id = p_tax_detail_rec.quote_header_id;

Line: 103

    DELETE FROM aso_tax_details
	WHERE quote_header_id = p_tax_detail_rec.quote_header_id AND
    quote_line_id = p_tax_detail_rec.quote_line_id;

Line: 111

        ASO_TAX_DETAILS_PKG.Insert_Row(
            px_TAX_DETAIL_ID  => x_tax_detail_tbl(i).TAX_DETAIL_ID,
            p_CREATION_DATE  => SYSDATE,
            p_CREATED_BY  => G_USER_ID,
            p_LAST_UPDATE_DATE  => SYSDATE,
            p_LAST_UPDATED_BY  => G_USER_ID,
            p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
            p_REQUEST_ID  => l_tax_detail_rec.REQUEST_ID,
            p_PROGRAM_APPLICATION_ID  => l_tax_detail_rec.PROGRAM_APPLICATION_ID,
            p_PROGRAM_ID  => l_tax_detail_rec.PROGRAM_ID,
            p_PROGRAM_UPDATE_DATE  => l_tax_detail_rec.PROGRAM_UPDATE_DATE,
            p_QUOTE_HEADER_ID  => p_tax_detail_rec.quote_header_id,
            p_QUOTE_LINE_ID  => l_tax_detail_rec.QUOTE_LINE_ID,
            p_QUOTE_SHIPMENT_ID  => l_tax_detail_rec.QUOTE_SHIPMENT_ID,
            p_ORIG_TAX_CODE  => l_tax_detail_rec.ORIG_TAX_CODE,
            p_TAX_CODE  => l_tax_detail_rec.TAX_CODE,
            p_TAX_RATE  => l_tax_detail_rec.TAX_RATE,
            p_TAX_DATE  => l_tax_detail_rec.TAX_DATE,
            p_TAX_AMOUNT  => l_tax_detail_rec.TAX_AMOUNT,
            p_TAX_EXEMPT_FLAG  => l_tax_detail_rec.TAX_EXEMPT_FLAG,
            p_TAX_EXEMPT_NUMBER  => l_tax_detail_rec.TAX_EXEMPT_NUMBER,
            p_TAX_EXEMPT_REASON_CODE  => l_tax_detail_rec.TAX_EXEMPT_REASON_CODE,
            p_ATTRIBUTE_CATEGORY  => l_tax_detail_rec.ATTRIBUTE_CATEGORY,
            p_ATTRIBUTE1  => l_tax_detail_rec.ATTRIBUTE1,
            p_ATTRIBUTE2  => l_tax_detail_rec.ATTRIBUTE2,
            p_ATTRIBUTE3  => l_tax_detail_rec.ATTRIBUTE3,
            p_ATTRIBUTE4  => l_tax_detail_rec.ATTRIBUTE4,
            p_ATTRIBUTE5  => l_tax_detail_rec.ATTRIBUTE5,
            p_ATTRIBUTE6  => l_tax_detail_rec.ATTRIBUTE6,
            p_ATTRIBUTE7  => l_tax_detail_rec.ATTRIBUTE7,
            p_ATTRIBUTE8  => l_tax_detail_rec.ATTRIBUTE8,
            p_ATTRIBUTE9  => l_tax_detail_rec.ATTRIBUTE9,
            p_ATTRIBUTE10  => l_tax_detail_rec.ATTRIBUTE10,
            p_ATTRIBUTE11  => l_tax_detail_rec.ATTRIBUTE11,
            p_ATTRIBUTE12  => l_tax_detail_rec.ATTRIBUTE12,
            p_ATTRIBUTE13  => l_tax_detail_rec.ATTRIBUTE13,
            p_ATTRIBUTE14  => l_tax_detail_rec.ATTRIBUTE14,
            p_ATTRIBUTE15  => l_tax_detail_rec.ATTRIBUTE15,
            p_ATTRIBUTE16  => l_tax_detail_rec.ATTRIBUTE16,
		  p_ATTRIBUTE17  => l_tax_detail_rec.ATTRIBUTE17,
		  p_ATTRIBUTE18  => l_tax_detail_rec.ATTRIBUTE18,
		  p_ATTRIBUTE19  => l_tax_detail_rec.ATTRIBUTE19,
		  p_ATTRIBUTE20  => l_tax_detail_rec.ATTRIBUTE20,
		  p_TAX_INCLUSIVE_FLAG  => l_tax_detail_rec.TAX_INCLUSIVE_FLAG,
		  p_OBJECT_VERSION_NUMBER => l_tax_detail_rec.OBJECT_VERSION_NUMBER,
		  p_TAX_RATE_ID => l_tax_detail_rec.TAX_RATE_ID
		  );

Line: 216

  select quote_line_id, shipment_id
  from aso_shipments
  where quote_header_id = l_quote_header_id;

Line: 238

CURSOR c_hd_tax(qt_hdr_id NUMBER,q_ship_id NUMBER) IS SELECT tax_exempt_flag,tax_exempt_number,tax_exempt_reason_code
FROM
aso_tax_details WHERE quote_header_id= qt_hdr_id
and quote_shipment_id= q_ship_id and quote_line_id IS NULL;

Line: 243

CURSOR c_tax_line(qt_hdr_id NUMBER,q_line_id NUMBER,q_ship_id NUMBER) IS SELECT tax_exempt_flag,tax_exempt_number,tax_exempt_reason_code FROM
aso_tax_details WHERE quote_header_id= qt_hdr_id
and quote_shipment_id= q_ship_id and quote_line_id = q_line_id;

Line: 308

      		-- Insert into tax details
               		ASO_TAX_DETAILS_PKG.Insert_Row(
            		px_TAX_DETAIL_ID  => l_tax_detail_tbl(j).TAX_DETAIL_ID,
            		p_CREATION_DATE  => SYSDATE,
            		p_CREATED_BY  => G_USER_ID,
            		p_LAST_UPDATE_DATE  => SYSDATE,
            		p_LAST_UPDATED_BY  => G_USER_ID,
            		p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
            		p_REQUEST_ID  => l_tax_detail_tbl(j).REQUEST_ID,
            		p_PROGRAM_APPLICATION_ID  => l_tax_detail_tbl(j).PROGRAM_APPLICATION_ID,
            		p_PROGRAM_ID  => l_tax_detail_tbl(j).PROGRAM_ID,
            		p_PROGRAM_UPDATE_DATE  => l_tax_detail_tbl(j).PROGRAM_UPDATE_DATE,
            		p_QUOTE_HEADER_ID  => l_tax_detail_tbl(j).quote_header_id,
            		p_QUOTE_LINE_ID  => l_tax_detail_tbl(j).QUOTE_LINE_ID,
            		p_QUOTE_SHIPMENT_ID  => l_tax_detail_tbl(j).QUOTE_SHIPMENT_ID,
            		p_ORIG_TAX_CODE  => l_tax_detail_tbl(j).ORIG_TAX_CODE,
            		p_TAX_CODE  => l_tax_detail_tbl(j).TAX_CODE,
            		p_TAX_RATE  => l_tax_detail_tbl(j).TAX_RATE,
            		p_TAX_DATE  => l_sys_date,--l_tax_detail_tbl(j).TAX_DATE,
            		p_TAX_AMOUNT  => l_tax_detail_tbl(j).TAX_AMOUNT,
            		p_TAX_EXEMPT_FLAG  => l_hd_EXEMPT_FLAG,
            		p_TAX_EXEMPT_NUMBER  => l_hd_exempt_number ,
            		p_TAX_EXEMPT_REASON_CODE  => l_hd_exempt_reason_code ,
            		p_ATTRIBUTE_CATEGORY  => l_tax_detail_tbl(j).ATTRIBUTE_CATEGORY,
            		p_ATTRIBUTE1  => l_tax_detail_tbl(j).ATTRIBUTE1,
            		p_ATTRIBUTE2  => l_tax_detail_tbl(j).ATTRIBUTE2,
            		p_ATTRIBUTE3  => l_tax_detail_tbl(j).ATTRIBUTE3,
            		p_ATTRIBUTE4  => l_tax_detail_tbl(j).ATTRIBUTE4,
            		p_ATTRIBUTE5  => l_tax_detail_tbl(j).ATTRIBUTE5,
            		p_ATTRIBUTE6  => l_tax_detail_tbl(j).ATTRIBUTE6,
            		p_ATTRIBUTE7  => l_tax_detail_tbl(j).ATTRIBUTE7,
            		p_ATTRIBUTE8  => l_tax_detail_tbl(j).ATTRIBUTE8,
            		p_ATTRIBUTE9  => l_tax_detail_tbl(j).ATTRIBUTE9,
            		p_ATTRIBUTE10  => l_tax_detail_tbl(j).ATTRIBUTE10,
            		p_ATTRIBUTE11  => l_tax_detail_tbl(j).ATTRIBUTE11,
            		p_ATTRIBUTE12  => l_tax_detail_tbl(j).ATTRIBUTE12,
            		p_ATTRIBUTE13  => l_tax_detail_tbl(j).ATTRIBUTE13,
            		p_ATTRIBUTE14  => l_tax_detail_tbl(j).ATTRIBUTE14,
            		p_ATTRIBUTE15  => l_tax_detail_tbl(j).ATTRIBUTE15,
                    p_ATTRIBUTE16  => l_tax_detail_tbl(j).ATTRIBUTE16,
                    p_ATTRIBUTE17  => l_tax_detail_tbl(j).ATTRIBUTE17,
                    p_ATTRIBUTE18  => l_tax_detail_tbl(j).ATTRIBUTE18,
                    p_ATTRIBUTE19  => l_tax_detail_tbl(j).ATTRIBUTE19,
                    p_ATTRIBUTE20  => l_tax_detail_tbl(j).ATTRIBUTE20,
				p_TAX_INCLUSIVE_FLAG  => l_tax_detail_tbl(j).TAX_INCLUSIVE_FLAG,
				p_OBJECT_VERSION_NUMBER => l_tax_detail_tbl(j).OBJECT_VERSION_NUMBER,
				p_TAX_RATE_ID => l_tax_detail_tbl(j).TAX_RATE_ID
				);

Line: 358

                        aso_debug_pub.add('Inside line  tax detail after insert ',1,'Y');

Line: 365

			    aso_debug_pub.add('Inside line  tax detail before update ',1,'Y');

Line: 368

        		UPDATE ASO_TAX_DETAILS
        		SET tax_exempt_flag        = l_hd_exempt_flag ,
			    tax_exempt_number      = l_hd_exempt_number,
			    tax_exempt_reason_code = l_hd_exempt_reason_code,
                   last_update_date       = sysdate,
                   last_updated_by        = fnd_global.user_id,
                   last_update_login      = fnd_global.conc_login_id,
			    tax_date 			  = l_sys_date
        		WHERE quote_header_id   = c_header_id
                 and quote_line_id     = c_line_id
        		  and quote_shipment_id = c_shipment_id;

Line: 383

		    aso_debug_pub.add('Inside line  tax detail after update ',1,'Y');

Line: 725

select s_ship.site_use_id,
       s_ship.cust_acct_site_id,
       acct_site_ship.cust_account_id,
       loc_ship.postal_code,
       loc_assign_ship.loc_id,
       cust_acct.party_id,
       cust_acct.account_number,
       cust_acct.tax_header_level_flag,
       cust_acct.tax_rounding_rule,
       loc_ship.state,
       s_ship.tax_header_level_flag,
       s_ship.tax_rounding_rule
FROM
       hz_cust_site_uses_all       s_ship ,
       hz_cust_acct_sites          acct_site_ship,
       hz_party_sites              party_site_ship,
       hz_locations                loc_ship,
       hz_loc_assignments          loc_assign_ship,
       hz_cust_accounts            cust_acct
WHERE  s_ship.site_use_id              =  l_site_use_id
  and  s_ship.cust_acct_site_id        =  acct_site_ship.cust_acct_site_id
  and  acct_site_ship.cust_account_id  =  cust_acct.cust_account_id
  and  acct_site_ship.party_site_id    =  party_site_ship.party_site_id
  and  party_site_ship.location_id     =  loc_ship.location_id
  and  acct_site_ship.org_id = loc_assign_ship.org_id ;  -- New code Yogeshwar (MOAC)

Line: 760

    select  sl.postal_code, sla.loc_id, sl.location_id
    from    hz_party_sites  sps,
            hz_locations sl,
            hz_loc_assignments sla
    where   sps.party_site_id = l_party_site_id
            and SPS.location_id = SL.location_id
            and sl.location_id = sla.location_id ;

Line: 773

    select minimum_accountable_unit,precision
    from   fnd_currencies
    where  currency_code = l_currency_code;

Line: 778

    select  person_id,sales_tax_geocode,sales_tax_inside_city_limits, salesrep_id
   -- from    jtf_rs_srp_vl  Commented code Yogeshwar (MOAC)
    from JTF_RS_SALESREPS_MO_V --New Code Yogeshwar (MOAC)
    where   resource_id=c_resource_id ;

Line: 789

    select  organization_id
    from    per_all_assignments_f
    where   person_id = c_person_id
            and  nvl(primary_flag, 'Y') = 'Y'
            and  sysdate  between nvl(effective_start_date,to_date( '01011900', 'DDMMYYYY'))
                                and nvl(effective_end_date,to_date( '31122199', 'DDMMYYYY'));

Line: 798

select tax_code
from  ar_vat_tax
where vat_tax_id = c_tax_id;

Line: 803

select party_name
from   hz_parties
where  party_id = p_party_id;

Line: 808

select global_attribute1, global_attribute2
from mtl_system_items_b
where inventory_item_id = p_inventory_item_id
and   organization_id   = p_organization_id;

Line: 889

            select  tax_rounding_allow_override,
                    tax_header_level_flag,
                    tax_rounding_rule,
                    set_of_books_id
            into    l_tax_rounding_allow_override,
                    l_tax_header_level_flag,
                    l_tax_rounding_rule,
                    l_set_of_books_id
            from    ar_system_parameters;

Line: 907

                    l_reason := 'No Data Found while selecting tax_rounding_rule, set_of_books_id';

Line: 917

            aso_debug_pub.add('ASO_TAX_LINE: After selecting from AR_SYSTEM_PARAMETERS table.', 1, 'Y');

Line: 1074

                aso_debug_pub.add('Before selecting cust_trx_type_id from ra_cust_trx_types_all table', 1, 'Y');

Line: 1084

                select cust_trx_type_id
                into l_ra_cust_trx_type_id
                --from ra_cust_trx_types_all Commented Code yogeshwar (MOAC)
		from ra_cust_trx_types  --New Code Yogeshwar (MOAC)
                where cust_trx_type_id = l_trx_type_id
                   --Commented Code Start Yogeshwar (MOAC)
--		   and nvl(org_id,
--                       nvl(to_number(decode(substrb(userenv('CLIENT_INFO'),1 ,1), ' ',null,
--                       substrb(userenv('CLIENT_INFO'), 1,10))),-99)) =
--                       nvl(l_qte_header_rec.org_id,
--                       nvl(to_number(decode( substrb(userenv('CLIENT_INFO'),1,1), ' ',null,
--                       substrb(userenv('CLIENT_INFO'),1,10))), -99))
		   --Commented Code End Yogeshwar (MOAC)
                   and ((tax_calculation_flag = 'Y')
                   or  (l_hdr_tax_exempt_flag='R' ) );

Line: 1105

    			            aso_debug_pub.add('ASO_TAX_LINE: NO_DATA_FOUND when selecting cust_trx_type_id', 1, 'Y');

Line: 1108

			        l_reason := 'No Data Found Exception raised while selecting cust_trx_type_id';

Line: 1126

                           delete from aso_tax_details
			            where quote_header_id  = l_tax_detail_tbl(1).quote_header_id
                           and quote_line_id = l_tax_detail_tbl(1).quote_line_id ;

Line: 1721

                     select oe.transaction_type_id
                     into l_om_trx_type_id
                     --from ra_cust_trx_types_all ra Commented Code Yogeshwar (MOAC)
		     from ra_cust_trx_types ra, --New Code Yogeshwar (MOAC)
                          oe_transaction_types_vl oe
                     where ra.cust_trx_type_id = l_trx_type_id
                     and ra.cust_trx_type_id = oe.cust_trx_type_id
		     and oe.transaction_type_id = nvl(l_qte_line_tbl(i).order_line_type_id, l_qte_header_rec.order_type_id)
                     --Commented code start Yogeshwar(MOAC)
--		        and nvl(ra.org_id,
--                         nvl(to_number(decode(substrb(userenv('CLIENT_INFO'),1 ,1), ' ',null,
--                         substrb(userenv('CLIENT_INFO'), 1,10))),-99)) =
--                         nvl(l_qte_header_rec.org_id,
--                         nvl(to_number(decode( substrb(userenv('CLIENT_INFO'),1,1), ' ',null,
--                         substrb(userenv('CLIENT_INFO'),1,10))), -99))
                     --End of commented code  Yogeshwar (MOAC)

                     and (( tax_calculation_flag = 'Y' ) or ( l_hdr_tax_exempt_flag='R' ))
		     and ra.org_id = l_qte_header_rec.org_id ; --New Code Yogeshwar (MOAC)

Line: 1748

    			                  aso_debug_pub.add('ASO_TAX_LINE: NO_DATA_FOUND when selecting transaction_type_id', 1, 'Y');

Line: 1751

			               l_reason := 'No Data Found Exception when selecting transaction_type_id from ';

Line: 1769

                                 delete from aso_tax_details
			                  where quote_header_id  = l_tax_detail_tbl(1).quote_header_id
                                 and quote_line_id = l_tax_detail_tbl(1).quote_line_id ;

Line: 2045

                IF p_tax_control_rec.update_db = 'Y' THEN

                    IF aso_debug_pub.g_debug_flag = 'Y' THEN
                       aso_debug_pub.add('ASO_TAX_LINE: Deleting tax records inside first IF before 2nd IF', 1, 'Y');

Line: 2060

   				    DELETE FROM aso_tax_details
				    WHERE quote_shipment_id = l_tax_detail_tbl(1).quote_shipment_id
				    and quote_line_id   = l_qte_line_tbl(i).quote_line_id
				    and quote_header_id = l_tax_detail_tbl(1).quote_header_id;

Line: 2073

    				    DELETE FROM aso_tax_details
				    WHERE quote_header_id = l_qte_line_tbl(i).quote_header_id
				    and quote_line_id = l_qte_line_tbl(i).quote_line_id;

Line: 2080

                       aso_debug_pub.add('Before calling aso_tax_details_pkg.insert_row in loop', 1, 'Y');

Line: 2096

        	    	        ASO_TAX_DETAILS_PKG.Insert_Row(
            		          px_TAX_DETAIL_ID  => x_tax_detail_tbl(i).TAX_DETAIL_ID,
            		          p_CREATION_DATE  => SYSDATE,
            		          p_CREATED_BY  => G_USER_ID,
            		          p_LAST_UPDATE_DATE  => SYSDATE,
            		          p_LAST_UPDATED_BY  => G_USER_ID,
            		          p_LAST_UPDATE_LOGIN  => G_LOGIN_ID,
            		          p_REQUEST_ID  => x_tax_detail_tbl(i).REQUEST_ID,
            		          p_PROGRAM_APPLICATION_ID  =>  x_tax_detail_tbl(i).PROGRAM_APPLICATION_ID,
            		          p_PROGRAM_ID  =>  x_tax_detail_tbl(i).PROGRAM_ID,
            		          p_PROGRAM_UPDATE_DATE  =>  x_tax_detail_tbl(i).PROGRAM_UPDATE_DATE,
            		          p_QUOTE_HEADER_ID  => x_tax_detail_tbl(i).quote_header_id,
            		          p_QUOTE_LINE_ID  =>  x_tax_detail_tbl(i).QUOTE_LINE_ID,
            		          p_QUOTE_SHIPMENT_ID  =>  x_tax_detail_tbl(i).QUOTE_SHIPMENT_ID,
            		          p_ORIG_TAX_CODE  =>  x_tax_detail_tbl(i).ORIG_TAX_CODE,
            		          p_TAX_CODE  => x_tax_detail_tbl(i).TAX_CODE,
            		          p_TAX_RATE  => x_tax_detail_tbl(i).TAX_RATE,
            		          p_TAX_DATE  => l_sys_date,--x_tax_detail_tbl(i).TAX_DATE,
            		          p_TAX_AMOUNT  => x_tax_detail_tbl(i).TAX_AMOUNT,
            		          p_TAX_EXEMPT_FLAG  => x_tax_detail_tbl(i).TAX_EXEMPT_FLAG,
            		          p_TAX_EXEMPT_NUMBER  => x_tax_detail_tbl(i).TAX_EXEMPT_NUMBER,
            		          p_TAX_EXEMPT_REASON_CODE  => x_tax_detail_tbl(i).TAX_EXEMPT_REASON_CODE,
            		          p_ATTRIBUTE_CATEGORY  => x_tax_detail_tbl(i).ATTRIBUTE_CATEGORY,
            		          p_ATTRIBUTE1  => x_tax_detail_tbl(i).ATTRIBUTE1,
            		          p_ATTRIBUTE2  => x_tax_detail_tbl(i).ATTRIBUTE2,
            		          p_ATTRIBUTE3  => x_tax_detail_tbl(i).ATTRIBUTE3,
            		          p_ATTRIBUTE4  => x_tax_detail_tbl(i).ATTRIBUTE4,
            		          p_ATTRIBUTE5  => x_tax_detail_tbl(i).ATTRIBUTE5,
            		          p_ATTRIBUTE6  => x_tax_detail_tbl(i).ATTRIBUTE6,
            		          p_ATTRIBUTE7  => x_tax_detail_tbl(i).ATTRIBUTE7,
            		          p_ATTRIBUTE8  => x_tax_detail_tbl(i).ATTRIBUTE8,
            		          p_ATTRIBUTE9  => x_tax_detail_tbl(i).ATTRIBUTE9,
            		          p_ATTRIBUTE10  => x_tax_detail_tbl(i).ATTRIBUTE10,
            		          p_ATTRIBUTE11  => x_tax_detail_tbl(i).ATTRIBUTE11,
            		          p_ATTRIBUTE12  => x_tax_detail_tbl(i).ATTRIBUTE12,
            		          p_ATTRIBUTE13  => x_tax_detail_tbl(i).ATTRIBUTE13,
            		          p_ATTRIBUTE14  => x_tax_detail_tbl(i).ATTRIBUTE14,
            		          p_ATTRIBUTE15  => x_tax_detail_tbl(i).ATTRIBUTE15,
            		          p_ATTRIBUTE16  => l_tax_detail_tbl(i).ATTRIBUTE16,
                              p_ATTRIBUTE17  => l_tax_detail_tbl(i).ATTRIBUTE17,
                              p_ATTRIBUTE18  => l_tax_detail_tbl(i).ATTRIBUTE18,
                              p_ATTRIBUTE19  => l_tax_detail_tbl(i).ATTRIBUTE19,
                              p_ATTRIBUTE20  => l_tax_detail_tbl(i).ATTRIBUTE20,
                              p_TAX_INCLUSIVE_FLAG  => x_tax_detail_tbl(i).TAX_INCLUSIVE_FLAG,
						p_OBJECT_VERSION_NUMBER => x_tax_detail_tbl(i).OBJECT_VERSION_NUMBER,
						p_TAX_RATE_ID => l_tax_detail_tbl(i).TAX_RATE_ID
						);

Line: 2145

                END IF;-- p_tax_control_rec.update_db

Line: 2254

		select minimum_accountable_unit,precision
		from fnd_currencies
		where currency_code = l_currency_code;

Line: 2259

		select cust_acct_site_id
		from hz_cust_site_uses
		where site_use_id = l_site_use_id;

Line: 2264

		select site_use.cust_acct_site_id,site.CUST_ACCOUNT_ID
		from HZ_cust_site_uses site_use,hz_cust_acct_sites site
		where site.CUST_ACCT_SITE_ID=site_use.CUST_ACCT_SITE_ID
		and site_use.SITE_USE_ID=l_site_use_id;

Line: 2270

		select ship_to_cust_account_id
		from aso_shipments
		where quote_header_id = l_qte_header_rec.quote_header_id
		and quote_line_id is null;

Line: 2276

		SELECT LOCATION_ID
		from HR_ORGANIZATION_UNITS
		WHERE ORGANIZATION_ID = l_qte_line_rec.organization_id;

Line: 2281

		SELECT LOCATION_ID
		FROM HR_ORGANIZATION_UNITS
		WHERE ORGANIZATION_ID=l_qte_header_rec.ORG_ID;

Line: 2286

		Select CLASSIFICATION_CODE
		FROM ZX_PRODUCT_TYPES_DEF_V
		WHERE INVENTORY_ITEM_ID = l_qte_line_rec.INVENTORY_ITEM_ID
		AND ORG_ID= l_qte_line_rec.organization_id;

Line: 2292

		select LOCATION_ID
		FROM hz_party_sites
		WHERE party_site_id=l_party_site_id;

Line: 2297

		select TAX_EXEMPT_FLAG,TAX_EXEMPT_NUMBER,TAX_EXEMPT_REASON_CODE
		from aso_tax_details
		WHERE QUOTE_LINE_ID is null
		AND quote_header_id=p_qte_header_id;

Line: 2303

		select cust_trx_type_id
		from ra_cust_trx_types
		where cust_trx_type_id = l_trx_type_id
		and (tax_calculation_flag = 'Y');

Line: 2309

		select set_of_books_id
		from ar_system_parameters;

Line: 2313

		select INVOICE_SOURCE_ID
		FROM OE_TRANSACTION_TYPES
		WHERE TRANSACTION_TYPE_ID=l_qte_header_rec.ORDER_TYPE_ID;

Line: 2320

          SELECT resource_id
          FROM aso_quote_headers_all trx
          WHERE trx.quote_header_id = l_qte_hdr_id;

Line: 2325

          SELECT per.organization_id
          FROM jtf_rs_srp_vl sales, per_all_assignments_f per
          WHERE sales.resource_id =  l_source_id
          AND per.person_id = sales.person_id
          AND nvl(per.primary_flag,'Y') = 'Y'
          AND sysdate  BETWEEN nvl(per.effective_start_date,sysdate) AND nvl(per.effective_end_date,sysdate);

Line: 2333

          SELECT hr.location_id
          FROM hr_organization_units hr
          WHERE hr.organization_id = l_party_id;

Line: 2448

		select location_id
		into l_bill_from_location_id
		from HR_ALL_ORGANIZATION_UNITS
		where organization_id = l_qte_line_tbl(1).organization_id;

Line: 2467

		aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After selecting from AR_SYSTEM_PARAMETERS table', 1, 'Y');

Line: 2584

	--Insertion into the Header Temporary Table.

 	IF aso_debug_pub.g_debug_flag ='Y' THEN
                aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: BEFORE INSERTION INTO ZX_TRX_HEADERS_GT temporary table  ', 1, 'Y');

Line: 2590

	DELETE FROM ZX_TRX_HEADERS_GT where
	APPLICATION_ID=697 and
	ENTITY_CODE= 'ASO_QUOTE_HEADERS_ALL' and
	EVENT_CLASS_CODE= 'SALES_TRANSACTION_TAX_QUOTE' and
	TRX_ID=	p_qte_header_id;

Line: 2596

	insert into ZX_TRX_HEADERS_GT
	(
		INTERNAL_ORGANIZATION_ID,
		INTERNAL_ORG_LOCATION_ID,
		APPLICATION_ID,
		ENTITY_CODE,
		EVENT_CLASS_CODE,
		EVENT_TYPE_CODE,
		TRX_ID,
		TRX_DATE,
		LEDGER_ID,
		TRX_CURRENCY_CODE,
		CURRENCY_CONVERSION_DATE,
		CURRENCY_CONVERSION_RATE,
		CURRENCY_CONVERSION_TYPE,
		MINIMUM_ACCOUNTABLE_UNIT,
		PRECISION,
		LEGAL_ENTITY_ID,
		QUOTE_FLAG,
		TRX_NUMBER,
		FIRST_PTY_ORG_ID,
		TAX_EVENT_TYPE_CODE,
		VALIDATION_CHECK_FLAG,
		TAX_REPORTING_FLAG,
		SHIP_TO_CUST_ACCT_SITE_USE_ID,
		BILL_TO_CUST_ACCT_SITE_USE_ID,
		DOC_LEVEL_RECALC_FLAG,
		SHIP_THIRD_PTY_ACCT_SITE_ID,
		BILL_THIRD_PTY_ACCT_SITE_ID,
		SHIP_THIRD_PTY_ACCT_ID,
		BILL_THIRD_PTY_ACCT_ID,
		ROUNDING_BILL_TO_PARTY_ID
	)
	values
	(
		l_qte_header_rec.ORG_ID,
		l_int_org_location,
		697,
		'ASO_QUOTE_HEADERS_ALL',
		'SALES_TRANSACTION_TAX_QUOTE',
		'CREATE',
		p_qte_header_id,
		sysdate,
		l_set_of_books_id,
		l_qte_header_rec.CURRENCY_CODE,
		l_qte_header_rec.EXCHANGE_RATE_DATE,
		l_qte_header_rec.EXCHANGE_RATE,
		l_qte_header_rec.EXCHANGE_TYPE_CODE,
		l_minimum_accountable_unit,
		l_precision,
		l_legal_entity_id,
		'Y',
		l_qte_header_rec.QUOTE_NUMBER,
		null,
		'CREATE',
		null,
		'N',
		l_site_use_id_ship_header,
		l_site_use_id_bill_header,
		'N',
		l_acct_site_id_ship,
		l_acct_site_id_bill,
		l_ship_cust_account_id_header,
		l_qte_header_rec.INVOICE_TO_CUST_ACCOUNT_ID,
		l_qte_header_rec.INVOICE_TO_CUST_PARTY_ID
	);

Line: 2668

	DELETE FROM  Zx_transaction_lines_gt
	WHERE  APPLICATION_ID= 697
	AND ENTITY_CODE=  'ASO_QUOTE_HEADERS_ALL'
	AND EVENT_CLASS_CODE = 'SALES_TRANSACTION_TAX_QUOTE'
	AND TRX_ID = p_qte_header_id
	AND TRX_LEVEL_TYPE= 'LINE';

Line: 2854

               aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE INSERTING INTO Zx_transaction_lines_gt ', 1, 'Y');

Line: 2884

		--Insertion into the Lines Temporary Table
		insert into Zx_transaction_lines_gt
		(
			APPLICATION_ID,
			ENTITY_CODE,
			EVENT_CLASS_CODE,
			TRX_ID,
			TRX_LEVEL_TYPE,
			TRX_LINE_ID,
			LINE_LEVEL_ACTION,
			LINE_CLASS,
			TRX_SHIPPING_DATE,
			TRX_LINE_TYPE,
			TRX_LINE_DATE,
			TRX_BUSINESS_CATEGORY,
			LINE_AMT,
			TRX_LINE_QUANTITY,
			EXEMPT_CERTIFICATE_NUMBER,
			EXEMPT_REASON_CODE,
			PRODUCT_ID,
			PRODUCT_ORG_ID,
			UOM_CODE,
			--PRODUCT_TYPE,
			FOB_POINT,
			SHIP_TO_PARTY_ID,
			SHIP_FROM_PARTY_ID,
			BILL_TO_PARTY_ID,
			SHIP_TO_PARTY_SITE_ID,
			BILL_TO_PARTY_SITE_ID,
			SHIP_TO_LOCATION_ID,
			BILL_TO_LOCATION_ID,
			SHIP_FROM_LOCATION_ID,
			HISTORICAL_FLAG,
			LINE_AMT_INCLUDES_TAX_FLAG,
			EXEMPTION_CONTROL_FLAG,UNIT_PRICE,
			TRX_LINE_GL_DATE,
			RECEIVABLES_TRX_TYPE_ID,
			BILL_TO_CUST_ACCT_SITE_USE_ID,
			SHIP_TO_CUST_ACCT_SITE_USE_ID,
			SHIP_THIRD_PTY_ACCT_SITE_ID,
			BILL_THIRD_PTY_ACCT_SITE_ID,
			SHIP_THIRD_PTY_ACCT_ID,
			BILL_THIRD_PTY_ACCT_ID,
			CTRL_HDR_TX_APPL_FLAG,
			TRX_LINE_NUMBER,
			POO_LOCATION_ID,
			POO_PARTY_ID,
			POA_PARTY_ID,
			POA_LOCATION_ID,
			OUTPUT_TAX_CLASSIFICATION_CODE,
			 BILL_FROM_LOCATION_ID --bug7408162
		)
		values
		(
			697,
			'ASO_QUOTE_HEADERS_ALL',
			'SALES_TRANSACTION_TAX_QUOTE',
			p_qte_header_id,
			'LINE',
			l_qte_line_rec.QUOTE_LINE_ID,
			'CREATE',
			'INVOICE',
			nvl(l_Shipment_Rec.REQUEST_DATE,l_Shipment_header_rec.request_date),
			'ITEM',
			SYSDATE,
			null,
			l_qte_line_rec.LINE_QUOTE_PRICE*l_qte_line_rec.QUANTITY,
			l_qte_line_rec.QUANTITY,
			l_HDR_TAX_EXEMPT_NUMBER,
			l_HDR_TAX_EXEMPT_REASON_CODE,
			l_qte_line_rec.INVENTORY_ITEM_ID,
			l_qte_line_rec.organization_id,
			l_qte_line_rec.UOM_CODE,
		--	l_product_type,
			nvl(l_Shipment_Rec.fob_code,l_Shipment_header_rec.fob_code),
			nvl(l_Shipment_Rec.ship_to_cust_party_id,l_Shipment_header_rec.ship_to_cust_party_id),
			nvl(l_Shipment_Rec.ship_from_org_id,l_Shipment_header_rec.ship_from_org_id),
			nvl(l_qte_line_rec.INVOICE_TO_CUST_PARTY_ID,l_qte_header_rec.INVOICE_TO_CUST_PARTY_ID),
			nvl(l_Shipment_Rec.SHIP_TO_PARTY_SITE_ID,l_Shipment_header_rec.SHIP_TO_PARTY_SITE_ID),
			nvl(l_qte_line_rec.INVOICE_TO_PARTY_SITE_ID,l_qte_header_rec.INVOICE_TO_PARTY_SITE_ID),
			l_ship_to_location,
			l_bill_to_location,
			l_SHIP_FROM_LOCATION_ID,
			'N',
			'S',
			nvl(l_HDR_TAX_EXEMPT_FLAG,'S'),
			l_qte_line_rec.LINE_QUOTE_PRICE,
			sysdate,
			l_ra_cust_trx_type_id,
			l_site_use_id_bill_lines,
			l_site_use_id_ship_lines,
			l_acct_site_id_ship_lines,
			l_acct_site_id_bill_lines,
			l_ship_cust_acct_id_lines,
			l_bill_cust_acct_id_lines,
			'N',
			l_qte_line_rec.LINE_NUMBER,
               l_poo_location_id,
               l_poo_party_id,
               l_qte_header_rec.ORG_ID,
               l_int_org_location,
			l_Tax_Classification_Code,
			l_bill_from_location_id -- bug 7408162
		);

Line: 3040

			Delete from
				ASO_TAX_DETAILS
			where
				QUOTE_HEADER_ID=p_qte_header_id
			and
				QUOTE_LINE_ID=p_qte_line_id;

Line: 3051

			Delete from ASO_TAX_DETAILS
          	where QUOTE_HEADER_ID=p_qte_header_id
			and   QUOTE_LINE_ID is not null;

Line: 3057

		--Inserting the values from output temporary table into the ASO_TAX_DETAILS table.


		insert into Aso_tax_details
		(
			TAX_DETAIL_ID,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,
			LAST_UPDATE_LOGIN,PROGRAM_APPLICATION_ID,PROGRAM_UPDATE_DATE,
			QUOTE_HEADER_ID,QUOTE_LINE_ID,QUOTE_SHIPMENT_ID,TAX_CODE,TAX_RATE,
			TAX_DATE,TAX_AMOUNT,TAX_EXEMPT_NUMBER,TAX_EXEMPT_REASON_CODE,
			TAX_INCLUSIVE_FLAG,OBJECT_VERSION_NUMBER,TAX_RATE_ID,
			TAX_EXEMPT_FLAG	--Added by anrajan on 05/10/2005
		)
		select
			ASO_TAX_DETAILS_S.nextval,SYSDATE,G_USER_ID,SYSDATE,G_USER_ID,
			G_LOGIN_ID,APPLICATION_ID,sysdate,
			a.TRX_ID,a.TRX_LINE_ID,b.SHIPMENT_ID,a.TAX_RATE_CODE,a.TAX_RATE,
			a.TAX_DETERMINE_DATE,a.TAX_AMT,a.EXEMPT_CERTIFICATE_NUMBER,a.EXEMPT_REASON_CODE,
			a.TAX_AMT_INCLUDED_FLAG,a.OBJECT_VERSION_NUMBER,a.TAX_RATE_ID,
			nvl(l_HDR_TAX_EXEMPT_FLAG,'S') --Added by anrajan on 05/10/2005
		FROM
			Zx_detail_tax_lines_gt a,aso_shipments b
		WHERE
			a.TRX_ID=b.QUOTE_HEADER_ID
		AND
			a.APPLICATION_ID=697
		AND
			a.ENTITY_CODE='ASO_QUOTE_HEADERS_ALL'
		AND
			a.EVENT_CLASS_CODE='SALES_TRANSACTION_TAX_QUOTE'
		AND
			a.TRX_ID=p_qte_header_id
		AND
			(
				a.TRX_LINE_ID=b.QUOTE_LINE_ID
				OR
				(a.TRX_LINE_ID is null AND b.QUOTE_LINE_ID is null)
			)

		--AND
			--a.TRX_LEVEL_TYPE='LINE'
		;

Line: 3101

			aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :Number of rows inserted : '||sql%rowcount, 1, 'Y');

Line: 3118

			FND_MSG_PUB.Delete_Msg(l_msg_cnt1+1);

Line: 3171

	SELECT tax_detail_id FROM ASO_TAX_DETAILS
	WHERE	quote_shipment_id = p_shipment_id;

Line: 3174

	SELECT tax_detail_id FROM ASO_TAX_DETAILS
	WHERE	quote_header_id = p_qte_header_id and quote_line_id is NULL
    and quote_shipment_id = p_shipment_id;

Line: 3178

	SELECT tax_detail_id FROM ASO_TAX_DETAILS
	WHERE	quote_header_id = p_qte_header_id and quote_shipment_id = p_shipment_id
    and quote_line_id = p_qte_line_id ;

Line: 3215

	SELECT tax_code FROM ASO_TAX_DETAILS
	WHERE	quote_shipment_id = p_shipment_id ;

Line: 3218

	SELECT tax_code FROM ASO_TAX_DETAILS
	WHERE	quote_line_id = p_qte_line_id ;

Line: 3221

	SELECT tax_code FROM ASO_TAX_DETAILS
	WHERE	quote_header_id = p_qte_header_id ;

Line: 3255

	SELECT tax_exempt_flag FROM ASO_TAX_DETAILS
	WHERE	quote_shipment_id = p_shipment_id ;

Line: 3258

	SELECT tax_exempt_flag FROM ASO_TAX_DETAILS
	WHERE	quote_line_id = p_qte_line_id ;

Line: 3261

	SELECT tax_exempt_flag FROM ASO_TAX_DETAILS
	WHERE	quote_header_id = p_qte_header_id ;

Line: 3295

	SELECT tax_exempt_number FROM ASO_TAX_DETAILS
	WHERE	quote_shipment_id = p_shipment_id ;

Line: 3298

	SELECT tax_exempt_number FROM ASO_TAX_DETAILS
	WHERE	quote_line_id = p_qte_line_id ;

Line: 3301

	SELECT tax_exempt_number FROM ASO_TAX_DETAILS
	WHERE	quote_header_id = p_qte_header_id ;

Line: 3335

	SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS
	WHERE	quote_shipment_id = p_shipment_id ;

Line: 3338

	SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS
	WHERE	quote_line_id = p_qte_line_id ;

Line: 3341

	SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS
	WHERE	quote_header_id = p_qte_header_id ;

Line: 3380

    SELECT  default_inbound_line_type_id, default_outbound_line_type_id, cust_trx_type_id
    FROM    OE_TRANSACTION_TYPES_VL
    WHERE   transaction_type_id=l_order_type_Id;

Line: 3470

           SELECT NVL(lt.cust_trx_type_id, 0)
           INTO   l_cust_trx_type_id
           FROM   oe_line_types_v lt
           WHERE  lt.line_type_id = l_line_type_id;

Line: 3485

              SELECT NVL(ot.cust_trx_type_id, 0)
              INTO   l_cust_trx_type_id
              FROM   oe_order_types_v ot
              WHERE  ot.order_type_id =l_order_type_id;

Line: 3500

                SELECT NVL(FND_PROFILE.VALUE('OE_INVOICE_TRANSACTION_TYPE_ID'), 0)
                INTO l_cust_trx_type_id
                FROM DUAL;

Line: 3512

             SELECT NVL(lt.cust_trx_type_id, 0)
             INTO   l_inv_cust_trx_type_id
             FROM   oe_line_types_v lt
             WHERE  lt.line_type_id = l_line_type_id;

Line: 3523

                  SELECT NVL(DECODE(ot.order_category_code, 'RETURN',ot.cust_trx_type_id, 0), 0)
                  INTO   l_inv_cust_trx_type_id
                  FROM   oe_order_types_v ot
                  WHERE  ot.order_type_id = l_order_type_id;

Line: 3534

                SELECT nvl(ctt.credit_memo_type_id, 0)
                INTO l_cust_trx_type_id
                --FROM ra_cust_trx_types_all ctt Commented Code Yogeshwar (MOAC)
                FROM ra_cust_trx_types ctt  --New Code Yogeshwar (MOAC)
		WHERE ctt.cust_trx_type_id = l_inv_cust_trx_type_id
                AND NVL(ctt.org_id, -3114) = DECODE(ctt.cust_trx_type_id,
                                               1, -3113,
                                               2, -3113,
                                               7, -3113,
                                               8, -3113,
                                               NVL(p_qte_line_rec.org_id, -3114));

Line: 3548

                  SELECT NVL(FND_PROFILE.VALUE('OE_CREDIT_TRANSACTION_TYPE_ID'), 0)
                  INTO l_cust_trx_type_id
                  FROM DUAL;

Line: 3720

cursor c1 is select
	INTERNAL_ORGANIZATION_ID,
	INTERNAL_ORG_LOCATION_ID,
	APPLICATION_ID,
	ENTITY_CODE,
	EVENT_CLASS_CODE,
	EVENT_TYPE_CODE,
	TRX_ID,
	TRX_DATE,
	LEDGER_ID,
	TRX_CURRENCY_CODE,
	CURRENCY_CONVERSION_DATE,
	CURRENCY_CONVERSION_RATE,
	CURRENCY_CONVERSION_TYPE,
	MINIMUM_ACCOUNTABLE_UNIT,
	PRECISION,
	LEGAL_ENTITY_ID,
	QUOTE_FLAG,
	TRX_NUMBER,
	TAX_EVENT_TYPE_CODE,
	TAX_REPORTING_FLAG,
	SHIP_TO_CUST_ACCT_SITE_USE_ID,
	BILL_TO_CUST_ACCT_SITE_USE_ID,
	DOC_LEVEL_RECALC_FLAG,
	SHIP_THIRD_PTY_ACCT_SITE_ID,
	BILL_THIRD_PTY_ACCT_SITE_ID,
	SHIP_THIRD_PTY_ACCT_ID,
	BILL_THIRD_PTY_ACCT_ID,
	ROUNDING_BILL_TO_PARTY_ID
from
	ZX_TRX_HEADERS_GT
where
	TRX_ID=qte_header_id;

Line: 3754

Cursor c2 is select
	APPLICATION_ID,
	ENTITY_CODE,
	EVENT_CLASS_CODE,
	TRX_ID,
	TRX_LEVEL_TYPE,
	TRX_LINE_ID,
	LINE_LEVEL_ACTION,
	LINE_CLASS,
	TRX_SHIPPING_DATE,
	TRX_LINE_TYPE,
	TRX_LINE_DATE,
	TRX_BUSINESS_CATEGORY,
	LINE_AMT,
	TRX_LINE_QUANTITY,
	EXEMPT_CERTIFICATE_NUMBER,
	EXEMPT_REASON_CODE,
	PRODUCT_ID,
	PRODUCT_ORG_ID,
	UOM_CODE,
	PRODUCT_TYPE,
	FOB_POINT,
	SHIP_TO_PARTY_ID,
	SHIP_FROM_PARTY_ID,
	BILL_TO_PARTY_ID,
	SHIP_TO_PARTY_SITE_ID,
	BILL_TO_PARTY_SITE_ID,
	SHIP_TO_LOCATION_ID,
	BILL_TO_LOCATION_ID,
	SHIP_FROM_LOCATION_ID,
	HISTORICAL_FLAG,
	LINE_AMT_INCLUDES_TAX_FLAG,
	EXEMPTION_CONTROL_FLAG,
	UNIT_PRICE,
	TRX_LINE_GL_DATE,
	RECEIVABLES_TRX_TYPE_ID,
	BILL_TO_CUST_ACCT_SITE_USE_ID,
	SHIP_TO_CUST_ACCT_SITE_USE_ID,
	SHIP_THIRD_PTY_ACCT_SITE_ID,
	BILL_THIRD_PTY_ACCT_SITE_ID,
	SHIP_THIRD_PTY_ACCT_ID,
	BILL_THIRD_PTY_ACCT_ID,
	CTRL_HDR_TX_APPL_FLAG,
	TRX_LINE_NUMBER,
	BILL_FROM_LOCATION_ID --bug7408162
from
	Zx_transaction_lines_gt
where
	TRX_ID=qte_header_id;

Line: 3804

Cursor c3 is select
	TRX_ID,
	TRX_LINE_ID,
	TAX_RATE_CODE,
	TAX_RATE,
	TAX_DETERMINE_DATE,
	TAX_AMT,
	EXEMPT_CERTIFICATE_NUMBER,
	EXEMPT_REASON_CODE,
	TAX_AMT_INCLUDED_FLAG,
	OBJECT_VERSION_NUMBER,
	TAX_RATE_ID
from
	Zx_detail_tax_lines_gt
where
	TRX_ID=qte_header_id;

Line: 3825

			aso_debug_pub.add( '*****  After insertion into ZX_TRX_HEADERS_GTT *****',1, 'Y' );

Line: 3856

			--aso_debug_pub.add('*****INSERTED INTO ZX_TRX_HEADERS_GTT*****',1, 'Y' );

Line: 3862

			aso_debug_pub.add( '*****  After insertion into Zx_transaction_lines_gt *****',1, 'Y' );

Line: 3913

			aso_debug_pub.add( '*****  After insertion into Zx_detail_tax_lines_gt *****',1, 'Y' );