[Home] [Help]
759: jrct.location_id ,
760: jrttv.regime_id ,
761: jtc.tax_type
762: FROM
763: JAI_AR_TRXS jrct ,
764: JAI_AR_TRX_LINES jrctl ,
765: JAI_AR_TRX_TAX_LINES jrcttl ,
766: JAI_CMN_TAXES_ALL jtc ,
767: jai_regime_tax_types_v jrttv
1296: ln_reg_id NUMBER;
1297: /*
1298: || Check that the document has has TCS type of tax.
1299: */
1300: CURSOR cur_chk_tcs_applicable ( cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE )
1301: IS
1302: SELECT
1303: gl_dist.gl_date ,
1304: jrct.organization_id
1303: gl_dist.gl_date ,
1304: jrct.organization_id
1305: FROM
1306: ra_cust_trx_line_gl_dist_all gl_dist ,
1307: JAI_AR_TRXS jrct ,
1308: JAI_AR_TRX_LINES jrctl ,
1309: JAI_AR_TRX_TAX_LINES jrcttl ,
1310: JAI_CMN_TAXES_ALL jtc ,
1311: jai_regime_tax_types_v jrttv
1335:
1336: /*
1337: ||Check whether TCS on the invoice/DEbit memo have been settled.
1338: */
1339: CURSOR cur_chk_tcs_settlement ( cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE )
1340: IS
1341: SELECT
1342: '1'
1343: FROM
1349: /*
1350: ||Now that some lines have got TCS type of taxes , check that all lines have got tcs type of taxes
1351: ||if any one line does not have TCS type of tax then throw an error
1352: */
1353: CURSOR cur_chk_tcs_for_all_lines (cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE )
1354: IS
1355: SELECT
1356: 1
1357: FROM
1401: /*******
1402: || Validate that the inventory_items for all lines of the invoice should have the same TCS item classification
1403: || for the same has already been settled
1404: ********/
1405: CURSOR cur_validate_all_items ( cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE )
1406: IS
1407: SELECT
1408: organization_id ,
1409: inventory_item_id
1407: SELECT
1408: organization_id ,
1409: inventory_item_id
1410: FROM
1411: JAI_AR_TRXS jrct ,
1412: JAI_AR_TRX_LINES jrctl
1413: WHERE
1414: jrct.customer_trx_id = cp_customer_trx_id
1415: AND jrct.customer_trx_id = jrctl.customer_trx_id;
1849: gl_dist.amount
1850: FROM
1851: ra_customer_trx_all rcta ,
1852: ra_cust_trx_line_gl_dist_all gl_dist ,
1853: JAI_AR_TRXS jrct ,
1854: JAI_AR_TRX_LINES jrctl ,
1855: JAI_AR_TRX_TAX_LINES jrcttl ,
1856: JAI_CMN_TAXES_ALL jtc ,
1857: jai_regime_tax_types_v jrttv
1937: ln_sign_of_app_fr_doc NUMBER(3) ;
1938: ln_sign_of_app NUMBER(3) ;
1939: lv_exists VARCHAR2(1) ;
1940: ln_app_fr_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1941: ln_app_fr_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1942: ln_app_fr_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1943: ln_app_fr_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1944:
1945: ln_app_to_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1943: ln_app_fr_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1944:
1945: ln_app_to_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1946: ln_app_to_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1947: ln_app_to_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1948: ln_app_to_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1949:
1950: lv_app_doc_type VARCHAR2(100) ;
1951: rec_cur_chk_parent_rec CUR_CHK_PARENT_REC%ROWTYPE ;
2587: jrct.organization_id ,
2588: rctla.extended_amount line_amount ,
2589: rctla.inventory_item_id
2590: FROM
2591: JAI_AR_TRXS jrct ,
2592: ra_customer_trx_lines_all rctla
2593: WHERE
2594: jrct.customer_trx_id = rctla.customer_trx_id
2595: AND jrct.customer_trx_id = p_ract.customer_trx_id
3269: FROM
3270: ra_customer_trx_all rcta ,
3271: ra_cust_trx_types_all trx_types ,
3272: ra_cust_trx_line_gl_dist_all gl_dist ,
3273: JAI_AR_TRXS jrct ,
3274: JAI_AR_TRX_LINES jrctl ,
3275: JAI_AR_TRX_TAX_LINES jrcttl ,
3276: JAI_CMN_TAXES_ALL jtc ,
3277: jai_regime_tax_types_v jrttv
3377: FROM
3378: ra_customer_trx_all rcta ,
3379: ra_cust_trx_types_all trx_types ,
3380: ra_cust_trx_line_gl_dist_all gl_dist ,
3381: JAI_AR_TRXS jrct ,
3382: JAI_AR_TRX_LINES jrctl ,
3383: JAI_AR_TRX_TAX_LINES jrcttl ,
3384: JAI_CMN_TAXES_ALL jtc ,
3385: jai_regime_tax_types_v jrttv
4574: jrcttl.tax_amount ,
4575: jrcttl.func_tax_amount ,
4576: jrct.invoice_currency_code currency_code
4577: FROM
4578: JAI_AR_TRXS jrct ,
4579: JAI_AR_TRX_LINES jrctl ,
4580: JAI_AR_TRX_TAX_LINES jrcttl ,
4581: JAI_CMN_TAXES_ALL jtc ,
4582: jai_regime_tax_types_v jrttv