APPS.JAI_CMN_RGM_VAT_ACCNT_PKG dependencies on JAI_OM_WSH_LINES_ALL

Line 92: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_id%TYPE ,

88: PROCEDURE process_order_invoice
89: (
90: p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
91: p_source IN VARCHAR2 ,
92: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_id%TYPE ,
93: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
94: p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
95: p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
96: 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 93: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,

89: (
90: p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
91: p_source IN VARCHAR2 ,
92: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_id%TYPE ,
93: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
94: p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
95: p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
96: 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
97: p_vat_invoice_no IN JAI_OM_WSH_LINES_ALL.VAT_INVOICE_NO%TYPE ,

Line 94: p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,

90: p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ,
91: p_source IN VARCHAR2 ,
92: p_organization_id IN JAI_OM_WSH_LINES_ALL.ORGANIZATION_id%TYPE ,
93: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
94: p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
95: p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
96: 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
97: p_vat_invoice_no IN JAI_OM_WSH_LINES_ALL.VAT_INVOICE_NO%TYPE ,
98: p_default_invoice_date IN DATE ,

Line 97: p_vat_invoice_no IN JAI_OM_WSH_LINES_ALL.VAT_INVOICE_NO%TYPE ,

93: p_location_id IN JAI_OM_WSH_LINES_ALL.LOCATION_ID%TYPE ,
94: p_delivery_id IN JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE ,
95: p_customer_trx_id IN RA_CUSTOMER_TRX_ALL.CUSTOMER_TRX_ID%TYPE ,
96: 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
97: p_vat_invoice_no IN JAI_OM_WSH_LINES_ALL.VAT_INVOICE_NO%TYPE ,
98: p_default_invoice_date IN DATE ,
99: p_batch_id IN NUMBER ,
100: p_called_from IN VARCHAR2 ,
101: p_debug IN VARCHAR2, -- DEFAULT 'N' File.Sql.35 by Brathod

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

190: AND jrg.registration_type = 'TAX_TYPES' ;
191:
192:
193: /*
194: || Fetch the delivery information from JAI_OM_WSH_LINES_ALL and JAI_OM_WSH_LINE_TAXES
195: */
196: /* Bug 5739005. Added by vkantamn
197: * Included source, source_trx_type and source_table_name in the inner
198: * query for performance issue reported.

Line 219: JAI_OM_WSH_LINES_ALL jspl ,

215: jsptl.func_tax_amount ,
216: jsptl.creation_date ,
217: jtc.tax_type
218: FROM
219: JAI_OM_WSH_LINES_ALL jspl ,
220: JAI_OM_WSH_LINE_TAXES jsptl ,
221: JAI_CMN_TAXES_ALL jtc ,
222: ( --Date 14/06/2007 by sacsethi for bug 6072461 , View is replaced by subquery with vat reversal
223: SELECT jrttv1.tax_type tax_type