[Home] [Help]
329: jrct.location_id ,
330: jrttv.regime_id ,
331: jtc.tax_type
332: FROM
333: JAI_AR_TRXS jrct ,
334: JAI_AR_TRX_LINES jrctl ,
335: JAI_AR_TRX_TAX_LINES jrcttl ,
336: JAI_CMN_TAXES_ALL jtc ,
337: jai_regime_tax_types_v jrttv
806: ln_reg_id NUMBER;
807: /*
808: || Check that the document has has TCS type of tax.
809: */
810: CURSOR cur_chk_tcs_applicable ( cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE )
811: IS
812: SELECT
813: gl_dist.gl_date ,
814: jrct.organization_id
813: gl_dist.gl_date ,
814: jrct.organization_id
815: FROM
816: ra_cust_trx_line_gl_dist_all gl_dist ,
817: JAI_AR_TRXS jrct ,
818: JAI_AR_TRX_LINES jrctl ,
819: JAI_AR_TRX_TAX_LINES jrcttl ,
820: JAI_CMN_TAXES_ALL jtc ,
821: jai_regime_tax_types_v jrttv
845:
846: /*
847: ||Check whether TCS on the invoice/DEbit memo have been settled.
848: */
849: CURSOR cur_chk_tcs_settlement ( cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE )
850: IS
851: SELECT
852: '1'
853: FROM
859: /*
860: ||Now that some lines have got TCS type of taxes , check that all lines have got tcs type of taxes
861: ||if any one line does not have TCS type of tax then throw an error
862: */
863: CURSOR cur_chk_tcs_for_all_lines (cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE )
864: IS
865: SELECT
866: 1
867: FROM
907: /*******
908: || Validate that the inventory_items for all lines of the invoice should have the same TCS item classification
909: || for the same has already been settled
910: ********/
911: CURSOR cur_validate_all_items ( cp_customer_trx_id JAI_AR_TRXS.CUSTOMER_TRX_ID%TYPE )
912: IS
913: SELECT
914: organization_id ,
915: inventory_item_id
913: SELECT
914: organization_id ,
915: inventory_item_id
916: FROM
917: JAI_AR_TRXS jrct ,
918: JAI_AR_TRX_LINES jrctl
919: WHERE
920: jrct.customer_trx_id = cp_customer_trx_id
921: AND jrct.customer_trx_id = jrctl.customer_trx_id;
1334: gl_dist.amount
1335: FROM
1336: ra_customer_trx_all rcta ,
1337: ra_cust_trx_line_gl_dist_all gl_dist ,
1338: JAI_AR_TRXS jrct ,
1339: JAI_AR_TRX_LINES jrctl ,
1340: JAI_AR_TRX_TAX_LINES jrcttl ,
1341: JAI_CMN_TAXES_ALL jtc ,
1342: jai_regime_tax_types_v jrttv
1422: ln_sign_of_app_fr_doc NUMBER(3) ;
1423: ln_sign_of_app NUMBER(3) ;
1424: lv_exists VARCHAR2(1) ;
1425: ln_app_fr_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1426: ln_app_fr_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1427: ln_app_fr_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1428: ln_app_fr_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1429:
1430: ln_app_to_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1428: ln_app_fr_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1429:
1430: ln_app_to_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
1431: ln_app_to_itm_class JAI_AR_CASH_RECEIPTS_ALL.ITEM_CLASSIFICATION%TYPE ;
1432: ln_app_to_organization_id JAI_AR_TRXS.ORGANIZATION_ID%TYPE ;
1433: ln_app_to_inventory_item_id JAI_AR_TRX_LINES.INVENTORY_ITEM_ID%TYPE ;
1434:
1435: lv_app_doc_type VARCHAR2(100) ;
1436: rec_cur_chk_parent_rec CUR_CHK_PARENT_REC%ROWTYPE ;
2072: jrct.organization_id ,
2073: rctla.extended_amount line_amount ,
2074: rctla.inventory_item_id
2075: FROM
2076: JAI_AR_TRXS jrct ,
2077: ra_customer_trx_lines_all rctla
2078: WHERE
2079: jrct.customer_trx_id = rctla.customer_trx_id
2080: AND jrct.customer_trx_id = p_ract.customer_trx_id
2748: FROM
2749: ra_customer_trx_all rcta ,
2750: ra_cust_trx_types_all trx_types ,
2751: ra_cust_trx_line_gl_dist_all gl_dist ,
2752: JAI_AR_TRXS jrct ,
2753: JAI_AR_TRX_LINES jrctl ,
2754: JAI_AR_TRX_TAX_LINES jrcttl ,
2755: JAI_CMN_TAXES_ALL jtc ,
2756: jai_regime_tax_types_v jrttv
2852: FROM
2853: ra_customer_trx_all rcta ,
2854: ra_cust_trx_types_all trx_types ,
2855: ra_cust_trx_line_gl_dist_all gl_dist ,
2856: JAI_AR_TRXS jrct ,
2857: JAI_AR_TRX_LINES jrctl ,
2858: JAI_AR_TRX_TAX_LINES jrcttl ,
2859: JAI_CMN_TAXES_ALL jtc ,
2860: jai_regime_tax_types_v jrttv
4003: jrcttl.tax_amount ,
4004: jrcttl.func_tax_amount ,
4005: jrct.invoice_currency_code currency_code
4006: FROM
4007: JAI_AR_TRXS jrct ,
4008: JAI_AR_TRX_LINES jrctl ,
4009: JAI_AR_TRX_TAX_LINES jrcttl ,
4010: JAI_CMN_TAXES_ALL jtc ,
4011: jai_regime_tax_types_v jrttv