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.JA_JAINMCEN_XMLP_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 146: JAI_CMN_RG_23AC_II_TRXS RG23,

142: RT.CURRENCY_CONVERSION_DATE,
143: RT.CURRENCY_CODE CCODE,
144: JTC.ADHOC_FLAG
145: FROM
146: JAI_CMN_RG_23AC_II_TRXS RG23,
147: RCV_TRANSACTIONS RT,
148: JAI_RCV_LINE_TAXES RTL,
149: JAI_CMN_TAXES_ALL JTC
150: WHERE RG23.EXCISE_INVOICE_NO = cf_assessable_valueformula.EXCISE_INVOICE_NO

Line 205: CURSOR COUNT_EXCISE_TAXES(CP_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE) IS

201:
202: FUNCTION CF_DOCUMENT_TYPEFORMULA(VENDOR_ID IN NUMBER
203: ,RECEIPT_ID IN VARCHAR2
204: ,DOCUMENT_TYPE IN VARCHAR2) RETURN CHAR IS
205: CURSOR COUNT_EXCISE_TAXES(CP_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE) IS
206: SELECT
207: COUNT(1)
208: FROM
209: JAI_RCV_LINE_TAXES JRL,

Line 215: CURSOR COUNT_CVD_TAXES(CP_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE) IS

211: WHERE RCVT.TRANSACTION_ID = TO_NUMBER(CP_RECEIPT_ID)
212: AND RCVT.TRANSACTION_TYPE = LV_RCV_TRANSACTION_TYPE
213: AND RCVT.SHIPMENT_LINE_ID = JRL.SHIPMENT_LINE_ID
214: AND UPPER(JRL.TAX_TYPE) LIKE UPPER(LV_TAX_TYPE_EXCISE);
215: CURSOR COUNT_CVD_TAXES(CP_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE) IS
216: SELECT
217: COUNT(1)
218: FROM
219: JAI_RCV_LINE_TAXES JRL,

Line 258: CURSOR INT_ORDER_CUR(CP_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE,CP_RECEIPT_SOURCE_CODE IN RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE) IS

254: FUNCTION CF_EC_CODEFORMULA(VENDOR_ID IN NUMBER
255: ,VENDOR_SITE_ID IN NUMBER
256: ,RECEIPT_ID IN VARCHAR2
257: ,EC_CODE IN VARCHAR2) RETURN CHAR IS
258: CURSOR INT_ORDER_CUR(CP_RECEIPT_ID IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE,CP_RECEIPT_SOURCE_CODE IN RCV_SHIPMENT_HEADERS.RECEIPT_SOURCE_CODE%TYPE) IS
259: SELECT
260: DISTINCT
261: JU.EC_CODE
262: FROM

Line 326: CURSOR CUR_GET_VENDOR_NAME(CP_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.VENDOR_ID%TYPE) IS

322: HR_ALL_ORGANIZATION_UNITS HRU
323: WHERE JHRU.ORGANIZATION_ID = ABS(VENDOR_ID)
324: AND JHRU.LOCATION_ID = ABS(VENDOR_SITE_ID)
325: AND HRU.ORGANIZATION_ID = JHRU.ORGANIZATION_ID;
326: CURSOR CUR_GET_VENDOR_NAME(CP_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.VENDOR_ID%TYPE) IS
327: SELECT
328: POV.VENDOR_NAME
329: FROM
330: JAI_CMN_RG_23AC_II_TRXS RG23,

Line 330: JAI_CMN_RG_23AC_II_TRXS RG23,

326: CURSOR CUR_GET_VENDOR_NAME(CP_VENDOR_ID IN JAI_CMN_RG_23AC_II_TRXS.VENDOR_ID%TYPE) IS
327: SELECT
328: POV.VENDOR_NAME
329: FROM
330: JAI_CMN_RG_23AC_II_TRXS RG23,
331: PO_VENDORS POV
332: WHERE RG23.VENDOR_ID = POV.VENDOR_ID
333: AND RG23.VENDOR_ID = CP_VENDOR_ID;
334: V_VENDOR_NAME HR_ORGANIZATION_UNITS.NAME%TYPE;

Line 474: JAI_CMN_RG_23AC_II_TRXS A

470: CURSOR C_CHK_PARENT_INCLUDED(P_REGISTER_ID IN NUMBER) IS
471: SELECT
472: COUNT(1)
473: FROM
474: JAI_CMN_RG_23AC_II_TRXS A
475: WHERE A.ORGANIZATION_ID = P_ORGANIZATION_ID
476: AND A.LOCATION_ID = P_LOCATION_ID
477: AND REGISTER_TYPE = P_REGISTER_TYPE
478: AND A.INVENTORY_ITEM_ID <> 0

Line 504: V_ROUND_AMOUNT JAI_CMN_RG_23AC_II_TRXS.CR_BASIC_ED%TYPE := 0;

500: JAI_CMN_RG_OTHERS
501: WHERE SOURCE_REGISTER_ID = CP_REG_ID
502: AND SOURCE_TYPE = 1
503: AND TAX_TYPE IN ( LV_TAX_TYPE_EXC_EDU_CESS , LV_TAX_TYPE_CVD_EDU_CESS );
504: V_ROUND_AMOUNT JAI_CMN_RG_23AC_II_TRXS.CR_BASIC_ED%TYPE := 0;
505: V_RND_ENTRY_CNT NUMBER;
506: V_PARENT_REGISTER_ID NUMBER;
507: V_PARENT_INCLUDED_CNT NUMBER;
508: V_TOT_CENVAT_ROUND_AMOUNT NUMBER := 0;

Line 534: JAI_CMN_RG_23AC_II_TRXS

530: NVL(CR_ADDITIONAL_CVD
531: ,0) - NVL(DR_ADDITIONAL_CVD
532: ,0) ADDLCVD_AMT
533: FROM
534: JAI_CMN_RG_23AC_II_TRXS
535: WHERE EXCISE_INVOICE_NO = cf_rounded_cenvat_amtformula.EXCISE_INVOICE_NO
536: AND EXCISE_INVOICE_DATE = cf_rounded_cenvat_amtformula.EXCISE_INVOICE_DATE
537: AND INVENTORY_ITEM_ID = 0
538: AND TRANSACTION_SOURCE_NUM = 18

Line 593: JAI_CMN_RG_23AC_II_TRXS RG23,

589: WHERE SOURCE_REGISTER_ID IN (
590: SELECT
591: RG23.REGISTER_ID
592: FROM
593: JAI_CMN_RG_23AC_II_TRXS RG23,
594: JAI_CMN_VENDOR_SITES VSITE,
595: MTL_SYSTEM_ITEMS MSI,
596: JAI_INV_ITM_SETUPS JA_MSI
597: WHERE RG23.REGISTER_TYPE = P_REGISTER_TYPE

Line 679: JAI_CMN_RG_23AC_II_TRXS

675: WHERE SOURCE_REGISTER_ID IN (
676: SELECT
677: REGISTER_ID
678: FROM
679: JAI_CMN_RG_23AC_II_TRXS
680: WHERE EXCISE_INVOICE_NO = cf_sh_education_cessformula.EXCISE_INVOICE_NO
681: AND EXCISE_INVOICE_DATE = cf_sh_education_cessformula.EXCISE_INVOICE_DATE
682: AND REGISTER_TYPE = P_REGISTER_TYPE
683: AND ORGANIZATION_ID = P_ORGANIZATION_ID