APPS.JA_JAINER1_XMLP_PKG dependencies on JAI_CMN_RG_I_TRXS

Line 11: JAI_CMN_RG_I_TRXS

7: NVL(SUM(BASIC_ED)
8: ,0)
9: INTO V_BASIC_ED
10: FROM
11: JAI_CMN_RG_I_TRXS
12: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
13: AND LOCATION_ID = P_LOCATION_ID
14: AND PAYMENT_REGISTER in ( 'RG23A' , 'RG23C' )
15: AND TRUNC(CREATION_DATE) >= P_START_DATE

Line 62: LN_BASIC_ED JAI_CMN_RG_I_TRXS.BASIC_ED%TYPE;

58:
59: FUNCTION CF_CENVAT_DUTYFORMULA(CETSH IN VARCHAR2
60: ,INVENTORY_ITEM_ID IN NUMBER
61: ,UNITS IN VARCHAR2) RETURN NUMBER IS
62: LN_BASIC_ED JAI_CMN_RG_I_TRXS.BASIC_ED%TYPE;
63: BEGIN
64: SELECT
65: NVL(SUM(BASIC_ED)
66: ,0)

Line 69: JAI_CMN_RG_I_TRXS A,

65: NVL(SUM(BASIC_ED)
66: ,0)
67: INTO LN_BASIC_ED
68: FROM
69: JAI_CMN_RG_I_TRXS A,
70: JAI_INV_ITM_SETUPS C
71: WHERE A.INVENTORY_ITEM_ID = C.INVENTORY_ITEM_ID
72: AND A.ORGANIZATION_ID = C.ORGANIZATION_ID
73: AND ( C.ITEM_TARIFF = CETSH

Line 188: JAI_CMN_RG_I_TRXS A,

184: ,0) + NVL(A.OTHER_ED
185: ,0))) CENVAT_DUTY_PAYABLE
186: INTO LN_CR_BASIC_ED
187: FROM
188: JAI_CMN_RG_I_TRXS A,
189: MTL_SYSTEM_ITEMS B,
190: JAI_INV_ITM_SETUPS C
191: WHERE A.TRANSACTION_TYPE in ( 'I' , 'IA' , 'IOI' , 'PI' )
192: AND A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID

Line 1310: JAI_CMN_RG_I_TRXS JRGI,

1306: ,0) + NVL(OTHER_PURPOSE_PAY_ED_QTY
1307: ,0)) QTY_MANUFACTURED
1308: INTO LN_QTY_MFTRD
1309: FROM
1310: JAI_CMN_RG_I_TRXS JRGI,
1311: JAI_INV_ITM_SETUPS ITEMS
1312: WHERE JRGI.TRANSACTION_TYPE in ( 'R' , 'PR' , 'RA' , 'IOR' , 'CR' )
1313: AND ( JRGI.INVENTORY_ITEM_ID = CF_1FORMULA.INVENTORY_ITEM_ID
1314: OR NVL(ITEMS.ITEM_TARIFF

Line 1360: JAI_CMN_RG_I_TRXS JRGI,

1356: ,0) + NVL(OTHER_PURPOSE_PAY_ED_QTY
1357: ,0)) QTY_MANUFACTURED
1358: INTO LN_QTY_CLRD
1359: FROM
1360: JAI_CMN_RG_I_TRXS JRGI,
1361: JAI_INV_ITM_SETUPS ITEMS
1362: WHERE JRGI.TRANSACTION_TYPE in ( 'I' , 'IA' , 'PI' , 'IOI' )
1363: AND ( JRGI.INVENTORY_ITEM_ID = CF_QTY_CLEAREDFORMULA.INVENTORY_ITEM_ID
1364: OR NVL(ITEMS.ITEM_TARIFF

Line 1436: JAI_CMN_RG_I_TRXS JRGI,

1432: ,0)) DUTY_PAYABLE,
1433: SUM(NVL(JRGI.ADDITIONAL_ED
1434: ,0)) AED_DUTY_PAYABLE
1435: FROM
1436: JAI_CMN_RG_I_TRXS JRGI,
1437: JAI_INV_ITM_SETUPS ITEMS
1438: WHERE JRGI.TRANSACTION_TYPE in ( 'I' , 'PI' , 'IA' , 'IOI' )
1439: AND ( JRGI.INVENTORY_ITEM_ID = cf_duty_payableformula.INVENTORY_ITEM_ID
1440: OR ITEMS.ITEM_TARIFF = CETSH )

Line 1527: JAI_CMN_RG_I_TRXS JRGI,

1523: WHERE SOURCE_REGISTER_ID IN (
1524: SELECT
1525: REGISTER_ID_PART_II
1526: FROM
1527: JAI_CMN_RG_I_TRXS JRGI,
1528: JAI_INV_ITM_SETUPS ITEMS
1529: WHERE ( JRGI.INVENTORY_ITEM_ID = cf_other_dutiesformula.INVENTORY_ITEM_ID
1530: OR ITEMS.ITEM_TARIFF = CETSH )
1531: AND ITEMS.INVENTORY_ITEM_ID = JRGI.INVENTORY_ITEM_ID

Line 1558: JAI_CMN_RG_I_TRXS JRGI,

1554: WHERE SOURCE_REGISTER_ID IN (
1555: SELECT
1556: REGISTER_ID_PART_II
1557: FROM
1558: JAI_CMN_RG_I_TRXS JRGI,
1559: JAI_INV_ITM_SETUPS ITEMS
1560: WHERE ( JRGI.INVENTORY_ITEM_ID = cf_other_dutiesformula.INVENTORY_ITEM_ID
1561: OR ITEMS.ITEM_TARIFF = CETSH )
1562: AND ITEMS.INVENTORY_ITEM_ID = JRGI.INVENTORY_ITEM_ID

Line 3400: JAI_CMN_RG_I_TRXS JRGI,

3396: WHERE SOURCE_REGISTER_ID IN (
3397: SELECT
3398: REGISTER_ID_PART_II
3399: FROM
3400: JAI_CMN_RG_I_TRXS JRGI,
3401: JAI_INV_ITM_SETUPS ITEMS
3402: WHERE ( JRGI.INVENTORY_ITEM_ID = cf_sh_other_dutiesformula.INVENTORY_ITEM_ID
3403: OR ITEMS.ITEM_TARIFF = CETSH )
3404: AND ITEMS.INVENTORY_ITEM_ID = JRGI.INVENTORY_ITEM_ID

Line 3431: JAI_CMN_RG_I_TRXS JRGI,

3427: WHERE SOURCE_REGISTER_ID IN (
3428: SELECT
3429: REGISTER_ID_PART_II
3430: FROM
3431: JAI_CMN_RG_I_TRXS JRGI,
3432: JAI_INV_ITM_SETUPS ITEMS
3433: WHERE ( JRGI.INVENTORY_ITEM_ID = cf_sh_other_dutiesformula.INVENTORY_ITEM_ID
3434: OR ITEMS.ITEM_TARIFF = CETSH )
3435: AND ITEMS.INVENTORY_ITEM_ID = JRGI.INVENTORY_ITEM_ID