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_VAT_ACCNT_PKG dependencies on JAI_OM_WSH_LINES_ALL

Line 143: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_id%TYPE ,

139: PROCEDURE process_order_invoice
140: (
141: p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
142: p_source IN VARCHAR2 ,
143: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_id%TYPE ,
144: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
145: p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
146: -- added by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
147: -- 20-Apr-2010, add 'DEFAULT NULL' by Allen Yang for bug 9602968, begin

Line 144: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,

140: (
141: p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
142: p_source IN VARCHAR2 ,
143: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_id%TYPE ,
144: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
145: p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
146: -- added by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
147: -- 20-Apr-2010, add 'DEFAULT NULL' by Allen Yang for bug 9602968, begin
148: p_order_line_id IN JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE DEFAULT NULL ,

Line 145: p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,

141: p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
142: p_source IN VARCHAR2 ,
143: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_id%TYPE ,
144: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
145: p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
146: -- added by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
147: -- 20-Apr-2010, add 'DEFAULT NULL' by Allen Yang for bug 9602968, begin
148: p_order_line_id IN JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE DEFAULT NULL ,
149: -- 20-Apr-2010, add 'DEFAULT NULL' by Allen Yang for bug 9602968, end

Line 148: p_order_line_id IN JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE DEFAULT NULL ,

144: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
145: p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
146: -- added by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), begin
147: -- 20-Apr-2010, add 'DEFAULT NULL' by Allen Yang for bug 9602968, begin
148: p_order_line_id IN JAI_OM_WSH_LINES_ALL.ORDER_LINE_ID%TYPE DEFAULT NULL ,
149: -- 20-Apr-2010, add 'DEFAULT NULL' by Allen Yang for bug 9602968, end
150: -- added by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), end
151: p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
152: p_transaction_type IN RA_CUST_TRX_TYPES.TYPE%TYPE, -- DEFAULT 'INV' /* This parameter is used only for AR Accounting */ File.Sql.35 by Brathod

Line 153: p_vat_invoice_no IN JAI_OM_WSH_LINES_ALL.VAT_INVOICE_NO%TYPE ,

149: -- 20-Apr-2010, add 'DEFAULT NULL' by Allen Yang for bug 9602968, end
150: -- added by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), end
151: p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
152: p_transaction_type IN RA_CUST_TRX_TYPES.TYPE%TYPE, -- DEFAULT 'INV' /* This parameter is used only for AR Accounting */ File.Sql.35 by Brathod
153: p_vat_invoice_no IN JAI_OM_WSH_LINES_ALL.VAT_INVOICE_NO%TYPE ,
154: p_default_invoice_date IN DATE ,
155: p_batch_id IN NUMBER ,
156: p_called_from IN VARCHAR2 ,
157: p_debug IN VARCHAR2, -- DEFAULT 'N' File.Sql.35 by Brathod

Line 255: || Fetch the delivery information from JAI_OM_WSH_LINES_ALL and JAI_OM_WSH_LINE_TAXES

251: AND jrg.registration_type = 'TAX_TYPES' ;
252:
253:
254: /*
255: || Fetch the delivery information from JAI_OM_WSH_LINES_ALL and JAI_OM_WSH_LINE_TAXES
256: */
257: /* Bug 5739005. Added by vkantamn
258: * Included source, source_trx_type and source_table_name in the inner
259: * query for performance issue reported.

Line 280: JAI_OM_WSH_LINES_ALL jspl ,

276: jsptl.func_tax_amount ,
277: jsptl.creation_date ,
278: jtc.tax_type
279: FROM
280: JAI_OM_WSH_LINES_ALL jspl ,
281: JAI_OM_WSH_LINE_TAXES jsptl ,
282: JAI_CMN_TAXES_ALL jtc ,
283: ( --Date 14/06/2007 by sacsethi for bug 6072461 , View is replaced by subquery with vat reversal
284: SELECT jrttv1.tax_type tax_type