DBA Data[Home] [Help]

APPS.JA_JAINER1_XMLP_PKG dependencies on MTL_SYSTEM_ITEMS

Line 189: MTL_SYSTEM_ITEMS B,

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
193: AND C.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID

Line 1711: LV_ITEM_DESC MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;

1707: RETURN NULL;
1708: END CF_CESS_UTIL_PAY_GOODSFORMULA;
1709:
1710: FUNCTION CF_ITEM_DESCRIPTION(INVENTORY_ITEM_ID IN NUMBER) RETURN CHAR IS
1711: LV_ITEM_DESC MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE;
1712: CURSOR CUR_ITEM_DESC IS
1713: SELECT
1714: MSI.DESCRIPTION
1715: FROM

Line 1716: MTL_SYSTEM_ITEMS MSI

1712: CURSOR CUR_ITEM_DESC IS
1713: SELECT
1714: MSI.DESCRIPTION
1715: FROM
1716: MTL_SYSTEM_ITEMS MSI
1717: WHERE MSI.INVENTORY_ITEM_ID = cf_item_description.INVENTORY_ITEM_ID
1718: AND MSI.ORGANIZATION_ID = P_ORGANIZATION_ID;
1719: BEGIN
1720: OPEN CUR_ITEM_DESC;