DBA Data[Home] [Help]

APPS.JAI_CMN_RG_23D_TRXS_PKG dependencies on MTL_SYSTEM_ITEMS

Line 101: lv_primary_uom_code MTL_SYSTEM_ITEMS.primary_uom_code%TYPE;

97: ln_quantity_issued NUMBER;
98:
99: ln_opening_balance_qty NUMBER;
100: ln_closing_balance_qty NUMBER;
101: lv_primary_uom_code MTL_SYSTEM_ITEMS.primary_uom_code%TYPE;
102:
103: vTransToPrimaryUOMConv NUMBER;
104:
105: r_last_record c_get_last_record%ROWTYPE;

Line 776: From Ic_Item_Mst a, Mtl_System_Items b

772: cnt Number;
773:
774: Cursor C_Item_id Is
775: Select b.Inventory_Item_Id
776: From Ic_Item_Mst a, Mtl_System_Items b
777: Where a.Item_no = b.segment1
778: And a.Item_Id = p_INVENTORY_ITEM_ID
779: And ( b.organization_Id = p_org_id
780: or b.organization_Id = 0 ) ;